SQL Server Interview Questions
Questions Answers Views Company eMail

what is difference between primary key and Unique

8 4120

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 6172

HOW TO RENAME A COLUMN NAME

3 4401




what is cluster and nin-cluster index?

4 3522

how to delete duplicate rows from table in sql server

UHG, HCL,

12 14596

What is difference beteen Migration and Upgrdation?

Satyam,

7 18696

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

4 23123

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

2 24507




What is row by row processing ?

2 5822

can primery key be a non clustered index?

10 6826

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

1 3780

can foreign key take role of primary key?

TCS, CarrizalSoft Technologies, Villa Marie,

5 6086

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

Wipro,

4 6370

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

8 4448

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

1 2008


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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.

773


How we create SQL Server 2005 Reporting Services ? Give me Sample

920


How can we call UDF(User Define Function) using C# code in ASP.net ?

4679


how can u get last observation in an unknown dataset ?

1148


how to use DTS package in 2000,2005,2008 in sql server

780






Explain Capacity planning to create a database? and how to monitor it?

2804


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?

1048


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2681


How to restore performance issues and how to check?

844


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

874


If the job running very slow what is the action you do

714


Issues related in upgrading SQL Server 2000 to 2005 / 2008

768


Delete duplicate rows without using rowid.

191


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

854


how to overcome kernel isssues

469