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.


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


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 ?


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


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;


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 .


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


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


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


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 ...


what is difference between view and Dip.


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


How to trouble shoot if unable to connect SQL Server


Delete duplicate rows without using rowid.


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.


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.


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


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


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


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