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
How to call stored procedure using http soap?
How to enter comments in transact-sql statements?
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
Tell me what are the advantages of using stored procedures?
How to use subqueries with the exists operators in ms sql server?
What is a bit datatype?
What is database dimension? : sql server analysis services, ssas
What are the different editions available in sql server 2000?
Why I am getting this error when dropping a database in ms sql server?
Explain the microsoft sql server delete command?
What is sql or structured query language?
What are the dmvs? : sql server database administration
What information is maintained within the msdb database?
How do you create type- insensitive operator?
Comment,Datatypes are unlimited
