i just got the answer, for some reason it was storing blank spaces at the end, so i just used the trim()<br />and it wroked...<br />Thank u all for...
It is showing the length as 24.
But even if I include the where statement, it is throwing the same error as before
ALTER TABLE tblUser ALTER COLUMN DateUpdated nchar(12) NULL
1. First the column size was nchar(10)
2. I increased the size to nchar(12) using alter script
3. Then I tried to write the case statement like the...
Even I tried increasing the column size to 12 and more..but got the same error
I wrote something like this
set DateUpdated =
case when left(DateUpdated, 3) In ('Oct','Nov','Dec') then (DateUpdated + '6') else...
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...
I tried that, I cannot alter the column to datetime......
I found out whats wrong with it, as Frank mentioned, i am surprised to see that DateUpdated is nchar(10).
So now I am trying to alter the column...
select Name, address from tblUser
DateUpdated > isnull(DateValidated,'01/01/1900')
When I run the query I got the following error
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...
I want to write sql server 2000 query with numbers...
1. select * from emp
2. select * from users
3. select * from idle
how is it...
I have a table
I want to write a query so that it selects Name and SSN from the...
Separate names with a comma.