SQL Server Interview Questions
Questions Answers Views Company eMail

How get current date in SQL server 2000

Polaris, Cap Gemini,

4 2434

How get current date in SQL server 2000

Cap Gemini,

6 3858

In the primary key have a multiple field or not?

TCS,

8 4345




Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

TCS, PMAM IT Services,

7 5178

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

796

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

763

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

NIIT,

3 3229

what are the critical issues you have resloved in your company

Wipro,

770




how can you move the master database

IBM,

1 2873

What is RMS migrations?

Satyam,

902

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

Brigade, Wipro,

9 4955

What is split brain scenario in DB mirroring?

1 7005

how do we insert 100 records at a time in a table without using for loop in database

1 3038

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 3412

in how many ways we can use count()

2 1100


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

plss anybody specify tha constrian management system in dbms

771


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.

1527


How do use Having,Group by,Group function in SQL?

623


What is Lock table in SQL?

199


how to do partition in sqlserver

1264






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


application server is slow what may be the problem

1048


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

1192


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

903


what is the sql equivaent of the dataset relation object ?

793


how to use DTS package in 2000,2005,2008 in sql server

734


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

795


last function used in MS Access to convert sql what function will use in sql

808


what exactly sql injuction.how to overcome.....

1262


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

835