explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
1957hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?
7 11787if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?
1 3060if 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 2954if 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 7194Department ----------- 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 4587What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 7108What 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 17796
Explain the dbcc pintable command when would you use it?
what happens on checkpoint? : Sql server database administration
What is msdb database? : SQL Server Architecture
What are SSL and TSL protocols?
Do you know what is difference between stored procedure and user defined function?
Tell me about normalization in DBMS.
can you implement data mining in SSRS?
What are the different subsets of sql?
How to download and install sql server 2005 books online?
Can we perform backup restore operation on tempdb?
how can a database be repaired? : Sql server administration
what is a join and explain different types of joins? : Sql server database administration
What are the types of joins in sql?
What is a trace frag?
Is it ok to shrink transaction log?