SQL Server Interview Questions
Questions Answers Views Company eMail

What is the difference between OLEDB and ODBC

CFCI,

4 8408

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

Accenture,

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,

1251




What is the difference between DTS and SSIS?

Allianz,

3 32902

How to Debug a Stored Procedure?

Allianz,

5 7926

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

Allianz,

2 3629

Which institute is best for SQL Server 2005 Training?

6 2968

What is user stored procedure & it purpose?

Wipro,

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

Covansys,

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?

Teledata,

2 3864


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is Lock table in SQL?

199


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

339


optimization techinques

1236


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.

1305


where the connection string store in the database

758






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

616


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

781


SQL Server Architecture ?

1081


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

131


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

4137


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

804


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

835


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.

605


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

1589


what are the Prerequisites for Replication?

8233