Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 clustered index

Author  Topic 

thaniparthi.rao
Yak Posting Veteran

96 Posts

Posted - 2008-04-13 : 06:40:09
Why can we have only one clustered index per table

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-04-13 : 08:11:54
because the clustered index is the physical order of the data stored in the table

Em
Go to Top of Page

velliraj
Yak Posting Veteran

59 Posts

Posted - 2008-04-13 : 08:20:11
I need to write script to get records from already existing data
Go to Top of Page

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-04-13 : 08:25:52
quote:
Originally posted by velliraj

I need to write script to get records from already existing data



start a new thread and provide more information about your problem

Em
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-13 : 16:16:31
>> I need to write script to get records from already existing data

Take look at select statement in books online.
Go to Top of Page
   

- Advertisement -