I have a column nchar(11), which has data like oct 01 200 nov 12 200 feb 12 200 may 01 200 dec 25 200 jan 12 200 so in all the rows of this columns...
select Name, address from tblUser where DateUpdated > isnull(DateValidated,'01/01/1900') When I run the query I got the following error Msg 8115,...
Somebody can help me ... My Requirement says that I have to fetch the data of all territory code So I need somebody modify this so that I can fetch...
Hello, I want to write sql server 2000 query with numbers... like 1. select * from emp 2. select * from users 3. select * from idle how is it...
Hi, I have a table Name SSN ---- ---- Debra 0 Ray 1 John 1 I want to write a query so that it selects Name and SSN from the...
Separate names with a comma.