Thursday, 4 July 2013

Create NONCLUSTERED index in sql server

CREATE UNIQUE NONCLUSTERED INDEX [IX_TableName_FieldName]
ON [dbo].[TableName]
(
[FieldName] ASC
) WITH (IGNORE_DUP_KEY = ON) ON [PRIMARY]

No comments:

Post a Comment

How to highlight selected text in notepad++

  –> To highlight a block of code in Notepad++, please do the following steps step-1  :- Select the required text. step-2  :- Right click...