SQL Server Interview Questions
Questions Answers Views Company eMail

what is difference between primary key and Unique

8 3952

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 6072

HOW TO RENAME A COLUMN NAME

3 4293




what is cluster and nin-cluster index?

4 3401

how to delete duplicate rows from table in sql server

UHG, HCL,

12 14324

What is difference beteen Migration and Upgrdation?

Satyam,

7 18366

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

4 22907

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

2 24078




What is row by row processing ?

2 5706

can primery key be a non clustered index?

10 6658

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

1 3698

can foreign key take role of primary key?

TCS, CarrizalSoft Technologies, Villa Marie,

5 5954

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

Wipro,

4 6183

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

8 4318

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

1 1941


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1450


What is data modeling and Reterminal integrity?

619


can any body tell me how to know the password of current user in sql server

878


how can u get last observation in an unknown dataset ?

1083


query processing

956






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

1351


ow to bring suspect mode datbase online from scratch

644


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1527


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

1590


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

828


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

1047


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

4138


If user is owning any SQL Objects, can we drop that user

812


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

834


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

4583