Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 update

Author  Topic 

asm
Posting Yak Master

140 Posts

Posted - 2007-02-17 : 06:02:20
Hi

Can any body tell how to update the blank table and
what is the alternate of where clause and Select statement?


thanks


asm

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-02-17 : 07:50:51
You have to tell what you want to update to?

For general UPDATE statement syntax, you can check SQL Server help.


Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-02-18 : 09:48:34
you can't update a blank table, you can only insert into it

in a group by, you can use 'having' instead of where if the rows are to be grouped according to a criteria

a select is a select, not sure what you want to do

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -