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?

1119

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

1 1821

When would you use it?

1041

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

1084

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

1163

Explain about link server in sql server?

1113

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

1 2102

What is the difference between delete and truncate statements?

1127

Explain foreign key in sql server?

1072

What is a field in a table?

1070

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

944

List the different types of joins?

1057

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

1117

What are entities and relationships?

1021

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

1218

Un-Answered Questions { SQL Server }

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2276

What is the difference between grant and with grant while giving permissions to the user?

1024

When we should use and scope of @@identity?

1041

What is xml datatype?

1129

How to download and install microsoft sql server management studio express?

1090

What does the not null constraint do?

1177

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2111

What is resource governor?

1029

What is a View ? Can we insert, Update and delete a view?

1059

What are the characteristics of modern DBMS?

1140

Can a database be shrunk with users active?

1193

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

997

what is a check constraint?

1171

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2453

What are data resources?

963

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