SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 3804

one table has four field id,name,design,salary. i have to find maximum salary .

6 7729

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 10613

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 4905

How to find the date and time of last updated table?

Teledata,

6 9724

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 23881

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 9208

What value could be assigned to Varchar Type?

3 5920

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 5531

What types of integrity are enforced by a foreign-key constraint

1 4263

What are the main control-of-flow T-SQL constructs?

1 4814

What are the two virtual tables SQL Server maintains for triggers?

3 8500

What does the INSTEAD OF trigger do?

3 7625

What are explicit and implicit transactions?

BirlaSoft,

4 22124

What are the two types of concurrency?

4 8087

Un-Answered Questions { SQL Server }

How to execute multiple stored procedures at one time in sql server?

1011

What is trigger and different types of Triggers?

1146

Explain about builtinadministrator?

1053

How to delete existing rows in a table?

1160

What are the character string functions supported by sql server 2005?

1013

How to retrieve error messages using odbc_errormsg()?

1058

List few advantages of stored procedure.

981

how would you store your query in an SSRS report or a Database server?

162

What are transactions in sql?

1060

How to connect sql server management studio express to sql server 2005 express?

1042

Give main differences between "Truncate" and "Delete".

1099

How to drop existing views from a database in ms sql server?

1103

What is the difference between for xml raw and for xml auto?

1031

How do I install sql server?

890

What is the dbcc command and why is it used?

1052

For More Un-Answered { SQL Server } Questions Click Here