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 update existing rows in a table?

1 1703

How to perform key word search in tables?

1009

How to display a past time in days, hours and minutes?

1064

How to query multiple tables jointly?

1044

How to get the number of affected rows?

1057

How to insert data into an existing table?

1031

How to include date and time values in sql statements?

1146

How to include text values in sql statements?

1098

How to loop through returning rows?

1091

How to drop an existing table?

1056

How to insert data with null values?

1082

How to insert multiple rows with a subquery?

1193

How to delete existing rows in a table?

1254

How to create an identity column?

1306

How to make a column nullable?

1184

Un-Answered Questions { SQL Server }

Can sql servers link to other servers like oracle?

898

what is the difference between count(*) and count(1) ?

1130

Can we use pragma autonomous_transaction in trigger?

1018

Explain the truncate command? : SQL Server Architecture

1236

Different types of keys in SQL?

1149

What is an example of a foreign key?

1033

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1122

What is set nocount on?

997

Difference between 2NF &3NF ?

1132

whats new about truncate in sql server 2008?

2561

Does a sql server 2005 select statement require a from?

1073

What is ms sql server service broker?

1048

A trigger can reference objects outside the current database? State true or false.

1062

How to create new table with "create table" statements?

1200

What is the difference between SQL notification and SQL invalidation?

1269

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