SQL Server Interview Questions
Questions Answers Views Company eMail

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

Ness Technologies,

1 3789

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 2148

Comment,Datatypes are unlimited



what is mean by constraints in sql?

IBM, Granada,

5 4425

What is dataset and its uses

2 1998

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 2367

How to change location of errorlog in SQL?


2 3294

check, not null,unique


2 2863

syntex of insert

7 2753

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 1453

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 6828

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

1 1423

How to truncate a table first before running a package?

1 1928

what is joins please explain breffly ??

TCS, Adaequare,

1 2798

What is the difference between Procedure and Function

TCS, Accenture, Nagarro,

4 7543

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

plss anybody specify tha constrian management system in dbms


which backup strategy you are following at ur company


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .


application server is slow what may be the problem


Delete duplicate rows without using rowid.


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?


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


what are the Prerequisites for Replication?


wat wil hapn if we give the both read and deny read permission to user?


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


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?


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.


How to trouble shoot if unable to connect SQL Server