SQL Server Interview Questions
Questions Answers Views Company eMail

What is the difference between OLEDB and ODBC


4 8408

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


6 52814

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 32902

How to Debug a Stored Procedure?


5 7926

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


2 3629

Which institute is best for SQL Server 2005 Training?

6 2968

What is user stored procedure & it purpose?


4 4363

How do we rollback the table data in SQL Server

3 13690

where do you use Isolations?give me some exmpale?

1 3160

In which year relase the 7.0& 2000 & 2005?

1 1883

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


1 4145

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 4105

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

4 3369

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


2 3864

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

What is Lock table in SQL?


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


optimization techinques


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.


where the connection string store in the database


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that


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


SQL Server Architecture ?


If we delete pack Spec what will be the status of pack Body ?


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


how to take backup bcp out for a column in table in sql server?


what is package and it uses and how can u call a package


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.


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


what are the Prerequisites for Replication?