Gison
Last Activity: Nov 1 '07, 10:49 AM
Joined: Oct 9 '07
Location: Taiwan
-
sorry.. and thank you.... -
Does there have any undo or rollback function in SQL server?
When we update or delete data... it's very serious and seem to no choice to rollback. How does everyone to control this part of situation?
thanks for the opinion. -
Thanks iburyak and ck9663 a lot.
I can be done.
:)Leave a comment:
-
How to create a table from existed table.
I try to create a table from another existed table but always error.
Please help, does any one know what's wrong in my sentence?
=======
create table item_bak
as (select * from item);
=======
thanks a lot.
gison -
thank you for your idea... I'll try it.
:)Leave a comment:
-
two lines SQL update statement but got a error
Dear all,
I'm a SQL server beginner....
I want to replace description column by add on my name to every strings.
Does anyone can point out where i wrong in following syntax.
thanks a lot.
==SQL statement =============
update Demo
set description = description+ ' gison'
==Error message =============
Server: Msg 8152, Level 16, State 9, Line 1
String or binary data...
No activity results to display
Leave a comment: