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Ä ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬ sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º ÈÕÆÚ 2010-1-25 14:45: ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£ MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10. ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
ÐèÇóÈçÏ£º ѧԺ academy£¨aid,aname£© °à¼¶ class£¨cid,cname,aid£© ѧÉú stu(sid,sname,aid,cid) סËÞÇø region(rid,rname) ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯ ËÞÉá dorm(did,rid,bid£¬bedn ......