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
 General SQL Server Forums
 New to SQL Server Programming
 Index in SQL 2005

Author  Topic 

rjohnson22
Starting Member

1 Post

Posted - 2007-03-21 : 22:51:21
how do you create an index in SQL over the Student table to lookup for example by last name and what is the syntax for the SQL lookup statement.

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-03-22 : 01:14:33
Are you looking for a syntax to create an index on student table?
If yes..
It depends what kind of index you want to create... cluster, non clustered , unique etc...
Check BOOKS ONLINE topic "Create index" to get complete details...


MohammedU
Go to Top of Page
   

- Advertisement -