Thanks friends for all your support

i can achieve this task by the following Query,please let me know your feedback

IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'Note'

AND COLUMN_NAME...

in future table will have more than thoushand of records

at tht time thy dnt need to copy the table content

thy need only to change the data type Datetime to bigint...

No

Ok thts great

its having 10 rows and one column have DateTime type with values.

we cant predict no. of rows affected assume tht tables have 10 rows

not lik tht,

values entered in these column was datetime only but in future i need to make entries

only as bigint

Thanks Jeff

according to my requirement i need to keep the one column type as bigint but unfortunately

i keep it as DateTime after long time i found that it was DateTime...

its a new table didnt hav any values in that column.

assume that column 1 has Id as bigint ,column 2 has Date as datetime

my aim is to alter the column...

Thanks for ur reply

but i need to convert a column of table which has datetime type

please let me kno the Query