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

How to Insert multiple rows with a single insert statement?

1054

What is autocommit mode in sql server?

1175

How to get @@error and @@rowcount at the same time?

1035

What is temporary stored procedure?

948

Explain query editor regions

1043

Which are the important points to note when multilanguage data is stored in a table?

996

What is default constraint?

995

Explain table valued parameters in sql server? Why tvp used?

1019

How to return the date part only from a sql server datetime datatype?

1103

What is difference between delete and truncate commands?

1082

What is implicit mode in sql server?

1105

What is Extended user-defined?

959

what is hash nonclustered index

968

Find columns used in stored procedure?

991

How to rebuild the master database?

1080

Un-Answered Questions { SQL Server }

How to make remote connection in database?

1005

What are the different normalization forms?

1110

What is the xml datatype?

1070

mention different types of relationships in the dbms?

1020

What is a view in sql?

976

Explain what is cte (common table expression)?

1131

what is normalization? : Sql server database administration

1095

What is a trigger in sql server?

1172

How can windows applications connect to sql servers via odbc?

1125

How to write character string constants or literals in ms sql server?

1019

Mention the 3 ways to get a count of the number of records in a table.

977

How do I get to sql server configuration manager?

1009

How to create a trigger for insert only?

1038

How to create a stored procedure with a statement block in ms sql server?

1070

How do you size a resultset?

914

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