SQL Server Interview Questions
Questions Answers Views Company eMail

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

CMC, Hitech,

3 3871

Difeerence between ssis 2005 and ssis2008?

Convergys,

1 4265

How to provide Security for package?

Convergys,

1 4928




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

ABC,

4 4641

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

1046

OPTIMIZATION OF SP,CURSOR,TRIGGERS

1582

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

Broadridge,

2 4698

what is diffrent between store procedure and trigger

2 2879




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 2256

what is victor class

1167

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 2555

syntax and example for bitmap index in sql???

1 3213

One table how may column and Primary key

3 2503

Psudo colums

HP,

1 2517

Simple example for difference between select and cursor in sql

1 2714


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How much memory that we are using in Logshipping Concept?

775


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4881


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

961


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

947


whats new about truncate in sql server 2008?

1385






your distribution database is full what will u do

1033


Does any body please help me what question's have asked for SSRS in the interview?

978


What is Lock table in SQL?

354


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1319


what is isolation level at dead lock?

1082


plss anybody specify tha constrian management system in dbms

885


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1418


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.

853


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2839


1 01 101 01010

829