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 create a new login name in ms sql server?

1103

How to create a view with data from multiple tables?

1060

How to retrieve field values using mssql_result()?

1411

How to convert a numeric expression from one data type to another?

1089

How to join two tables in a single query in ms sql server?

1056

How to count groups returned with the group by clause in ms sql server?

1141

How to access the deleted record of an event?

1091

How to locate and take substrings with charindex() and substring() functions?

1070

How to list all tables in the database using odbc_tables()?

1113

What are approximate numeric data types in ms sql server?

1101

What are null values in ms sql server?

1140

How to set a database state to offline in ms sql server?

1101

How to list all triggers in the database with sys.triggers in ms sql server?

1123

How to verify a user name with sqlcmd tool?

1118

How to use go command in "sqlcmd"?

1261

Un-Answered Questions { SQL Server }

Where the sql logs gets stored? : sql server database administration

1012

Do you know how to store and query spatial data?

1084

Explain about analysis services?

1103

What happens if you are trying to access a schema not owned by you?

1020

What is difference between rownum and row_number?

1020

What is postgresql server?

1057

What happens if null values are involved in string operations?

1026

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

1017

what is the primary use of the model database? : Sql server administration

1094

How do you implement session management in SQL Server mode?

1148

How much is a sql server license?

1008

Write an sql query to find first weekday of the month?

975

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

937

why would you call update statistics? : Sql server database administration

1154

What are the advantages of passing name-value pairs as parameters?

1215

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