SQL Server Interview Questions
Questions Answers Views Company eMail

what is difference between primary key and Unique

8 4332

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 6326

HOW TO RENAME A COLUMN NAME

3 4500




what is cluster and nin-cluster index?

4 3667

how to delete duplicate rows from table in sql server

UHG, HCL,

12 15059

What is difference beteen Migration and Upgrdation?

Satyam,

7 19058

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

4 23409

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

3 25246




What is row by row processing ?

2 5979

can primery key be a non clustered index?

10 7033

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

1 3866

can foreign key take role of primary key?

TCS, CarrizalSoft Technologies, Villa Marie,

5 6220

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

Wipro,

4 6575

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

8 4633

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

1 2099


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

how many no of arguments can be passed in procedures and functions

3635


What is RMS migrations?

1036


Delete duplicate rows without using rowid.

267


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

1740


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

730






You are doing log shipping due to some reasons it is failing. How you will proceed from there

900


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

2947


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

780


where the connection string store in the database

898


what is isolation level at dead lock?

1083


Working with TLogs

751


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

1023


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1217


How do you Implement SSIS Packages in your Project?

903


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

773