USE [keno_tablet]
GO
/****** 对象: StoredProcedure [dbo].[prcname] 脚本日期: 12/01/2009 18:36:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[prcname]
@game_name nvarchar(15)/*游戏名字*/AS
declare @result table ([game_number] [varchar] (150)) ---- 插入@result到变量中
insert into @result(game_number) values ('sss')
SELECT [game_number]
FROM game_Affiche
WHERE game_type=@game_name
select * from @result
GO
/****** 对象: StoredProcedure [dbo].[prcname] 脚本日期: 12/01/2009 18:36:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[prcname]
@game_name nvarchar(15)/*游戏名字*/AS
declare @result table ([game_number] [varchar] (150)) ---- 插入@result到变量中
insert into @result(game_number) values ('sss')
SELECT [game_number]
FROM game_Affiche
WHERE game_type=@game_name
select * from @result
SELECT [game_number]
FROM game_Affiche
WHERE game_type=@game_name
select * from @result
---- 插入@result到变量中
insert into @result(game_number) values ('sss')
SELECT [game_number]
FROM game_Affiche
WHERE game_type=@game_name
select * from @resultINSERT后面有了SELECT 就不用VALUES了把
declare @result table ([game_number] varchar (150))
GO
/****** 对象: StoredProcedure [dbo].[prcname] 脚本日期: 12/01/2009 18:36:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[prcname]
@game_name nvarchar(15)AS
declare @result table ([game_number] [varchar] (150))
insert into @result(game_number) values ('sss')即使这样也不行,说有语法错误!
不可能把,我执行怎么不出错呢
create PROCEDURE [dbo].[prcname]
@game_name nvarchar(15)AS
declare @result table ([game_number] [varchar] (150))
insert into @result(game_number) values ('sss')
goexec prcname 'xxx'/*
(所影响的行数为 1 行)