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

IBM,

909




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?

ABC, IBM,

2 3294

check, not null,unique

IBM,

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

809


which backup strategy you are following at ur company

977


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

296


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

831


application server is slow what may be the problem

1073






Delete duplicate rows without using rowid.

176


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?

1240


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

802


what are the Prerequisites for Replication?

8403


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

920


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

4193


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?

1035


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., }

1048


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.

649


How to trouble shoot if unable to connect SQL Server

755