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 are the joins,primary key,foriegn key, candidate key, super key and expain them?

Polaris,

6 17018

explain different types of jions with examples briefly?

Zensar,

1 6466

explain different types of jions with examples briefly?

Accenture, Excellence, Zensar,

2 8895

explain different types of jions with examples briefly?

Zensar,

3 10455

can we call functions from stored procedure in SQL Server 2005 ? How?

3 11896

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

HP,

17 49807

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 5681

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 8051

Difference between Triggers and Stored Procedure

Claimat, HCL, Protech, Silgate,

23 73462

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 7359

How to list all tables having unique constraints in any of the columns in a database.

1 4557

Advantages and Disadvantages of Cursor?

Polytechnic, TCS, Zenith,

15 100830

Write a query to delete duplicate records in SQL SERVER

Infosys,

36 76504

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 9665

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 9425

Un-Answered Questions { SQL Server }

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

How to use subqueries with the exists operators in ms sql server?

1113

How is SQL Azure different than SQL server?

223

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1024

What are sql servers used for?

1039

How sql server executes a statement with nested subqueries?

1024

What is the difference between getdate and sysdatetime?

997

How do you know if sql server is running on your local system?

1036

What is the purpose of grouping data in a report?

962

What are the main sources of data?

1088

How many joins in sql server?

938

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1165

Is mysql the same as sql server?

976

How can you list all the table constraints in a database?

934

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1012

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