How to create an index on an existing table in ms sql server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What do you understand by intent locks?

0 Answers  


How to modify the underlying query of an existing view?

0 Answers  


what stored procedure can you use to display the current processes? : Sql server administration

0 Answers  


What is mean by dml?

0 Answers  


List few advantages of stored procedure.

0 Answers  






What is the use of custom fields in report?

0 Answers  


Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  


What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  


What is use of except clause? How does it differ from not in clause?

0 Answers  


What is the difference between mysql and sql server?

0 Answers  


Can we use pragma autonomous_transaction in trigger?

0 Answers  


1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  


Categories