求一个存储过程的写法

[tangwenbin]

求一个存储过程的写法
很简单
要求带两个输入参数
要执行
execute xp_cmdshell 'net user user "newpass"'
输入user和newpass
这个存储过程
呵呵
几个反引号给我弄混了
谢谢

[wfy0089]

execute xp_cmdshell 'net user user','newpass'

CREATE PROCEDURE 过程名 @user char(20) , @newpass char(20)
AS
begin
end

[zarge]

CREATE procedure netuser
@user varchar(16),
@newpass varchar(16)
as
Declare @cmd varchar(255)
Set @cmd = 'net user ' + @user + ' ' + 'newpass'
execute master..xp_cmdshell @cmd

[zjcxc]

CREATE PROCEDURE 过程名 @user char(20) , @newpass char(20)
AS
declare @sql varchar(500)
set @sql='net user "'+@user+'","'+@newpass+'"'
execute xp_cmdshell @sql

[lxf31]

create proc [存储过程叫什么？]
@ user char(?你说了算)
@ newpass char(同上)
as
行了，和楼上的一样了，再写也和抄袭一样！！
来晚了

[tangwenbin]

谢谢楼上的
但你们的方法都不对呀
正确的语法应是这样的EXECUTE xp_cmdshell "net user 'newpassword'"
帮帮我
谢谢

[lifeforu]

CREATE procedure netuser
@user varchar(16),
@newpass varchar(16)
as
Declare @cmd varchar(255)
Set @cmd = 'net user ' + @user + ''' newpass'''
execute master..xp_cmdshell @cmd

[zarge]

CREATE procedure netuser
@user varchar(16),
@newpass varchar(16)
as
Declare @cmd varchar(255)
Set @cmd = 'net user ' + @user + ' ' + 'newpass'
execute master..xp_cmdshell @cmd

我试过，可以修改用户的密码呀

[zarge]

CREATE procedure netuser
@user varchar(16),
@newpass varchar(16)
as
Declare @cmd varchar(255)
Set @cmd = 'net user ' + @user + ' ' + @newpass
execute master..xp_cmdshell @cmd

不好意思，搞错了

[CrazyFor]

CREATE procedure netuser
@user varchar(16),
@newpass varchar(16)
as
Declare @cmd varchar(255)
Set @cmd = 'net user ' + @user + '" newpass"'
execute master..xp_cmdshell @cmd