Can group functions be mixed with non-group selection fields in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is the importance of a recovery model?
What is the maximum rows in sql server table?
Explain log shipping and mention its advantages.
find the 3rd max salary
Differentiate between SQL and ORACLE joins and write their syntax.
What are the recovery models in sql server 2000?
Where are sql server user names and passwords stored in sql server?
What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table
What are the different SQL Server Versions you have worked on?
How do you optimize Sql queries ?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Give a example to search fr a string in all stored procedure in sql server.