根据条件执行存储过程，检查单元格值是否包含数据

Question

我有一个SQL表(数据)，它包含3列。

<表类> Id Firstname Lastname tbody><<tr>12AbcDef

请使用以下程序。我想这会对你有帮助。

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

试着改变这个:

If(@name is '')

:

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