SQL Server Interview Questions
Questions Answers Views Company eMail

What is database replicaion? What are the different types of replication you can set up in SQL Server?

SAIC, Aptech, HCL, Perpetual,

5 20497

How to determine the service pack currently installed on SQL Server?

HCL,

4 6776

Can you have a nested transaction?

HCL,

4 7951




What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

HCL,

3 9544

What is the system function to get the current user's user id?

HCL,

2 10643

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

HCL,

1 3735

What is the datatype returned by count(*)

247Customer, Asian CERC,

22 22072

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

992




Can I remove the default constraint columns in SQL SERVER?

Value Labs,

5 10593

What is the difference between distinct clause and group by clause?

Value Labs, HHH,

2 13208

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

Wipro, eSoft, C3I, iPRO Solutions,

3 15945

What is an extended Stored Procedure?

1 4858

What is Trigger?

Misys,

3 7035

What is a view? is View updatable?

L&T, IBM,

17 23464

What is the difference between having and where clause?

4 7099


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

875


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

740


can any body tell me how to know the password of current user in sql server

982


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

950


what is isolation level at dead lock?

1082






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

887


What is the difference between online clustering and Offline clustering?

1287


What is Lock table in SQL?

354


what is difference between view and Dip.

1273


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

930


query processing

1078


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

1017


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

899


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

983


what is the sql equivaent of the dataset relation object ?

905