SQL Server Interview Questions
Questions Answers Views Company eMail

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

CMC, Hitech,

3 3667

Difeerence between ssis 2005 and ssis2008?

Convergys,

1 4022

How to provide Security for package?

Convergys,

1 4786




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

ABC,

4 4447

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

935

OPTIMIZATION OF SP,CURSOR,TRIGGERS

1479

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

Broadridge,

2 4437

what is diffrent between store procedure and trigger

2 2681




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 2114

what is victor class

1066

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 2380

syntax and example for bitmap index in sql???

1 3046

One table how may column and Primary key

3 2324

Psudo colums

HP,

1 2358

Simple example for difference between select and cursor in sql

1 2577


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what is isolation level at dead lock?

988


plss anybody specify tha constrian management system in dbms

788


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

279


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1035


What is the difference between online clustering and Offline clustering?

1197






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

1118


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?

589


where the connection string store in the database

790


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.

1544


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.

683


How we create SQL Server 2005 Reporting Services ? Give me Sample

887


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

1472


New concepts of sql server 2005 use in your project.

1211


If we delete pack Spec what will be the status of pack Body ?

147


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

871