SQL Server Interview Questions
Questions Answers Views Company eMail

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

Jade Software,

6 5814

What is the difference between windows authentication and sql server authentication

HCL,

7 17342

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,

1016




how can i store resumes in database?

HCL,

3 6744

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

Tanla Solutions, TS,

5 11766

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

IBM, Tanla Solutions,

6 15690

What is the difference between SSAS 2000 and SSAS 2005?

APX,

1 5295

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

APX,

6 9793




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 5258

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 7558

i want table name basis on column name.

5 4452

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 5109

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

1 5914

How to create logins using windows Authentication mode?

2 2319

write the query for taking database restore in sql?

2 3071


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Delete duplicate rows without using rowid.

157


How to trouble shoot if unable to connect SQL Server

743


What is the difference between NOROW and LOCKROW?

1233


SQL Server Architecture ?

1103


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1321






role of sql sever 2005 in database rather than any other database

856


how can u get last observation in an unknown dataset ?

1106


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

1370


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

1226


wat wil hapn if we give the both read and deny read permission to user?

907


How do use Having,Group by,Group function in SQL?

648


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4723


What is the difference between online clustering and Offline clustering?

1197


How to restore performance issues and how to check?

813


How retrieve field names from the table in SQL through JAVA code?

672