SQL Server Interview Questions
Questions Answers Views Company eMail

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 3656

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 3032

how to rest identity columns in sql server

Matrix,

3 9280




i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

IBM,

9 7835

What is normalization in Database ?

4 6780

Display a roll having miminum marks in two subjects?

Patni,

7 4804

Wht is SQL Injection Attack ?

3 4819

how to change column into row in sql

ESS,

4 11345




What are the advantages of using sql server over ms access or why should one use sql instead of ms access

Impetus, CMS,

2 10790

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

ABC,

1343

How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes

INDUS,

1 2049

how many types of store procedre in sqlserver 2000?

ATI,

2 3554

what is the importence of the trigger in sqlserver2000?

ATI,

1 2705

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 17846

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

Fidelity,

1 1254


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1238


Comment,Datatypes are unlimited

998


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

4891


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.

757


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

1012






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

1362


whats the maximum size of view state??

1039


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?

1035


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

2847


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1343


New concepts of sql server 2005 use in your project.

1313


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.

1429


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1126


1 01 101 01010

839


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

912