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?

1054

How to create a view with data from multiple tables?

1010

How to retrieve field values using mssql_result()?

1305

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

1008

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

989

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

1059

How to access the deleted record of an event?

1031

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

1011

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

1042

What are approximate numeric data types in ms sql server?

1051

What are null values in ms sql server?

1079

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

1038

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

1073

How to verify a user name with sqlcmd tool?

1072

How to use go command in "sqlcmd"?

1198

Un-Answered Questions { SQL Server }

Where are full-text indexes stored?

985

what is the main function of a query parameter?

152

List some advantages and disadvantages of stored procedure?

1014

optimization techinques

2665

Define primary key?

1128

What is user-defined scalar function?

958

What stored by the master?

945

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1064

How to create a dml trigger using create trigger statements?

1028

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

1057

What do you understand by mirroring and mention the advantages of the mirroring?

1062

What are trace flags?

1026

How do I shrink an ldf file?

978

Why do we need different type of parameter?

1051

Can I work with several databases simultaneously? : sql server management studio

981

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