在sql中使用逻辑时应该作为参数传递什么 [英] what should be passed as parameter while using logic in sql

问题描述

@user_id int,
@journey_place varchar(50),
@pickup_date datetime,
@return_date datetime,
@pickup_address varchar(250),
@return_address varchar(250),
@service_id int,
@vehicle_id int,
@mode_of_payment varchar(50)

AS
    Begin

    Declare @uid int
    if(@uid = 0)
    begin
    set @uid = (select max(user_id) from registration)
    end

    Else
    begin
    set @uid = @user_id
    end


    insert into booking (user_id,journey_place,pickup_date,pickup_address,return_date,return_address,service_id,vehicle_id,mode_of_payment,status,starting_km,ending_km,booking_date)
     values (@user_id,@journey_place,@pickup_date,@pickup_address,@return_date,@return_address,@service_id,@vehicle_id,@mode_of_payment,''true'',0,0,getdate())

    End

任何人都可以告诉我应该在c中传递什么参数ode获取用户ID ..

can any body tell me what should i pass argument in code to get userid..

cmd.Parameters.AddWithValue("@uid", ddluname.SelectedValue);

或

or

cmd.Parameters.AddWithValue("@user_id", ddluname.SelectedValue);

bt dis不工作..我应该在存储过程中传递参数。

bt dis are not working.. and what should i pass argument in stored procedure.

推荐答案

第二个 - @user_id。

第一个 - @uid - 不在参数列表中。



检查你传递的值 - 确保它是一个整数，或者可能有问题。

如果那不起作用（或显示问题）那么我们需要看到错误信息，以及代码生成SP请求。

The second one - @user_id.
The first one - @uid - is not in the parameters list.

Check the value you are passing - make sure it is an integer, or there may be problems.
If that doesn''t work (or show up a problem) then we would need to see the error message, and the code that generates the SP request.

嘿，你不需要传递@uid，因为你在存储过程中设置它。

你需要声明你的@user_id参数......

cmd.Paramaters.Add（new Sqlparamater（@ user_id，SqlDbType.Int））。值= Convert.ToInt32（ddluname.selectedValue）;

Hey you don''t need to pass the @uid as you are setting it in the stored procedure.
You need to declare your @user_id parameter like so...
cmd.Paramaters.Add(new Sqlparamater("@user_id" , SqlDbType.Int)).Value = Convert.ToInt32(ddluname.selectedValue);

写

write

Declare @uid int
if(@user_id = 0)

而不是

instead of

Declare @uid int
if(@uid = 0)

这篇关于在sql中使用逻辑时应该作为参数传递什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！