adspace


Can we create nonclustered index in a table without
creating a clustered index

Answer Posted / neelesh kumar

Yes, we can. for example we can use unique constraint
without any clustered index.

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to remove duplicate rows from table except one?

1096


What is self contained sub query?

1147


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1208


What is subquery? Explain the properties of a subquery?

1067


Why and when do stored procedure recompile?

1074


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1303


Equi join and non equi join is possible with sql server?

1138


What are the different types of subquery?

1239


What is a view in sql?

1046


Can one drop a column from a table?

1098


How do I start sql server 2017?

1022


What is the difference between for xml raw and for xml auto?

1125


What kind of problems occurs if we do not implement proper locking strategy?

1508


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2300


Can sql servers link to other servers like oracle?

928