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 provide default values to function parameters?

1129

How to use transact-sql statements to access the database engine?

1056

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

1092

How to connect php with different port numbers?

1075

How to fetch the next row from a cursor with a "fetch" statement?

1068

How to divide query output into multiple groups with the group by clause in ms sql server?

1028

How to modify an existing stored procedure in ms sql server?

1075

How to transfer data from a cursor to variables with a "fetch" statement?

1087

How to drop existing indexes in ms sql server?

1070

How to concatenate two binary strings together?

1114

How to defragment table indexes?

979

Is the primary key column of a table an index in ms sql server?

960

How to generate create procedure script on an existing stored procedure?

1006

How to write a query with a full outer join in ms sql server?

1069

How to concatenate two character strings together?

1110

Un-Answered Questions { SQL Server }

What is a deadlock and what is a live lock?

995

What is the use of group by clause?

936

What is Extended user-defined?

955

Can sql servers linked to other servers like oracle?

942

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1021

If user is owning any SQL Objects, can we drop that user

2064

What is the difference between seek predicate and predicate?

1049

what is package and it uses and how can u call a package

2010

What is subquery explain with example?

1054

What will be the maximum number of index per table?

996

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

972

Why normalization is used?

1005

How to list all tables in the database using odbc_tables()?

1042

What are system databases in ms sql server?

1049

What are the differences between sql server and mysql.

1086

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