Thanks Ken

its working

and what is 'N' here

Thanks

murali

Hi Jeff,

when i fit Int datatype it shows error.tell me which data type i have to fit here.

the problem is blank row(empty row).how to take the data into sql server...

Hi ALZ

i didnt guess how to check my original that

can u give the suggestion

thanks

murali

Hi ALZ

when i test my original data

at the time alter table it show below warning

Warning: The table "samples" has been created, but its maximum row size exceeds the allowed maximum...

Hi ALZ

1.select count(*) as newcol_NULL_count

from yourtable

where newcol is null ;

if i implement above query it shows the follwing error

Incorrect syntax near '_NULL_Count'.

and i changed the query

2.select count(*) as...

Hi ALZ

i did what u said but it did affect any row it shows

0 affected rows

my old column is (col1 nvarchar(50) null)

my new column is (newcol bigint null)

but u taken...

Hi i checked nvarchar columns content

i am giving one column content

customer key(nvarchar(50)

-------------

500910000000000000

500903000000000000

500909000000000000

500903000000000000

500805000000000000

500911000000000000

500905000000000000

500911000000000000

500905000000000000

500911000000000000

for this i create one new column with newcustomer key(bigint)

and update the new column with old column

like update tablename...