CREATE PROCEDURE [CreateMyTable]
(@LogTableName [varchar](32))
AS
declare @v_sql varchar(2000)
if exists (select * from sysobjects where id = object_id(N'[dbo].['+ @LogTableName + ']') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
set @v_sql = ' drop table ' + @LogTableName
exec (@v_sql)
GO
set @v_sql = 'CREATE TABLE ' + @LogTableName
+'('
+'[SerialNo] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,'
+'[OpTime] [datetime] NOT NULL ,'
+'[OpInfo] [varchar] (50) NOT NULL ,'
+'[OpDesc] [varchar] (100) NULL '
+') ON [PRIMARY]'
exec (@v_sql)GO
(@LogTableName [varchar](32))
AS
declare @v_sql varchar(2000)
if exists (select * from sysobjects where id = object_id(N'[dbo].['+ @LogTableName + ']') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
set @v_sql = ' drop table ' + @LogTableName
exec (@v_sql)
GO
set @v_sql = 'CREATE TABLE ' + @LogTableName
+'('
+'[SerialNo] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,'
+'[OpTime] [datetime] NOT NULL ,'
+'[OpInfo] [varchar] (50) NOT NULL ,'
+'[OpDesc] [varchar] (100) NULL '
+') ON [PRIMARY]'
exec (@v_sql)GO
CREATE PROCEDURE [CreateMyTable] @LogTableName [varchar](32)
AS
begin
declare @v_sql varchar(2000)
if exists (select * from sysobjects where id = object_id(N'[dbo].['+ @LogTableName + ']') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
set @v_sql = ' drop table ' + @LogTableName
exec (@v_sql)
set @v_sql = 'CREATE TABLE ' + @LogTableName
+'('
+'[SerialNo] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,'
+'[OpTime] [datetime] NOT NULL ,'
+'[OpInfo] [varchar] (50) NOT NULL ,'
+'[OpDesc] [varchar] (100) NULL '
+') ON [PRIMARY]'
exec (@v_sql)
end