Home Forums SQL Server 7,2000 T-SQL convert DateTime to BigInt RE: convert DateTime to BigInt
munishprathap
SSChasing Mays
Points: 622
More actions
January 19, 2009 at 6:05 am
#929152
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 2 type as bigint and column 1 as identity column