SQL Server Interview Questions
Questions Answers Views Company eMail

What is the difference between OLEDB and ODBC


4 8327

What are mdf,ndf,ldf files and how to see the data in those files?


6 52494

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

Value Labs,


What is the difference between DTS and SSIS?


3 32766

How to Debug a Stored Procedure?


5 7798

How to link up the text file to a Database table?


2 3557

Which institute is best for SQL Server 2005 Training?

6 2895

What is user stored procedure & it purpose?


4 4304

How do we rollback the table data in SQL Server

3 13600

where do you use Isolations?give me some exmpale?

1 3110

In which year relase the 7.0& 2000 & 2005?

1 1844

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply


1 4101

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 4033

select empid empname from employee What is the result for the about query?

4 3302

can you any body tell me suppose database is suspect mode. how can take to normal?


2 3801

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

what is checksum in sql server.........???


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.


System variable and temporary variables


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?


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


which backup strategy you are following at ur company


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


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible


What is the difference between online clustering and Offline clustering?


Why do you want to join software field as you have done your BE in Electronics?


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?


role of sql sever 2005 in database rather than any other database


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A


what is isolation level at dead lock?


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