GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

SQL Server Interview Questions


SQL Server Interview Questions

Questions: 90
Comments: 275
 SQL Server Tags
 Showing Questions 1-10 of 90 Questions
[1] 2 3 4 5 6 7 8 9 Next >>
 Sponsored Links

 
 SQL Server Interview Questions
Sorting Options :  

1 How is the error handling in stored proc of T-SQL2 What is clustered index and non-clustered index? How many clustered indexes and non-clustered indexes can be created in one table? 3-what is disconnected 
Latest Answer: In SQL Server 2000 We can check by @@Error0 i.e. error.ex:      IF @@Error0          BEGIN             ROLLBACK ...

How do you BCP only a certain set of rows out of a large table? 

I want to know what do we mean by Database Testing, as well as what role does a Database Tester plays meaning does he performs the similar role as a DBA does or what exactly?What things are performed in 
View Question | Asked by : Saurabh_11

what are the differences between sqlserver 2000 and sql server 2005 
Latest Answer: there are lots of things added in sql server 2005>here they hav added xml command>even ur clr is also there ...

How to select Distinct columns from the table, table having 20 columns and i want all columns  
Latest Answer: SELECT DISTINCT *FROM Tabe1 ...

There is a problem in creating relationship between two tables using SQL Server Database.What are the requirements and data that should be had before creating table relationship. 
View Question | Asked by : ec0321

Latest Answer: Prefix column name with table name like tableName.columnName ...
Read Answers (1) | Asked by : kadhar

Hello:I would like you to help me guys for my Project Dynamic Document Management System (DDMS) .I was looking for any information to help me to make my project ,but I couldn’t find good recourses 

What are the general functions available in SQL? 
View Question | Asked by : sprajarajan

What is the difference between the full, simple and bulk log recovery models? 
Latest Answer: SIMPLE: Uses full or differential copies of the database. Truncates the transaction logs automatically. Does not backup the transaction log file(s). Changes made after the last backup cannot be restored (they are lost). FULL: Includes both database ...

View page [1] 2 3 4 5 6 7 8 9 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
Sponsored Links

 
Sponsored Links



 

 
 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape