probit
پنج شنبه 15 تیر 1385, 07:38 صبح
سلام من stored procedure زیر رو نوشتم
CREATE PROCEDURE Search_Soft_Byddl
(
@TypeIDin smallint,
@FileID int output,
@FileName nvarchar(50) output,
@TypeID smallint output,
@Des nvarchar(50) output,
@FileAdd nvarchar(50) output,
@PicAdd nvarchar(50) output
)
AS
SELECT @FileID = FileID, @FileName = FileName, @TypeID = TypeID, @Des = Des, @FileAdd = FileAdd, @PicAdd = PicAdd
FROM Soft_Table
WHERE (TypeID = @TypeIDin)
ولی وقتی اجراش می کنم error می دهد:
Procedure or Function 'Search_Soft_Byddl' expects parameter '@FileID', which was not supplied.
No rows affected.
(0 row(s) returned)
@FileID =
@FileName =
@TypeID =
@Des =
@FileAdd =
@PicAdd =
@RETURN_VALUE =
Finished running [dbo].[Search_Soft_Byddl].
می تونید بگید مشکل کجاست؟
CREATE PROCEDURE Search_Soft_Byddl
(
@TypeIDin smallint,
@FileID int output,
@FileName nvarchar(50) output,
@TypeID smallint output,
@Des nvarchar(50) output,
@FileAdd nvarchar(50) output,
@PicAdd nvarchar(50) output
)
AS
SELECT @FileID = FileID, @FileName = FileName, @TypeID = TypeID, @Des = Des, @FileAdd = FileAdd, @PicAdd = PicAdd
FROM Soft_Table
WHERE (TypeID = @TypeIDin)
ولی وقتی اجراش می کنم error می دهد:
Procedure or Function 'Search_Soft_Byddl' expects parameter '@FileID', which was not supplied.
No rows affected.
(0 row(s) returned)
@FileID =
@FileName =
@TypeID =
@Des =
@FileAdd =
@PicAdd =
@RETURN_VALUE =
Finished running [dbo].[Search_Soft_Byddl].
می تونید بگید مشکل کجاست؟