SQL Server Interview Questions
Questions Answers Views Company eMail

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

Jade Software,

6 5701

What is the difference between windows authentication and sql server authentication


7 16949

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 6636

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

Tanla Solutions, TS,

5 11552

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

IBM, Tanla Solutions,

6 15202

What is the difference between SSAS 2000 and SSAS 2005?


1 5208

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


6 9558

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 5133

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 7348

i want table name basis on column name.

5 4341

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 5036

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

1 5854

How to create logins using windows Authentication mode?

2 2246

write the query for taking database restore in sql?

2 2999

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?


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


whats the maximum size of view state??


What is the difference between online clustering and Offline clustering?


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




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


What is Lock table in SQL?


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


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that


Working with TLogs


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?


New concepts of sql server 2005 use in your project.


how to use DTS package in 2000,2005,2008 in sql server


what exactly sql injuction.how to overcome.....