1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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 5898

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 4359

how to rest identity columns in sql server

Matrix,

3 10977

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 11340

What is normalization in Database ?

 4 9158

Display a roll having miminum marks in two subjects?

Patni,

7 7143

Wht is SQL Injection Attack ?

 3 6410

how to change column into row in sql

ESS,

4 13435

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

CMS, Impetus,

2 12424

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,

2106

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 3243

how many types of store procedre in sqlserver 2000?

ATI,

2 4939

what is the importence of the trigger in sqlserver2000?

ATI,

1 3694

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

 8 21337

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 2284

Un-Answered Questions { SQL Server }

How many types of triggers in sql server?

513

Which tcp/ip port does the sql server run on? How can it be changed?

516

How can you fetch alternate records from a table?

534

when would you go for denormalization? : Sql server database administration

477

How to drop an existing stored procedure in ms sql server?

534




What is single-user mode?

514

How to create a Master database in SQL server ?

545

What does it mean to manipulate data?

553

What is explicit cursors?

547

Why use sub query in sql server and list out types of sub queries?

531

What is the maximum size of a dimension? : sql server analysis services, ssas

550

What is the purpose of object explorer and its features? : sql server management studio

590

Is it possible to call a stored procedure within a stored procedure?

548

What is acid mean in sql server?

566

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

523

For More Un-Answered { SQL Server } Questions Click Here