What are the differences between stored procedure and the dynamic sql?
Explain the first normal form(1nf)?
what is a join? : Sql server database administration
How to view the error log for any specific instance? : sql server database administration
Why we need a group by clause?
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.
What are the differences between left join and inner join in sql server?
what is database replicaion? : Sql server database administration
Do you know what is bit data type and whats the information that can be stored inside a bit column?
what is difference between primary key and Unique
How to download microsoft sql server 2005 express edition?
if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..
17 Answers 3i Infotech, Rolta, TCS,
How you would rewrite the sql query to return the customerid sorted numerically?