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'¡£ */
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬ sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º ÈÕÆÚ 2010-1-25 14:45: ......
ÏÂÃæÊÇXML³õʼÎļþÄÚÈÝ XML code: <upd:Update xmlns:lar="http://schemas.microsoft.com/msus/2002/12/LogicalApplicabilityRules" xmlns:cmd="http://schemas.microsoft.com/msus/2002/12/Up ......