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 5829

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 4701

Comment,Datatypes are unlimited

IBM,

2057

what is mean by constraints in sql?

Granada, IBM,

5 9126

What is dataset and its uses

2 4226

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 4883

How to change location of errorlog in SQL?

ABC, IBM,

2 6103

check, not null,unique

IBM,

2 5241

syntex of insert

7 7517

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 3271

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 9138

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

1 3270

How to truncate a table first before running a package?

1 3834

what is joins please explain breffly ??

Adaequare, TCS,

1 5068

What is the difference between Procedure and Function

Accenture, Nagarro, TCS,

4 11514

Un-Answered Questions { SQL Server }

mention different types of relationships in the dbms?

1014

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118

What is isolation levels?

1023

What does the on update no action do?

1021

What is a file group?

1085

How to execute function in stored procedure sql server?

1147

What is format parameter in ssrs?

146

What is SQL Server?

1203

Can we hide the definition of a stored procedure from a use?

1217

Where is my database stored on the hard disk in ms sql server?

1057

How exceptions can be handled in sql server programming?

1010

Do you know what are various aggregate functions that are available?

1114

What are the types of processing and explain each? : sql server analysis services, ssas

1146

What gets stored inside msdb database?

1244

What do you understand by a stored procedure?

1088

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