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 5834

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 4706

Comment,Datatypes are unlimited

IBM,

2057

what is mean by constraints in sql?

Granada, IBM,

5 9151

What is dataset and its uses

2 4233

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 4889

How to change location of errorlog in SQL?

ABC, IBM,

2 6111

check, not null,unique

IBM,

2 5248

syntex of insert

7 7531

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 3275

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 9141

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

1 3274

How to truncate a table first before running a package?

1 3844

what is joins please explain breffly ??

Adaequare, TCS,

1 5077

What is the difference between Procedure and Function

Accenture, Nagarro, TCS,

4 11521

Un-Answered Questions { SQL Server }

What stored procedure would you use to view lock information?

975

How to compare the top two records using sql?

1342

Explain what stored procedure sp_replcounters is used for? : sql server replication

1518

What happens when the SQL Azure database reaches Max Size?

111

What is the difference between having clause and where clause in sql server?

1099

Explain foreign key in sql server?

1028

Can you explain what are commit and rollback in sql?

940

How to verify a login name with sqlcmd tool?

1217

What is mean by candidate key?

1011

what's sql server? : Sql server database administration

995

what are the core components of SSRS?

129

How to restore performance issues and how to check?

2003

How to get a list all databases on the sql server?

1099

What are SSL and TSL protocols?

985

How to recompile stored procedure at run time?

1074

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