SQL Server Interview Questions
Questions Answers Views Company eMail

wat is the main diff between sql server 2000and sql server 2005

Jade Software,

6 6031

What is the difference between windows authentication and sql server authentication


7 17732

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that



how can i store resumes in database?


3 6913

how many joins we can write if at all we have n no of tables

Tanla Solutions, TS,

5 12042

what is the order of execution of where,having,group by in select stement

IBM, Tanla Solutions,

6 16309

What is the difference between SSAS 2000 and SSAS 2005?


1 5456

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.


6 10129

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 5462

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3


15 7863

i want table name basis on column name.

5 4645

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.


3 5252

In clustered and non clustered indexes which one is faster while executing a query ?

1 6006

How to create logins using windows Authentication mode?

2 2451

write the query for taking database restore in sql?

2 3209

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

New concepts of sql server 2005 use in your project.


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


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks


where the connection string store in the database


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do


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


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


Explain Capacity planning to create a database? and how to monitor it?


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


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?


what is the Ticketing tool used in Wipro technologies at Bangalore...???


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


what is difference between view and Dip.


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


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?