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

What are the disadvantages of using the stored procedures?

1102

Distinguish between commit and rollback?

959

Explain subquery and state its properties?

1042

What do you understand by a stored procedure?

1088

What is coalesce and check constraint in sql server?

1121

What are the purposes of floor and sign functions?

976

What is a virtual table in sql?

996

Explain cdc and sql injection?

977

State the difference between local and global temporary tables?

1119

Explain cross join or cartesian product in sql?

891

What is sql server agent and what are the two modes of authentication in sql server?

1056

Explain tablesample?

995

Differentiate between truncate vs delete in mssql?

1083

How are the exceptions handled in sql server programming?

1062

Mention the uses of stored procedures.

970

Un-Answered Questions { SQL Server }

Explain how to send email from sql database?

1046

What is pessimistic concurrency?

974

What is dynamic cursor in SQL SERVER?

1079

How do we synchronize On-Premise SQL server with SQL Azure?

122

What is the maximum size per database for sql server express?

1050

How to define and use table alias names in ms sql server?

1132

If we delete pack Spec what will be the status of pack Body ?

1476

can any body tell me how to know the password of current user in sql server

2072

What is the difference between substr and charindex in the sql server?

1101

What is inline table-value user-defined function?

1110

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1076

How check triggers in sql server?

991

What programming language would you use to create embedded functions in ssrs?

184

Suggest a method of joining two tables.

1156

Sql server reporting services vs. Crystal reports.

131

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