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 verify a login name with sqlcmd tool?

1211

How to generate create table script on an existing table in ms sql server?

1141

How to replace null values in expressions using isnull()?

1098

How to set the current database in ms sql server?

1073

What are the requirements to use odbc connections in php scripts?

1113

What is a constant or literal in ms sql server?

1040

How extra digits are handled with numeric data type literals?

960

What are ddl (data definition language) statements for tables in ms sql server?

1096

What happens when converting big values to integers?

995

How to test values returned by a subquery with the in operator?

1190

How to apply filtering criteria at group level with the having clause in ms sql server?

996

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

1011

How to test a dml trigger in ms sql server?

1037

What happens to a statement batch if there is a compilation error?

962

How to create a new table in a given schema?

1179

Un-Answered Questions { SQL Server }

What is the purpose of self join?

971

What is dbcc? Give few examples.

1023

How to get the definition of a user defined function back?

1042

What is correlated subquery in sql server?

1062

How to grant a permission in ms sql server using "grant execute" statements?

1082

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1019

How to provide column names in insert statements in ms sql server?

1148

Can we use where and having clause together?

1036

whats the maximum size of view state??

2188

Do you know what is fill factor and pad index?

996

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1057

What are the types of sql server?

1044

Give me any three differences between Truncate and Delete.

1097

What is always encrypted?

987

What is the use of sign function?

1113

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