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 19826

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


4 6252

Can you have a nested transaction?


4 7376

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


3 9129

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


2 9867

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?


1 3495

What is the datatype returned by count(*)

247Customer, Asian CERC,

22 20794

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.


Can I remove the default constraint columns in SQL SERVER?

Value Labs,

5 9969

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

Value Labs, HHH,

2 12137

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

Wipro, eSoft, C3I, iPRO Solutions,

3 15295

What is an extended Stored Procedure?

1 4654

What is Trigger?


3 6651

What is a view? is View updatable?


17 21984

What is the difference between having and where clause?

4 6745

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

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


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.


Comment,Datatypes are unlimited


How to convert a table data in XML format in sql server?




Which is the best place or learning center for MS SQL?????In Bangladesh?????


What is data modeling and Reterminal integrity?


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


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?


last function used in MS Access to convert sql what function will use in sql


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.


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


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


How do you Implement SSIS Packages in your Project?


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