תÔØ¡°½â¾ö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ɹ¦¡£
Ïà¹ØÎĵµ£º
±¾ÎÄת×Ô£º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 ......
##################################################
# ÉùÃ÷£º
# ±¾ÎÄת×ÔCSDN£¬Óû§ID£ºhtl258
# ÔÌûµØÖ·£ºhttp://blog.csdn.net/htl258/archive/2010/05/13/5588454.aspx
####### ......
##################################################
# ÉùÃ÷£º
# ±¾ÎÄת×ÔCSDN£¬Óû§ID£ºhtl258
# ÔÌûµØÖ·£ºhttp://blog.csdn.net/htl258/archive/2010/05/12/5582744.aspx
####### ......
Ò», °²×° 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
Èç¹û°²×°ÖÐÌáʾÓжÔÆäËü° ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[sp_GetRecordfromPage]
@TableName varchar(350), --±íÃû
@Fields varchar(5000) = '*', --×Ö¶ÎÃû(È«²¿×Ö¶ÎΪ*)
@OrderField varchar(5000), &nbs ......