SQL Server Interview Questions
Questions Answers Views Company eMail

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

Ness Technologies,

1 3676

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 2046

Comment,Datatypes are unlimited



what is mean by constraints in sql?

IBM, Granada,

5 4260

What is dataset and its uses

2 1903

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 2263

How to change location of errorlog in SQL?


2 3164

check, not null,unique


2 2756

syntex of insert

7 2621

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 1351

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 6564

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

1 1338

How to truncate a table first before running a package?

1 1830

what is joins please explain breffly ??

TCS, Adaequare,

1 2682

What is the difference between Procedure and Function

TCS, Accenture, Nagarro,

4 7323

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

tell me the disaster recovery plan


What is the difference between NOROW and LOCKROW?


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram


New concepts of sql server 2005 use in your project.


Comment,Datatypes are unlimited


If user is owning any SQL Objects, can we drop that user


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


SQL Server Architecture ?


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.


on line cluster can we make if yes tell me the procedure


how to use DTS package in 2000,2005,2008 in sql server


Why we need to use secondry database file? though, we can do same work using primary database file also.


how can u get last observation in an unknown dataset ?