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

תÔØ¡°½â¾öSQL SERVER 2005ÓÃsaµÇ½ÎÊÌ⡱

×°sql 2005ºó¶ÔһЩ¹¦ÄÜ»¹²»ÊǺÜÏ°¹ß£¬±ÈÈçÓÃsaµÇ¼Êý¾Ý¿âÔںܶàµØ·½¶¼»áÓõ½£¬½ñÌì¾ÍsaµÇ¼Êý¾Ý¿âµÄһЩÐÞ¸ÄÓë´ó¼Ò·ÖÏí¡£
1.ÏÈÓÃWINDOWSģʽµÇ½,È»ºóÔÚÊý¾Ý¿â¶¥¶ËÓÒ¼üÊôÐÔ£»Èçͼ1-1£º
2.ÔÚ°²È«ÐÔϵÄWINDOWSģʽ¸ÄΪSQLÓëWINDOWSģʽ£¬ÏÂÃæµÄµÇ½ÉóºËÑ¡Ïî,Ñ¡ÔñΪ‘ÎÞ’£¬µã‘È·¶¨’£»Èçͼ1-2£º
3.´ò¿ª·þÎñÆ÷ϵݲȫÐÔÑ¡ÏîÖеđµÇ¼Ãû’Ñ¡Ïî,Ë«»÷SA£»Èçͼ1-3£º
4.µã‘״̬’½«SAµÄ״̬ÏîϵĽûÓøijÉÆôÓã»Èçͼ1-4£º
5.ÔÚ‘³£¹æ’ÀïÐÞ¸ÄÃÜÂë¡£   ½«‘Ç¿ÖÆÃÜÂë²ßÂÔ’Ñ¡ÏîÈ¥³ý¡£µã‘È·¶¨’£»Èçͼ1-5£º
6.´ò¿ªSQLÅäÖù¤¾ß½«(SQL    Server    Configuration    Manager)   ½«ÍøÂçÅäÖÃÖеÄTCP/IPÆôÓã»Èçͼ1-6£º
7.ÖØÆô·þÎñ£»Èçͼ1-7£º
ÖÁ´Ë£¬ÒѾ­´ïµ½ÓÃsaµÇ½µÄÒªÇóÁË¡£ÏÂÃæÎÒÃÇ´ò¿ªSQL Server Management Studio¼ì²éÒ»ÏÂÊÇ·ñÒѾ­Ð޸ijɹ¦¡£


Ïà¹ØÎĵµ£º

²»ÄÜÁ¬½ÓSQL SERVER 2000 µÄ½â¾ö·½°¸

±¾ÎÄת×Ô£ºhttp://blog.csdn.net/java2000_net/archive/2008/04/05/2252640.aspx
±¾ÎÄÊÕ¼Á˲»ÄÜÁ¬½ÓSQL Server £¬±¨ The Network Adapter could not establish the connection Òì³£µÄËùÓÐÓöµ½¹ýµÄÔ­Òò£¬²¢ÌṩÁËͼÐλ¯µÄÅŲéÏòµ¼¡£
²»¹ý¸ù¾Ý¾­Ñ飬ûÓÐÉý¼¶µ½SP4µÄ¿ÉÄÜÐÔ×î¸ß¡£¿ÉÒÔÖ±½Ó¿´µÚ6²¿·Ö¡£
³£¼ûµÄ´íÎóΪ£º The N ......

SQL¶¯Ì¬¼ÆËã³ö±íÖй«Ê½Ê¾Àý

##################################################
#        ÉùÃ÷£º
#        ±¾ÎÄת×ÔCSDN£¬Óû§ID£ºhtl258
#        Ô­ÌûµØÖ·£ºhttp://blog.csdn.net/htl258/archive/2010/05/13/5588454.aspx
####### ......

SQLÓï¾äµÃµ½´æ´¢¹ý³Ì¹ØÁªÄÄЩ±íÃû

##################################################
#        ÉùÃ÷£º
#        ±¾ÎÄת×ÔCSDN£¬Óû§ID£ºhtl258
#        Ô­ÌûµØÖ·£ºhttp://blog.csdn.net/htl258/archive/2010/05/12/5582744.aspx
####### ......

ÔÚlinuxÉÏÅäÖÃunixODBCºÍFreeTDS·ÃÎÊMS SQL Server.

Ò», °²×° unixODBC
ÏÂÔØ°²×°°ü. ÔÚ RedHat °²×°¹âÅÌÉϾÍÓÐ
unixODBC-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
°²×°
rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
Èç¹û°²×°ÖÐÌáʾÓжÔÆäËü° ......

sql server2005 rownumͨÓô洢¹ý³Ì·ÖÒ³

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER   PROCEDURE [dbo].[sp_GetRecordfromPage]
@TableName varchar(350),        --±íÃû
@Fields varchar(5000) = '*',    --×Ö¶ÎÃû(È«²¿×Ö¶ÎΪ*)
@OrderField varchar(5000),   &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ