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 9153

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 4890

How to change location of errorlog in SQL?

ABC, IBM,

2 6112

check, not null,unique

IBM,

2 5249

syntex of insert

7 7532

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 3845

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 }

How to use values from other tables in update statements in ms sql server?

1117

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2147

Sql server reporting services vs. Crystal reports.

131

Which is the main third-party tool used in sql server?

942

What is the name of reporting services config file and what’s it’s used for?

146

what is the system function to get the current user's user id? : Sql server database administration

1022

Explain what is the purpose of sql profiler in sql server?

1074

What is the use of sign function?

1124

How are the exceptions handled in sql server programming?

1062

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1038

What is the default server name for sql server?

1166

How to delete existing rows in a table?

1158

How do I clean up sql server transaction log?

1066

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1010

What is inner join in sql server joins?

1035

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