General information
Forum:
Microsoft SQL Server
Title:
Newbie and appending data into another table
Hello group,
I would like to add all of the rows from cisstudemo a temporary table into the permanent table studemo. This was an example INSERT INTO studemo ( SELECT * FROM cisstudemo) that gives me an error
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'SELECT'.
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ')'.
How do I best accomplish my goal?
Jim
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only