CREATE PROCEDURE sp_createtable
(
@txttablename as varchar(50),
@column1 as varchar(50),
@select1 as varchar (50),
@column2 as varchar(50),
@select2 as varchar(50),
@column3 as varchar(50),
@select3 as varchar(50)
)
AS
DECLARE @SQL varchar(2000)
SELECT @SQL = 'create Table' + @txttablename+')'
SELECT @SQL = @SQL + 'ID identity NOT NULL PRIMARY KEY, @txtcolumn1 @txtselect1, @txtcolumn2 @txtselect2, @txtcolumn3 @txtselect3)'
Exec(@SQL)