SQL Server Interview Questions
Questions Answers Views Company eMail

What is SCOPE_IDENTITY() in sql

Cap Gemini,

4 8384

What is difference between restoration and recovery in SQLServer?

Microsoft,

3 8305

Why we need to use secondry database file? though, we can do same work using primary database file also.

Microsoft,

2 4374




What is difference between process and thread? Explain lazy writer funcationality.

Microsoft,

2 5620

What is live lock and deadlock? what is Lock escalation?

Microsoft,

2 5905

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

RBS,

1 2735

What is Primary key and foreign key? Give an example

TCS,

4 6377

How to connect PK and FK?

2 3758




What is the SQL?????????????????????????????

CMS,

5 4121

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

HP,

888

what is an sql server?

1 2445

find 2nd highest salary of person using cursor concept?

HCL,

6 6073

how to find the second salary?

HCL, Prithvi,

10 6667

How to swap the data of two columns in a table. both the columns containing varchar values.

9 11378

What are the steps need to be take improve the speed of a SQLDATA Server?

IBM,

2 3051


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

plss anybody specify tha constrian management system in dbms

886


Working with TLogs

751


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

946


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

782


Call by value and call by reference in procedure and function, with NOCOPY.

230






What is best institute to Learn DotNET And SQL in chennai?

1043


New concepts of sql server 2005 use in your project.

1304


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.

2751


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

853


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

1353


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1320


If a stored procedure is taking a table data type, how it looks?

4791


What is data modeling and Reterminal integrity?

739


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

1229


If we delete pack Spec what will be the status of pack Body ?

252