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 and update data into a table with "insert" and "update" statements?

1040

How to change the data type of an existing column with "alter table" statements in ms sql server?

1034

What happens when converting big values to numeric data types?

1223

Can we delete data from a view?

978

How to update multiple rows with one update statement in ms sql server?

1259

What happens if an integer is too big for int date type?

1023

Can binary strings be used in arithmetical operations?

985

What is a transact-sql statement?

1127

How to create stored procedures with parameters in ms sql server?

1150

How to specify the collation for a character data type in ms sql server?

1078

Does index slows down insert statements?

1047

What are the basic features of a trigger in ms sql server?

1264

Where is my database stored on the hard disk in ms sql server?

1106

What is a database in ms sql server?

1103

What are commonly used mssql functions in php?

1140

Un-Answered Questions { SQL Server }

Why use stored procedures in sql server?

1057

What is a self join in sql server?

1190

Difference between group by clause and having clause in SQL?

1022

Is it important for a database administrator to understand the operating system and file access?

1041

Explain how to maintain a fill factor in existing indexes?

1035

what's sql server? : Sql server database administration

1048

What is order of B+tree?

1152

What do you understand by physical_only option in dbcc checkdb?

1020

Explain use of expression builder.

1069

Can we use having clause without group by?

1030

How do I find query history in sql server?

987

What do you understand by coalesce in sql server?

1127

What is a print index?

932

What is 2nf normalization form?

1200

Explain the disadvantages/limitation of the cursor?

1006

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