SQL Server Interview Questions
Questions Answers Views Company eMail

What is INTVAL( )and where we use Plz any body help me

1 4141

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

708

What is the difference between a stored procedure and a user defined function in sql server?

Millennium,

2 5229




could u plz explain about joins and views?

2 2601

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 2783

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 4573

what is the sql equivaent of the dataset relation object ?

855

How To delete duplicate record from a particular table?

eXensys, Foxfire,

12 15985




What is the difference between Drop and Truncate

IBM, GT Nexus,

20 24487

Anyone please explain me the concept of Serialization?

3 2674

What is transaction ? Give me one example.

Wipro, Melstar,

11 19140

UPDATE statement can on a single table or on the multiple table?

TCS, iGate,

7 8113

What is difference between TRUNCATE and DELETE statement

CTS,

12 13747

can any one please send sql quries most used in applications.

2 2179

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

Patni,

13 11882


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

860


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1058


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

930


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

1167


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

952






what is difference between view and Dip.

1225


You are doing log shipping due to some reasons it is failing. How you will proceed from there

833


How to trouble shoot if unable to connect SQL Server

783


Delete duplicate rows without using rowid.

208


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.

677


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2694


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

687


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

846


how many no of arguments can be passed in procedures and functions

3517


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

1158