Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   Did my sql statement correct (http://www.go4expert.com/forums/sql-statement-correct-t1102/)

lieweffect 1Aug2006 14:19

Did my sql statement correct
 
I have a table=table1 which consists 3 columns
columns1(data)
columns2(data)
columns3(no data but created)

Now I want to update the data in columns1 into columns3
My SQL statement like this:UPDATE table1 set Column3=Column1
Isn't correct?Thank Q

shabbir 1Aug2006 16:24

Re: Did my sql statement correct
 
Does it give any error when you run the above query.

lieweffect 1Aug2006 17:32

Re: Did my sql statement correct
 
actually, this only from a little test
does any software can test the sql statement whether correct or not?

shabbir 1Aug2006 18:25

Re: Did my sql statement correct
 
Quote:

Originally Posted by lieweffect
does any software can test the sql statement whether correct or not?

Nope but your SQL looks correct.

lieweffect 1Aug2006 18:29

Re: Did my sql statement correct
 
Thank Q.....


All times are GMT +5.5. The time now is 21:19.