.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Shivakumaran


Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.


Post New Question Subscribe to Interview Questions
 
Quick Links For Interview Questions Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  OOPs  JQuery  JavaScript/VBScript
BiztalkPatten/PracticesIISWCFWPFWWF
NetworkingAptitudeOthers  All    
 

Sql Server Interview Questions and Answers

what is stored procedure?

Author: sriram          Posted Date: October 28, 2011    Category: Sql Server     Points: 40

1)Stored Procedure is Predefined collection of SQL Statements.
2)Stored Procedure is Precompiled .
3)SP will reduce the client server network traffic.
4)SP will reduce the bandwidth.
5)more number of sql statements can execute the one place.
6)easy to ERROR Handling.
7)Sp Have input and output parameters.



how to Reset the identity column in sql server?

Author: sriram          Posted Date: October 27, 2011    Category: Sql Server     Points: 40

SET IDENTITY_INSERT <TABLENAME> <ON> <OFF>


Difference Between Where Clause and Having Clause?

Author: sriram          Posted Date: October 27, 2011    Category: Sql Server     Points: 40

Where clause is used for check condition or fetch specfic values

select * from employee where empid=1001

Having clause is used for Grouping Group by Clause.

avg,max,count,min....



What is Trigger ,types of Trigger?

Author: sriram          Posted Date: October 27, 2011    Category: Sql Server     Points: 40

Trigger is a self contained block of statements that is fired when insert update delete statement(automaticaly)

two types of trigger available in sql server

1)instead of trigger
2)After Trigger

sql server 2005 trigger supporting for DML-statements(Insert ,update,delete)
sql server 2008 DML and DDL Also


What is Self Join?

Author: sriram          Posted Date: October 27, 2011    Category: Sql Server     Points: 40

To join within that table is called self join.

Example to check Duplicate Records:

select empid from employee where empid not in(select empid from employee group by empid having count(*)>1)

select empid a ,empname b from emp a, emp b
where a.empid=b.empid

Regards

sriram.R

How many Primary key in single table in sqlserver?

Author: sriram          Posted Date: October 27, 2011    Category: Sql Server     Points: 40

Primary key Restrict Duplicate Values and Null values .Each Table can have only one primary ..

Create table emp(empid int constraint pk_empid primary key(empid),empname varchar(90))

Regards
Sriram.R
www.databaseresource.blogspot.com

Define Constraints in SQL SERVER

Author: sriram          Posted Date: October 27, 2011    Category: Sql Server     Points: 40

Constraints Provide the Mechanism provide integrity in the data base to create a table to check some conditions.

There are Three type of constraints in sql server

1) Domain Integtity Constraint(not null,check)
2) Entity Integrity Constrinnt( Primary key ,Unique Key)
3) Referential Integrity Constraint(Parent table,Child Table Relationship)..


hope this will Hellp..
Let me know any Queries


Regards
Sriram.R

joins in SQL SERVER

Author: sriram          Posted Date: October 27, 2011    Category: Sql Server     Points: 40

Joins Actualy performs Two or more table combined into a single result set..

Three are Four Types of joins in SQL SERVER.

1) inner join
2) Outer join(Left outer join,Right outer join)
3) Full join
4) Cross join

Regards
Sriram.R

what is use of sp_adduser in SQL server?

Author: Narayanan          Posted Date: October 13, 2011    Category: Sql Server     Points: 40

allows you to add a new user to a database


What is mean by cursors?

Author: Narayanan          Posted Date: October 13, 2011    Category: Sql Server     Points: 40

row-by-row processing of the result sets



Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend