What is a periodical index?
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?
How to convert character strings into numeric values?
i need some interview questions on sql server developer plz any onee send some links.
Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY
What is SCOPE_IDENTITY() in sql
Can we use where clause with group by?
Which stored procedure will you be running to add a linked server?
Determine when to use stored procedure to complete sql server tasks?
Is it safe to delete log files?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What are the properties of the transactions?
How to verify a login name with sqlcmd tool?