mssql´æ´¢¹ý³ÌÖÐÈÝ´í´¦Àí - MS-SQL Server / »ù´¡Àà

exec YYys 'aa' aaÊÇmssql·ÇÕýÈ·µÄÓï¾ä,
ÀïÃæÊÇͨ¹ý exec (@sql)--ÉÏÃæaaËù´«µÝµÄ²ÎÊý¾ÍÊÇ@sqlµ÷Óõģ¬Èç¹ûÈçºÎÈÃexec @sql³ö´íºó´æ´¢¹ý³ÌÄÜÊä³ö´íÎó¡£

---

Õâ¸ö?

òËƺÜÄÑ,ÀàËÆÈËΪ´íÎóÖ»ÄÜ´ÓÐÐÕþ·½ÃæÈëÊÖ.

---

ûÀí½âlzµÄÄ¿µÄ


SQL code:
declare @msg nvarchar(4000)
declare @severity int

IF @@ERROR <> 0
BEGIN
select @msg=description,@severity=severity from sysmessages where msglangid = 2052 and error=@@ERROR
--print @msg
RAISERROR (@msg, @severity, 1)

END

---

SQL code:

declare @msg nvarchar(4000)
declare @severity int
exec('aa')
IF @@ERROR <> 0
BEGIN
select @msg=description,@severity=severity from sysmessages where msglangid = 2052 and error=@@ERROR
--print @msg
RAISERROR (@msg, @severity, 1)

END
/*
·þÎñÆ÷: ÏûÏ¢ 2812£¬¼¶±ð 16£¬×´Ì¬ 62£¬ÐÐ 1
ÕÒ²»µ½´æ´¢¹ý³Ì 'aa'¡£
*/

---

ÒýÓÃ

SQL code

declare @msg nvarchar(4000)
declare @severity int
exec('aa')
IF @@ERROR <> 0
BEGIN
select @msg=description,@severity=severity from sysmessages where msglangid = 2052 and error=@@¡­¡­

/*
·þÎñÆ÷: ÏûÏ¢ 2812£¬¼¶±ð 16£¬×´Ì¬ 62£¬ÐÐ 1
ÕÒ²»µ½´æ´¢¹ý³Ì 'aa'¡£
*/