what is difference between primary key and Unique8 4332
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????3 6326
HOW TO RENAME A COLUMN NAME3 4500
what is cluster and nin-cluster index?4 3667
What are different types of Keys? Please explain all the keys with a suitable example.4 23409
What is row by row processing ?2 5979
can primery key be a non clustered index?10 7033
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.1 3866
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?4 6575
How to find out name of all employees who has salary less than 200 Rs.?8 4633
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.1 2099
how many no of arguments can be passed in procedures and functions
What is RMS migrations?
Delete duplicate rows without using rowid.
Scalability, Availability, Integration with internet, etc.)?
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
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Explain Capacity planning to create a database? and how to monitor it?
If the job running very slow what is the action you do
where the connection string store in the database
what is isolation level at dead lock?
Working with TLogs
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
How do you Implement SSIS Packages in your Project?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.