explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
1840hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?
7 10909if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?
1 2834if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?
2 2705if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?
5 6581Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz
3 4138What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 6779What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?
15 16588
What are the steps you can take to avoid “deadlocks”?
What is entity data services?
What is database black box testing?
How to assign null values to variables or columns?
What are policy management terms?
Explain primary key?
Difference between DELETE and TRUNCATE?
What is 3nf normalization?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
Explain in brief how sql server enhances scalability of the database system?
How to create dbo table in sql server?
Does partitioning help performance?
Explain log shipping?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is function of ROLLUP ?