I want to copy the structure of a table + trigger to a new table.
I already use this method, but I got some errors.
USE [May]
GO
/****** Object: StoredProcedure [dbo].[bikinbaru]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[bikinbaru]
@nama1 AS nvarchar(max),
@nama2 AS nvarchar(max),
@nama3 AS nvarchar(max),
@nama4 AS nvarchar(max),
@nama5 AS nvarchar(max),
@nama6 AS nvarchar(max),
@nama7 AS nvarchar(max)
AS
BEGIN
SET @Tahun = CONVERT(nVarChar(10), YEAR(GETDATE()));
SET @Bln = 'April.dbo.RekapBrg'+@Tahun;
SET @MyTableName = @nama1;
SET @DynamicSQL = N'SELECT * INTO ' + QUOTENAME(@MyTableName) + ' FROM rtd';
EXEC(@DynamicSQL);
SET @MyTableName = @nama2;
SET @DynamicSQL = N'SELECT * INTO ' + QUOTENAME(@MyTableName) + ' FROM rth';
EXEC(@DynamicSQL);
SET @MyTableName = @nama3;
SET @DynamicSQL = N'SELECT * INTO ' + QUOTENAME(@MyTableName) + ' FROM stock';
EXEC(@DynamicSQL);
SET @MyTableName = @nama4;
SET @DynamicSQL = N'SELECT * INTO ' + QUOTENAME(@MyTableName) + ' FROM history';
EXEC(@DynamicSQL);
SET @MyTableName = @nama5;
SET @DynamicSQL = N'SELECT * INTO ' + QUOTENAME(@MyTableName) + ' FROM rekapbrg';
EXEC(@DynamicSQL);
SET @MyTableName = @nama6;
SET @DynamicSQL = N'SELECT * INTO ' + QUOTENAME(@MyTableName) + ' FROM tstock';
EXEC(@DynamicSQL);
SET @MyTableName = @nama7;
SET @DynamicSQL = N'SELECT * INTO ' + QUOTENAME(@MyTableName) + ' FROM sisabrg';
EXEC(@DynamicSQL);
END;
I got this error:
enter image description here
Sorry if my code is too long..
Thanks
New contributor
Puji Anto is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.