请教一个数据库的问题
我需要把一张表做成数报表
if exists (select 1
from sysobjects
where id = object_id('CY_ZXCLDJ')
and type = 'U')
drop table CY_ZXCLDJ
go
/*==============================================================*/
/* Table: CY_ZXCLDJ */
/*==============================================================*/
create table CY_ZXCLDJ (
ID int identity,
CreatedOn datetime null,
CreatedBy nvarchar(50) null,
ModifiedOn datetime null,
ModifiedBy nvarchar(50) null,
RQ datetime null,
BZ nvarchar(20) null,
XM nvarchar(20) null,
XG nvarchar(20) null,
XL nvarchar(20) null,
RK nvarchar(20) null,
ZC nvarchar(20) null,
ZL nvarchar(20) null,
QT nvarchar(20) null,
DRGZ nvarchar(20) null,
BZ2 nvarchar(100) null,
constraint PK_CY_ZXCLDJ primary key (ID)
)
go
