How to write a query with a right outer join in ms sql server?
How would you Update the rows which are divisible by 10, given a set of numbers in column?
What is the distinction amongst delete and truncate?
Why foreign key column allowing null values even a parent tables reference key column not having null value..
Working with TLogs
Explain “@@rowcount” and “@@error” in sql server?
What is de-normalization and when do you do it?
Explain the working of sql privileges?
how to find maximum identity number in a table ?
2 Answers JPMorgan Chase, Thomson Reuters, Wipro,
Explain what is scheduled job and how to create it?
Tell me what are the advantages of using stored procedures?
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
What is intellisense?