SQL Server Interview Questions
Questions Answers Views Company eMail

what is difference between primary key and Unique

8 3879

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

SAP Labs,

3 6025


3 4242

what is cluster and nin-cluster index?

4 3346

how to delete duplicate rows from table in sql server


12 14169

What is difference beteen Migration and Upgrdation?


7 18136

What are different types of Keys? Please explain all the keys with a suitable example.

4 22794

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

2 23640

What is row by row processing ?

2 5646

can primery key be a non clustered index?

10 6546

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 3666

can foreign key take role of primary key?

TCS, CarrizalSoft Technologies, Villa Marie,

5 5890

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?


4 6087

How to find out name of all employees who has salary less than 200 Rs.?

8 4250

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 1903

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How to convert a table data in XML format in sql server?


Tell about MOM Tool(Microsoft Operator Manager)?


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?


what is the sql equivaent of the dataset relation object ?


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?


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?


What is Lock table in SQL?


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks


how to do partition in sqlserver


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.


How to restore performance issues and how to check?


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


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