SQL Server Interview Questions
Questions Answers Views Company eMail

What is the Difference beween sql server 2005 and sql server 2008

CMC, Hitech,

3 3628

Difeerence between ssis 2005 and ssis2008?

Convergys,

1 3964

How to provide Security for package?

Convergys,

1 4754




how to get rank of diffrent student in same table based on newly inserted row in sql server2008

ABC,

4 4405

What are the dis_advantages of stored procedures, triggers, indexes?

902

OPTIMIZATION OF SP,CURSOR,TRIGGERS

1457

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

Broadridge,

2 4352

what is diffrent between store procedure and trigger

2 2650




can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 2084

what is victor class

1043

can any one say how to update the following senario I have a table in which the table structure is as follows ANAME ACCNO LOCATION ACCTYPE BAL SBanuPrakash 31518746291 Punganur deposit 4000 Sreenivas 31518746292 mahoobnagar current 14000 Ranjith 31518746293 Karimnagar Savings 2000 Giresh 31518746294 Chennai deposit 40000 Boo 31518746295 Chennai Savings 20000 Jay 31518746296 Valachari Savings 1000 tirumalraj 31518746297 Vellore Savings 8000 The senario is We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account . in the from account the amount need to be reduced and in the to account the amount needed to be added. for example for the <31518746291> the balance is <4000> for the <31518746292> the balance is <14000> after transferring the balance the details will look as follows <31518746291> <2000> <31518746292> <16000> the above mentioned two statment will come under the final result.

3 2347

syntax and example for bitmap index in sql???

1 3011

One table how may column and Primary key

3 2280

Psudo colums

HP,

1 2324

Simple example for difference between select and cursor in sql

1 2543


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1192


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

1096


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

315


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

663


what is checksum in sql server.........???

338






what are the Prerequisites for Replication?

8231


what is the sql equivaent of the dataset relation object ?

792


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

1046


Delete duplicate rows without using rowid.

135


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

573


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

781


What is the difference between NOROW and LOCKROW?

1202


optimization techinques

1236


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

605


Tell about MOM Tool(Microsoft Operator Manager)?

634