View Single Post
 
Old 07-28-2015, 05:00 AM
PlausiblyDamp's Avatar
PlausiblyDamp PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

Are you trying to create a stored procedure that can can create a table or are you trying to create a single script that can do both?

There shouldn't be any problem with creating a procedure to create a table so I am assuming the later.

Certain commands can't be in the same batch, typically these include things like CREATE PROC - you would need to separate them with the GO keyword. e.g.
Code:
CREATE PROC .....

GO

CREATE Table ...
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote