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

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

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.


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

Posting Guidelines Forum Rules Use the code tags
Reply With Quote