exec('
CREATE TABLE '@m+' (
[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[name] [char] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[bookcode] [numeric](18, 0) NOT NULL ')
CREATE TABLE '@m+' (
[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[name] [char] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[bookcode] [numeric](18, 0) NOT NULL ')
if exists(select * from dbo.sysobjects where id = object_id(@m) and OBJECTPROPERTY(id, N'IsUserTable') = 1)
exec('drop table '+@m)exec('
CREATE TABLE '@m+' (
[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[name] [char] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[bookcode] [numeric](18, 0) NOT NULL ')
if exists(select * from dbo.sysobjects where id = object_id(@m) and OBJECTPROPERTY(id, N'IsUserTable') = 1)
exec('drop table '+@m)exec('
CREATE TABLE '@m+' (
[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[name] [char] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[bookcode] [numeric](18, 0) NOT NULL ')