SQL Server Execute stored procedure based on condition to check if a cell value contains data or not

jvlzgdj9 于 2023-04-10 发布在其他

关注(0)|答案(2)|浏览(120)

I have SQL table(data) and it contains 3 columns.
| Id | Firstname | Lastname |
| ------------ | ------------ | ------------ |
| 1 | | |
| 2 | Abc | Def |

I have to check the Firstname column value based on the Id column. If it doesn't contain any value I need insert values into the Firstname and Lastname columns.

I tried the code below:

Create procedure prodata
   @Id navarchar(50),
   @Firstname nvarchar(50),
   @Lastname nvarchar(50)
As
Begin
    Declare @name as nvarchar(50)
    Select @name = Firstname from data where Id = @Id

    If(@name is '')
    Begin 
        Update data set Firstname= @Firstname and Lastname=@Lastname 
        where Id=@Id
    End
End

Exec prodata '1','vijay','kumar'

It is not working. How can I do this?

sql-server

来源：https://stackoverflow.com/questions/75951222/execute-stored-procedure-based-on-condition-to-check-if-a-cell-value-contains-da

2条答案

按热度按时间

ldioqlga1#

Please use the below procedure. I think it will helpful for you.

Create procedure prodata
        @Id nvarchar(50),
        @Firstname nvarchar(50),
        @Lastname nvarchar(50)
    As
    Begin
        Declare @name as nvarchar(50)

        Select @name = Firstname
        from data
        where Id = @Id

        If isnull(@name,'') = ''
        Begin 
            Update data set
                Firstname = @Firstname, Lastname = @Lastname
            where Id = @Id
        End
    End

赞(0）回复(0）举报 2023-04-10

5m1hhzi42#

Try changing this:

If(@name is '')

To this:

If (coalesce(rtrim(@name), '') = '')

赞(0）回复(0）举报 2023-04-10

我来回答

SQL Server Execute stored procedure based on condition to check if a cell value contains data or not

2条答案

相关问题

热门标签

最新问答