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
What do you understand by intent locks?
How to modify the underlying query of an existing view?
what stored procedure can you use to display the current processes? : Sql server administration
What is mean by dml?
List few advantages of stored procedure.
What is the use of custom fields in report?
Your table has a large character field there are queries that use this field in their search clause what should you do?
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?
What is use of except clause? How does it differ from not in clause?
What is the difference between mysql and sql server?
Can we use pragma autonomous_transaction in trigger?
1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format