What are trace flags and mention a few common trace flags used with sql server?
Explain about temporary stored procedure?
How to see existing views in ms sql server?
how will add additional conditions in sql?
0 Answers Amdocs, Apps Associates,
What is advantage data architect?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What is triggers and stored procedures?
What is inner join? Explain with an example?
Comment,Datatypes are unlimited
Can select statements be used on views in ms sql server?
Name three version of sql server 2000 and also their differences?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is set nocount on and what is set nocount off?