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 do you know if sql server is running on your local system?

1091

How to get a list of columns in a view using the "sp_columns" stored procedure?

1086

How to use values from other tables in update statements in ms sql server?

1178

How to count duplicated values in a column in ms sql server?

1160

How to write a query with a left outer join in ms sql server?

1026

What to perform pattern match with the like operator?

929

How to list all field names in the result set using mssql_field_name()?

951

What happens if null values are involved in comparison operations?

1039

What is transact-sql language?

1133

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

1127

How to create a scrollable cursor with the scroll option?

1046

How to create an multi-statement table-valued function?

1046

What is a transact-sql statement batch in ms sql server?

1068

How to round a numeric value to a specific precision?

1123

What is the security model used in sql server 2005?

1066

Un-Answered Questions { SQL Server }

Define model database?

1032

What is the difference between getdate and sysdatetime?

1060

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1190

What command is used to create a database in the sql server and how?

1236

What are secondary xml indexes?

1074

Explain log shipping and mention its advantages.

1085

What is difference between index seek vs. Index scan?

1198

What do you know about normalization and de- normalization?

968

What is difference between Datepart() and Datename() in SqlServer?

1256

what is the information that can be stored inside a bit column? : Sql server database administration

1008

How to convert a unicode strings to non-unicode strings?

1151

How to loop through the result set with @@fetch_status?

1428

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1113

Can we write a distributed query and get some data which is located on other server and oracle database?

1275

How do I start sql server 2016?

950

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