Answer Posted / virgilio
A covering index is when you run a Query and you use an
indexed field in you where Clause:
*--Primary Key Creates aclustered Index
Create table Students
(
Studentid int Primary Key not Null, *
StudentName Nvarchar(20) Null,
StudentLastName Nvarchar(20) Null
)
Se;ect * from Students where StudentID = 20
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the difference between migration and upgradation in sql server?
What is partition in sql server?
What command do we use to rename a db, a table and a column?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
Tell me about joins in database system and explain each in detail.
What is rolap and its advantage? : sql server analysis services, ssas
Do you know what is a linked server in sql server?
What is sql server used for?
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
What are sql server procedures?
How to search for a string in all stored procedure in sql server?
How to create an identity column?
Is resultset an interface?
What is sqlservr.exe - process - sql server (sqlex?press)?
What happens if strings are casted into wrong code pages in ms sql server?
