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 is the default isolation level of the sql server database?

1 5901

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 4799

Comment,Datatypes are unlimited

IBM,

2106

what is mean by constraints in sql?

Granada, IBM,

5 9336

What is dataset and its uses

2 4314

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 4995

How to change location of errorlog in SQL?

ABC, IBM,

2 6207

check, not null,unique

IBM,

2 5349

syntex of insert

7 7716

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 3418

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

Cap Gemini, TCS,

1 9207

what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 3346

How to truncate a table first before running a package?

1 3910

what is joins please explain breffly ??

Adaequare, TCS,

1 5183

What is the difference between Procedure and Function

Accenture, Nagarro, TCS,

4 11672

Un-Answered Questions { SQL Server }

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1049

What are synonyms?

1015

How to recompile stored procedure at run time?

1116

What is indexing a document?

1088

Can group functions be mixed with non-group selection fields in ms sql server?

997

Can I work with several databases simultaneously? : sql server management studio

1029

How to install sql server 2005 express edition?

1168

What is the difference between a check constraint and a rule?

1349

How to perform key word search in tables?

1002

How to create nested stored procedure?

1071

Do you know exporting and importing utility?

1105

What is query processing?

989

How can we delete Duplicate row in table?

1112

Explain mixed authentication mode of sql server?

1116

What are the operating modes in which database mirroring runs?

1137

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