Why truncate is faster than delete?
No Answer is Posted For this Question
Be the First to Post Answer
What are all the common sql functions?
What is user defined functions?
What does select count (*) mean in sql?
What is the difference between inner join and natural join?
Does view contain data?
How do you go back in sql?
What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN
What is clustered, non-clustured and unique index. How many indexes can be created on a table ?
How do I view stored procedures?
Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy
What is a transaction?
What are procedures used for?