Hello I am having a table
table1
col1 (bit)
and i want to changethe col1 type for smallint
col1 (smallint)
true will be = 1
and false = 0
how can i do it ??
thank youJust change it using Enterprise Manager. The existing values will be implicitly converted.|||i must change it from a script
but i found it
thank you|||Change it in Enterprise Manager, and then click the icon that scripts your change.
Showing posts with label col1. Show all posts
Showing posts with label col1. Show all posts
Subscribe to:
Posts (Atom)