SQL Server Interview Questions
Questions Answers Views Company eMail

what is difference between primary key and Unique

8 4244

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 6250

HOW TO RENAME A COLUMN NAME

3 4449




what is cluster and nin-cluster index?

4 3599

how to delete duplicate rows from table in sql server

UHG, HCL,

12 14833

What is difference beteen Migration and Upgrdation?

Satyam,

7 18884

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

4 23259

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

3 24852




What is row by row processing ?

2 5894

can primery key be a non clustered index?

10 6946

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

1 3818

can foreign key take role of primary key?

TCS, CarrizalSoft Technologies, Villa Marie,

5 6158

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

Wipro,

4 6489

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

8 4537

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

1 2052


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

819


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

907


tell me the disaster recovery plan

1323


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

899


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

1147






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

932


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

859


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.

733


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?

978


where the connection string store in the database

858


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

4301


Which is the best place or learning center for MS SQL?????In Bangladesh?????

909


wat wil hapn if we give the both read and deny read permission to user?

976


How to trouble shoot if unable to connect SQL Server

810


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.

816