I Want to Copy Structure Tabel + His Trigger too To New Tabel..
I Already use this methode, But I got some error on it..
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;
And i got error like this..
enter image description here
Sorry if my code is too long..
Thx
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.