sqlserver 存储过程中If Else的用法实例

以下是一个具体的代码示例：

创建存储过程P_Form_Control_Info_Add，接受一系列参数，包括TypeName、Description、CtlColSpan、Sort、SourceID、FieldID和TableID。

```sql

CREATE PROCEDURE [dbo].[P_Form_Control_Info_Add]

@TypeName varchar(20),

@Description varchar(50),

@CtlColSpan int,

@Sort int,

@SourceID int,

@FieldID int,

@TableID int

AS

BEGIN

IF @SourceID = 0

BEGIN

INSERT INTO T_Form_Control_Info (

[TypeName],

[Description],

[CtlColSpan],

[Sort],

[FieldID],

[TableID])

VALUES (

@TypeName,

@Description,

@CtlColSpan,

@Sort,

@FieldID,

@TableID)

END

ELSE

BEGIN

INSERT INTO T_Form_Control_Info (

[TypeName],

[Description],

[CtlColSpan],

[Sort],

[FieldID],

[TableID])

VALUES (

@TypeName,

@Description,

@CtlColSpan,

@Sort,

@SourceID, -- 注意这里要包含SourceID字段的值