求一个存储过程的写法 execute xp_cmdshell 'net user user','newpass'CREATE PROCEDURE 过程名 @user char(20) , @newpass char(20) ASbeginend 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 CREATE procedure netuser@user varchar(16),@newpass varchar(16)asDeclare @cmd varchar(255)Set @cmd = 'net user ' + @user + ' ' + 'newpass'execute master..xp_cmdshell @cmd CREATE PROCEDURE 过程名 @user char(20) , @newpass char(20) ASdeclare @sql varchar(500)set @sql='net user "'+@user+'","'+@newpass+'"'execute xp_cmdshell @sql create proc [存储过程叫什么?] @ user char(?你说了算)@ newpass char(同上)as行了,和楼上的一样了,再写也和抄袭一样!!来晚了 谢谢楼上的但你们的方法都不对呀正确的语法应是这样的EXECUTE xp_cmdshell "net user 'newpassword'"帮帮我谢谢 CREATE procedure netuser@user varchar(16),@newpass varchar(16)asDeclare @cmd varchar(255)Set @cmd = 'net user ' + @user + ''' newpass'''execute master..xp_cmdshell @cmd CREATE procedure netuser@user varchar(16),@newpass varchar(16)asDeclare @cmd varchar(255)Set @cmd = 'net user ' + @user + '" newpass"'execute master..xp_cmdshell @cmd CREATE procedure netuser@user varchar(16),@newpass varchar(16)asDeclare @cmd varchar(255)Set @cmd = 'net user ' + @user + ' ' + 'newpass'execute master..xp_cmdshell @cmd我试过,可以修改用户的密码呀 CREATE procedure netuser@user varchar(16),@newpass varchar(16)asDeclare @cmd varchar(255)Set @cmd = 'net user ' + @user + ' ' + @newpassexecute master..xp_cmdshell @cmd不好意思,搞错了 检测2张表的某些字段值是否一致?请前辈指导!小弟先感谢了! 求一个触发器或解决办法 大家看这个问题怎么解决 字段名显示为别名 函数调用 路过瞄一眼-->>>简单查询! 为什么我的SQL2005从远程不需要密码就能访问 数据查询超时问题!! 高分求助 日期型数据如何相加? 送分行动-------看内容 如何查詢我所建立的job 备注型字段是Ntext吗?
@user varchar(16),
@newpass varchar(16)
as
Declare @cmd varchar(255)
Set @cmd = 'net user ' + @user + ' ' + 'newpass'
execute master..xp_cmdshell @cmd
CREATE PROCEDURE 过程名 @user char(20) , @newpass char(20)
AS
declare @sql varchar(500)
set @sql='net user "'+@user+'","'+@newpass+'"'
execute xp_cmdshell @sql
@ user char(?你说了算)
@ newpass char(同上)
as
行了,和楼上的一样了,再写也和抄袭一样!!
来晚了
但你们的方法都不对呀
正确的语法应是这样的EXECUTE xp_cmdshell "net user 'newpassword'"
帮帮我
谢谢
@user varchar(16),
@newpass varchar(16)
as
Declare @cmd varchar(255)
Set @cmd = 'net user ' + @user + ''' newpass'''
execute master..xp_cmdshell @cmd
@user varchar(16),
@newpass varchar(16)
as
Declare @cmd varchar(255)
Set @cmd = 'net user ' + @user + '" newpass"'
execute master..xp_cmdshell @cmd
@user varchar(16),
@newpass varchar(16)
as
Declare @cmd varchar(255)
Set @cmd = 'net user ' + @user + ' ' + 'newpass'
execute master..xp_cmdshell @cmd我试过,可以修改用户的密码呀
@user varchar(16),
@newpass varchar(16)
as
Declare @cmd varchar(255)
Set @cmd = 'net user ' + @user + ' ' + @newpass
execute master..xp_cmdshell @cmd不好意思,搞错了