create index a on employee(dno)
In this,which index was created?
Answer Posted / hari
Noncluster index
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What does this statement do @@rowcount?
Can I save my report as html, excel or word? : sql server management studio
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
what is a deadlock? : Sql server database administration
What is difference between views and tables?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is collation sensitivity?
How can we determine what objects a user-defined function depends upon?
What does it mean if @@cursor_row returns a negative number?
What is the difference between executequery () and executeupdate ()?
Does full backup break log chain?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Is sql different from sql server?
What is difference between clustered index and non clustered index?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?