SQL Server Interview Questions
Questions Answers Views Company eMail

What is the default isolation level of the sql server database?

Ness Technologies,

1 3828

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

2 2194

Comment,Datatypes are unlimited



what is mean by constraints in sql?

IBM, Granada,

5 4504

What is dataset and its uses

2 2035

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 2421

How to change location of errorlog in SQL?


2 3340

check, not null,unique


2 2902

syntex of insert

7 2835

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 1508

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 6922

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

1 1453

How to truncate a table first before running a package?

1 1970

what is joins please explain breffly ??

TCS, Adaequare,

1 2848

What is the difference between Procedure and Function

TCS, Accenture, Nagarro,

4 7611

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How you trouble shoot when any job fails


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?


System variable and temporary variables


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?


Scalability, Availability, Integration with internet, etc.)?


application server is slow what may be the problem


which backup strategy you are following at ur company


What is data modeling and Reterminal integrity?


What is RMS migrations?


how can you attach more than 20 ldf files in sql server


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?


tell me the disaster recovery plan


How can we call UDF(User Define Function) using C# code in ASP.net ?


You are doing log shipping due to some reasons it is failing. How you will proceed from there