- 积分
- 324
- 最后登录
- 2024-4-27
- 精华
- 0
- 阅读权限
- 30
- 主题
- 144
- UID
- 916221
- 帖子
- 811
- PB币
- 2366
- 威望
- 0
- 贡献
- 0
- 技术
- 30
- 活跃
- 2586
- UID
- 916221
- 帖子
- 811
- PB币
- 2366
- 贡献
- 0
- 技术
- 30
- 活跃
- 2586
|
下面是一段Sql 2012代码,请教如何将结果输出显示在(C#)winform上?
if(object_id('创建表') is not null)
drop proc [创建表]
go
Create proc 创建表
@Table varchar(20)
AS
begin
Exec (
'CREATE TABLE [' + @Table + '](
[编号] [varchar](15) NOT NULL primary key,
[品名] [varchar](30) NULL,
[规格] [varchar](50) NULL,
[数量] [float] NULL,
[单位] [varchar](10) NULL,
[单价] [float] NULL,
[百万] [int] NULL,
[十万] [int] NULL,
[万] [int] NULL,
[千] [int] NULL,
[十] [int] NULL,
[元] [int] NULL,
[角] [int] NULL,
[分] [int] NULL,
[金额] [float] NULL)'
)
Exec
(
'Select * from [' + @Table + ']'
)
End
GO
SET ANSI_PADDING OFF
GO
|
|