SQL Server Interview Questions
Questions Answers Views Company eMail

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

Jade Software,

6 5878

What is the difference between windows authentication and sql server authentication

HCL,

7 17483

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,

1040




how can i store resumes in database?

HCL,

3 6799

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

Tanla Solutions, TS,

5 11859

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

IBM, Tanla Solutions,

6 15890

What is the difference between SSAS 2000 and SSAS 2005?

APX,

1 5356

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

APX,

6 9886




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 5328

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 7651

i want table name basis on column name.

5 4524

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 5156

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

1 5955

How to create logins using windows Authentication mode?

2 2375

write the query for taking database restore in sql?

2 3117


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is data modeling and Reterminal integrity?

668


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

877


what are the critical issues you have resloved in your company

823


If we delete pack Spec what will be the status of pack Body ?

177


New concepts of sql server 2005 use in your project.

1235






Delete duplicate rows without using rowid.

191


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1510


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.

362


Call by value and call by reference in procedure and function, with NOCOPY.

150


Issues related in upgrading SQL Server 2000 to 2005 / 2008

767


Working with TLogs

683


what is checksum in sql server.........???

392


How much memory that we are using in Logshipping Concept?

704


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

818


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

1040