Database

SVb.net wrote:

what's different between index and primarykey?

John Prabhu wrote:

Clustered Index against the Column

xmen_xwk wrote:

can you please explain in details ?

Initially when a new table is created, there is no index created by default. As I said in the previous post that an Index is a Reference created by the Database engine for reference, Just like an Index in the book to locate the information. there are 2 types of Indexes created in an Sql Server table - Clustered and Non-Clustered. As I said that When you create a Primary key on a table, By default a clustered Index is created on the table. A Clustered Index is similar to a dictionary. In a dictionary, the words are organized and sorted alphabetically. Same way on Clustered Index Column the records are sorted in the same order as the indexed order of the rows.

AND p.ID in (<br />
case @pList<br />
when '' then p.ID<br />
else (select id from dbo.fn_split_id_integer(@pList))<br />
end)

select ...
where p.ID in (
    select id from dbo.fn_split_id_integer(@pList)
    union all
    select ID from MyTable where @pList = ''
    )
...
order by ...

Update tablename Set Memeber_Id = substring(Memeber_Id,2,len(Memeber_Id-1))

kibromg wrote:

Memberid Nvarchar(50).