I am using SQL Server 2014 and and facing a problem In creating stored procedure. Can anybody tell me how I create a stored procedure for create table operation?
example of this store procedure
CREATE PROCEDURE spCreatetable
AS
BEGIN
Declare @createtablestr varchar(max)
set @createtablestr ='CREATE TABLE Persons
(
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
) '
excute @createtablestr ;
END
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments