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

HCL,

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

IGT,

1106




how can i store resumes in database?

HCL,

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?

APX,

1 5456

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

APX,

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

Google,

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.

iFlex,

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.

1289


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

877


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

950


where the connection string store in the database

884


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

716






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

1214


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

969


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

2918


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

885


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

987


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

5233


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

1338


what is difference between view and Dip.

1263


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

1464


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?

1315