34,590
社区成员
发帖
与我相关
我的任务
分享
create proc sp_test
@a int=2,
@b int=3,
@c int=4
as
select num=@a+@b+@c
go
exec sp_test
/*
num
-----------
9
(1 行受影响)
*/
exec sp_test @b=4
/*
num
-----------
10
(1 行受影响)
*/
这样应该理解了吧INSERT LinkMan
select isnull(@Name,'默认值'),isnull(@Tel,'默认值'),isnull(@QQNum,'默认值'),isnull(id,'默认值'),'-'
From User_Info
Where User_ID = isnull(@User_ID,'默认值')
INSERT LinkMan
select isnull(@Name,'默认值1'),isnull(@Tel,'默认值2'),isnull(@QQNum,'默认值3'),ID,'-'
From User_Info
Where [User_ID] = @User_ID
ALTER procedure [dbo].[_AddLinkMan]
@Name nvarchar(20)='name',
@Tel nvarchar(50)='23235435',
@QQNum nvarchar(15)='32454354',
@User_ID nvarchar(20)='3254'
As
类似这样