How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1102

Comment,Datatypes are unlimited

2055

Explain about extended stored procedure?

931

How to create hyperlink from returned sql query ?

1117

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

310

What is the difference between primary key and unique constraints?

951

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1121

What is the sql case statement used for? Explain with an example?

990

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

901

What is the difference between osql and query analyzer?

983

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1739

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

190

Explain transaction server isolation?

1019

What is the cartesian product of the table?

948

What do you mean by table and field in sql?

999