Here's what I did with SQL:
1. Create a temporary table
2. Insert values to the temporary table
3. Update the temporary table
4. Alter the temporary table
5. Drop the original table
6. Re-create the original table
7. Insert values to the original table from the
temporary table
8. Drop the temporary table
* When I recreated the original table, I removed the
Identity of the column ID to allow the insert from the
temporary table.
How do I restore the IDENTITY property of the column ID?
=====
Erwin Rommel Y. Felix
Tel. 8410111 loc. 11430
Mobile 09185980706
"Never outshine the Master Chicker"
__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
