Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

[SQL Server2008]SQL Server ÖÐ.Óë::µÄÇø±ð(ת)

SQL ServerÖе÷Ó÷½·¨Ê±£¬¾­³£Óöµ½.»òÊÇ::Á½ÖÖµ÷Ó÷½·¨£¬ÆäÖÐ. ÊÇʵÀýµ÷Ó÷½·¨£¬::ÊǾ²Ì¬µ÷Ó÷½·¨¡£Èç¹û´ó¼Ò¶ÔC#Óï·¨ÊìϤµÄ»°£¬. ¶ÔÓ¦C#Öе÷ÓÃʵÀý·½·¨£¬:: ¶ÔÓ¦C#ÖеÄstatic·½·¨¡£
ÏÂÃæ¸ø³öÒ»¸öSQL ServerµÄʵÀý£¬ÏÂÃæµÄSQLÔËÐÐÔÚ2008»·¾³Ï£º
DECLARE @g geography;
SET @g = geography::Parse('LINESTRING(-122.360 47.656, -122.343 47.656)');
SELECT @g;
SELECT @g.ToString();
½á¹û¼¯Îª£º
0xE610000001148716D9CEF7D34740D7A3703D0A975EC08716D9CEF7D34740CBA145B6F3955EC0
LINESTRING (-122.36 47.656, -122.343 47.656)
geographyÊÇSQL Server 2008ÐÂÔöµÄÖ§³ÖµØÀíÐÅÏ¢ÀàÐÍ£¬ÓÉÓÚ³¬³ö±¾ÎÄËù½²·¶Î§£¬ËùÒÔÕâÀï²»×ö˵Ã÷¡£
ÎÒÃÇÖ»¿´ÀïÃæµÄgeography::Parse·½·¨ºÍ@g.ToString()·½·¨£¬¿ÉÒÔ¿´µ½Parse·½·¨ÊÇͨ¹ýgeographyÀàÐÍÖ§³Öµ÷Óõģ¬Ï൱ÓÚC#ÖеÄClass.StaticMethodÐÎʽ£¬ToString()ÊÇͨ¹ýgÕâ¸öʵÀýµ÷Óõġ£
±¾ÎÄÀ´×ÔCSDN²©¿Í£ºhttp://blog.csdn.net/tjvictor/archive/2009/07/29/4390673.aspx


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

SQL SERVER 2008 EXPRESS°æ±¾Ô¶³ÌÁ¬½Ó(tcp/ip)

´ËÎÊÌâÕÛÌÚ°ëÌì,googleÒ²ËÑË÷ÁË,ÍøÉϺܶàÅóÓÑÒ»°ã×öµ½µÚ¶þ²½²»³É¹¦,ÎÒÒ²²îµã·ÅÆúÁË.×îºóͨ¹ýµÚÈý²½Á¬½Ó³É¹¦ÁË.
1.·À»ðǽÔÊÐí1433
2.ÅäÖù¤¾ßÀïµÄSQL Server ÅäÖùÜÀíÆ÷.´ò¿ªºó,¿ªÆôÓÒ±ßÈý¸öЭÒé.²¢¶Ôtcp/ipÈçÏÂÅäÖÃ
 
3.ÍøÉϴ󲿷Ö×öµ½µÚ¶þ°æÖØÆôsql server·þÎñ,ÈÔÈ»ÎÞЧ.Æäʵ,ÐèÒªÐÞ¸ÄÁ¬½Ó×Ö·û´®.Ö¸¶¨ÎÒÃÇÅäÖõĶ ......

SQL Server Management Studio µÄÒ»¸öbug

ƽʱºÜÉÙÓÃSQL Server 2008£¬Å¼¶ûÓÃÒ»´Î£¬»¹ÕæÊÇÓöµ½ÁËһЩÎÊÌ⣬¼¸¾­ÖÜÕÛ£¬´Ó¹ÙÍøÉϲÅÕÒµ½½â¾ö°ì·¨£º
ÎÊÌâÃèÊö£ºµÇ½ºó£¬µã»÷Êý¾Ý¿â£¬³öÏÖ·þÎñÆ÷Ö÷Ìå "xxxcom" ÎÞ·¨ÔÚµ±Ç°°²È«ÉÏÏÂÎÄÏ·ÃÎÊÊý¾Ý¿â "db_xxx_com"¡£
ÎÊÌâÔ­Òò£ºSQL Server 2008 bug
ÎÊÌâ½â¾ö°ì·¨£¨·ÇÔ­´´£¬²Î¿¼¹ÙÍø£©£º
1¡¢ÓÃSQL Server Management Studi ......

×ß½øLinq Linq to SQLÔ´´úÂëÉÍÎö

ÔÚDataContextÖÐÎÒÃÇ´ò½»µÀ×î¶àµÄÒ²Ðí¾ÍÊÇGetTable<TEntity>()·½·¨ÁË£¬Õâ¸ö·½·¨»á»ñȡһ¸öTable<TEntity>¶ÔÏ󣬽ñÌìÎÒÃǾÍÀ´¿´¿´Õâ¸ö¶ÔÏóÊÇÈçºÎ»ñÈ¡µÄ¡£
¡¡¡¡¶ÔÓÚ»ñÈ¡Table<TEntity>¶ÔÏóÎÒÃÇ»¹Òª¿´¿´Õâ¸öDataContextÊDz»ÊÇÇ¿ÀàÐ͵쬹ØÓÚÇ¿ÀàÐ͵ÄDataContext¿ÉÒÔ¿´ÎÒÇ°ÃæÒ»ÆªÎÄÕ£¬Ç¿ÀàÐ͵ÄDataContextÀ ......

MS SQL Êý¾Ý¿â±¸·ÝºÍ»¹Ô­µÄ¼¸ÖÖ·½·¨


Ò»¡¢Í¨¹ýÆóÒµ¹ÜÀíÆ÷½øÐе¥¸öÊý¾Ý¿â±¸·Ý¡£´ò¿ªSQL SERVER ÆóÒµ¹ÜÀíÆ÷£¬Õ¹¿ªSQL SERVER×éLOCALϵÄÊý¾Ý¿â£¬ÓÒ¼üµã»÷ÄãÒª±¸·ÝµÄÊý¾Ý¿â£¬ÔÚµ¯³öµÄ²Ëµ¥ÖÐÑ¡ÔñËùÓÐÈÎÎñϵı¸·ÝÊý¾Ý¿â£¬µ¯³ö±¸·ÝÊý¾Ý¿â¶Ô»°¿ò£º
µã»÷Ìí¼Ó°´Å¥£¬Ìîд±¸·ÝÎļþµÄ·¾¶ºÍÎļþÃû£¬µã»÷È·¶¨Ìí¼Ó±¸·ÝÎļþ£¬µã»÷±¸·Ý¶Ô»°¿òÉϵı¸·Ý£¬¿ªÊ¼½øÐб¸·Ý¡£
&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ