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

What is the use of toad or sqldbx.?

MCN Solutions,

1156

Write SQL queries on Self Join and Inner Join.

Aspiring Minds,

1154

Write a SQL queries on Self Join and Inner Join.

Aspiring Minds,

1042

Write a SQL query in order to merge two different columns into single column?

QuestPond,

1036

Write a program using SQL queries to find a unique entry in a table.

Tech Mahindra,

993

Write the SQL query to drop, truncate and delete table.

HPCL, Hughes Systique Corporation, Ittiam Systems,

973

Can we linked SharePoint to a SQL database?

Sans Pareil IT Services,

1028

Define ACID properties in a Database?

iNautix,

1057

How do I change my passwords (database, LDAP, and so on) without causing an outage?

IBM,

1069

How many types of the database links?

MCN Solutions,

1070

How to connect a database with sql express.?

MCN Solutions,

1062

Write a code to select distinct records without using the DISTINCT keyword.

Aspiring Minds,

1114

What is the difference between system objects and user objects?

HCL,

1159

How to manipulate data from one table to another table ?

MCN Solutions,

969

How can we use ConnectorJ JDBC Driver with MS SQL?

PUCIT,

999

Un-Answered Questions { SQL Server }

what are candidate key, alternate key and composite key? : Sql server database administration

917

How you can get the list of largest tables in a database?

1014

How can I change procedure name in sql server?

1050

How to sort query output in descending order in ms sql server?

943

Can you explain important index characteristics?

991

how you can move data or databases between servers and databases in sql server? : Sql server administration

962

What is database mirroring?

1117

What should be the fill factor for indexes created on tables? : sql server database administration

1138

What are cursors stored procedures and triggers?

1019

How to invoke a trigger on demand?

1092

Write a sql query to sort on different column name according to the parameters passed in the function?

904

Give me a SQL Query to find out the second largest company?

1165

Explain table valued parameters in sql server? Why tvp used?

1019

What do you know about system database? : SQL Server Architecture

985

What do you mean by recursive stored procedure?

948

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