sqlserver ÈçºÎµ÷ÊÔ´æ´¢¹ý³Ì
sqlserverÓÐûÓÐÏóoracleÄÇÑù¿ÉÒÔtest´æ´¢¹ý³Ì ,µ¥²½µ÷ÊÔ.²»Ó¦¸ÃûÓаÑ,ÎÒÔõôûÕÒµ½ÄØ? Òª²»È»ÉÔ΢³¤µãµÄ´æ´¢¹ý³ÌÔõôµ÷ÊÔÄØ?
ºÃÏóûÓÐ.
ûÓаÉ
ÓУ¬²éѯ·ÖÎöÆ÷ÖÐÓÒ¼ü´æ´¢¹ý³Ì£¬µ¥²½µ÷ÊÔ
°Ù¶ÈÉÏÈ¥ÕÒһϣ¡²»ÖªµÀ2008ÓÐûÓУ¡ºÃÏñÓиöʲôµÄ£¡
ÎÒÓõÄÊÇsql2005
²éѯ·ÖÎöÆ÷Àï²»ÊÇÓÐ µ÷ÊԵIJÙ×÷?
SQLµ÷ÊÔ¹¦Äܻҳ£²î ²»½¨ÒéʹÓÃ~
´ò¿ª²éѯ·ÖÎöÆ÷--¹¤¾ß--¶ÔÏóä¯ÀÀÆ÷--ÏÔʾ--ÔÚ¶ÔÏóä¯ÀÀÆ÷´°¿ÚÕÒµ½Òªµ÷ÊԵĴ洢¹ý³Ì--ÓÒ¼ü--µ÷ÊÔ¡£
ÒÔÉÏÊÇSQL SERVER2000µÄµ÷ÊÔ
Æäʵ×Ô¼º¼Ó¶àµãprint log²ÅÊÇ×îºÃµÄ
²»¹ýÓÃstudio.net ¿ÉÒÔµ÷ÊԵģ¬ÍøÉϺܶà½Ì³Ì
Ò»¶ÎÒ»¶Î´úÂëÊÖ¶¯Ö´ÐУ¬×¢ÒâÇ°ÃæÖ´ÐеĽá¹û¡¢±äÁ¿¡¢ÁÙʱ±í
SQL2005²»´ø´æ´¢¹ý³Ìµ÷ÊÔ¹¦ÄÜÁË
±ØÐë°²×°VS2005ÆóÒµ°æ»òÕß¿ª·¢°å£¬ÓÃVSSµÄµ÷ÊÔ¹¦Äܵ÷ÊÔ
SQL2008ÓÖ¼Ó½øÈ¥µ÷ÊÔ¹¦ÄÜÁË£¬²»¹ýʹÓñȽÏÂé·³¡£
ºÃÏñûÓÐ
ûÌý˵ÓÐ
Ïà¹ØÎÊ´ð£º
ÎҵĵçÄÔ֨װÁËϵͳ¡£ÖØ×°ºóɾ³ýÁËһЩÒÔǰ°²×°µÄsqlserver Îļþ¡£ÖØ×°ÏµÍ³ºóÏë°²×°sqlserver¡£ÓÃÐéÄâ¹âÇý°²×°¾µÏñÎļþµçÄÔȴû·´Ó¦¡£Çë¸ßÊÖÖ¸µãһϡ£ºÜ¼±¡£
û·´Ó¦£¿
ʲô´íÒ²²»±¨»¹ÊÇÔõôµÄ£¿
ÄѵÀ¾µÏ ......
ÏÈÓÉÈçÏÂsqlÓï¾ä
select A,B,C from table1
union
select A,B,C from table2
order by A, C asc
µÃµ½½á¹ûÈçÏ£º
A B &nbs ......
sqlserver´æ´¢¹ý³Ì¸Äoracle
˻ᰡ¡£¡£¡£°ïæ¸Ä¸Ä··
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE tp_Fetch_List(
  ......
»¹ÔµÄ±¨´íÐÅÏ¢:
System.Data.SqlClient.SqlError: ±¸·Ý¼¯ÖеÄÊý¾Ý¿â±¸·ÝÓëÏÖÓÐµÄ 'chat_Data' Êý¾Ý¿â²»Í¬¡£ (Microsoft.SqlServer.Smo)
Çë¸÷λ¸ßÊÖ°ïæ½â¾ö
»¹ÔµÄÊý¾Ý¿âÃû×ÖÓ뱸·ÝµÄÊ ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......