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

Why use “in” clause in sql server?

1071

Write an sql query to find the names of employees start with ‘a’?

1 1745

When would you use it?

994

What is the difference between ‘having’ clause and a ‘where’ clause?

1039

How to add code to the existing article (using improve article)?

1110

Explain about link server in sql server?

1056

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 2040

What is the difference between delete and truncate statements?

1082

Explain foreign key in sql server?

1028

What is a field in a table?

1040

What are a scheduled jobs or what is a scheduled tasks?

903

List the different types of joins?

1003

What is the difference between char and varchar2 datatype in sql?

1066

What are entities and relationships?

974

What is the difference between dropping a database and taking a database offline?

1173

Un-Answered Questions { SQL Server }

Can you insert NULL in unique column?

1161

What is best institute to Learn DotNET And SQL in chennai?

2161

What are the restraints imposed on the table design by a merge replication?

1038

Explain transaction server consistency?

973

How to declare and use cursor variables?

1169

Where in ms sql server is ’100’ equal to ‘0’?

1088

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

1046

How do I start sql server agent automatically?

968

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

1963

What is a unique key constraint?

1028

List some case manipulation functions in sql?

1027

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

121

Explain something about security and SQL Azure?

134

How to return the second 5 rows in ms sql server?

1058

How to create a large table with random data for index testing in ms sql server?

1031

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