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 the authentication mode can be changed?

1092

Mention the differences between substr and charindex in sql server.

1000

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

880

What do you understand by triggers and mention the different types of it?

889

When do you think a developer should use sql server-based cursors?

990

Mention the differences between having and where clause.

1014

Explain the usage of floor function in sql server.

926

What do you understand by replication in sql server?

1005

What do you understand by hotfixes and patches in sql server?

928

Mention the different authentication modes in sql server.

977

Mention the 3 ways to get a count of the number of records in a table.

936

Mention a few common trace flags used with sql server?

899

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

918

What do you understand by coalesce in sql server?

1015

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

1017

Un-Answered Questions { SQL Server }

How do you check sql server is up and running?

947

Explain filestream storage of sql server 2008?

962

Do you know exporting and importing utility?

986

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1560

How can you insert null values in a column while inserting the data?

1230

What are the different editions available in sql server 2000?

1001

What is #table in sql server?

1010

State a few properties of relational databases?

1072

how many type of indexing in database?

944

How can we determine what objects a user-defined function depends upon?

966

What is primary key and example?

904

What are examples of triggers?

1032

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1004

How to turn on the mssql api module in php?

1029

How check triggers in sql server?

926

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