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

MS sql serverɾ³ý·þÎñÆ÷×é...

֮ǰΪÁË·½±ã²Ù×÷¾ÍÔÚSql ServerµÄÆóÒµ¹ÜÀíÆ÷Àï×¢²áÁËÔ¶³Ì·þÎñÆ÷£¬µ«ÊÇǰһ¶Îʱ¼äÔÚÔ¶³Ì·þÎñÆ÷ÉÏÐÞ¸ÄÁ˸ÃÊý¾Ý¿âµÄÃÜÂ룬ÿ´Îµã»÷¸Ã×¢²á·þÎñÆ÷ϵͳҪµÈºÜ³¤Ê±¼ä£¬ÏóËÀ»úÒ»Ñù£»ÐÞ¸ÄÁ¬½ÓÊôÐÔÒ²Ð޸IJ»ÁË£¬µã»÷ºóҲûÓз´Ó¦£¬ÓÚÊǾÍÏëɾ³ýÖØÐÂ×¢²á£¬¼ÈÈ»ÎÞ·¨ÔÚ¹ÜÀíÆ÷Àïɾ³ý£¬¾ÍÏë´Ó×¢²á±íÀïɾ³ý£¬ÕÒÁ˺þÃÖÕÓÚÕÒµ½ÁË£¬¶ÔÓ¦µÄsql serverµÄ×¢²á·þÎñÆ÷ÔÚ£º
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server ×éÖУ¬
Ö±½Óɾ³ýÄãÄãҪɾ³ýµÄÄǸö×¢²áÃû¾Í¿ÉÒÔ
ÔÚMSSQLÆóÒµ¹ÜÀíÆ÷Ìí¼ÓµÄ×¢²áµÄSQL·þÎñÆ÷ºó£¬Èç¹ûijÌìÒѾ­×¢²áºÃµÄSQL·þÎñÆ÷²»´æÔÚÁË£¬»òÕ߸ü»»IPÁË£¬ÄÇôÂé·³¾ÍÀ´ÁË£¬Ïëɾ³ýËü¶¼ºÜÂé·³£¬µã»÷µ½ÄǸöÎÞЧµÄSQL·þÎñÆ÷£¬Í¨³£¶¼ÊǑδÏìÓ¦’£¬ÄãÏëÓÃÓÒ¼üɾ³ýËü°É£¬Ò²ÊÇÒ»ÑùµÄδÏìÓ¦£¡µ±È»Å¼¶û¿ÉÒÔµã»÷ÓÒ¼üºó£¬²»ÒªÔÙ¶¯Êó±ê£¬µÈ´ýÄǸöδÏìÓ¦Ïûʧºó£¬¿ÉÒÔÔÚµ¯³öµÄÓÒ¼ü²Ëµ¥Éϵãɾ³ý£¡µ«ÊÇ£¬ÓÐÕâ¸öʱ¼äÒѾ­¿ÉÒÔ˯һ¾õÁË£¡Ë­ÓÐÕâ¸öÄÍÐİ¡£¡
׿±Á˰ɣ¬Ïë×ŰÑÕû¸öSQL   Server×鏸ɾ³ýÁË£¬ÓÚÊÇÔÚSQL   Server×éµÄ×éÃûÉϵãÓÒ¼ü,Ñ¡Ôñ"ɾ³ý",Ìáʾ"·þÎñÆ÷×éÖк¬ÓÐÖÁÉÙÒ»¸ö·þÎñÆ÷»ò×Ó×é,Òò´ËÎÞ·¨É¾³ý¸Ã×é".   ¸ü¼±Á˰ɣ¿Ð¡Ñù¾ÍÊDz»ÈÃÄãɾ³ý£¡
ÏëÏëËãÁ˰ɣ¬É¾³ý²»Á˾Ͳ»É¾³ýÁË£¬¿ÉÊÇÄÄÌì¹ÜÀíÊý¾Ý¿âµÄʱºòÓÖ²»Ð¡Ðĵã»÷µ½ÄÇЩÎÞЧµÄSQL×¢²á£¬MDÓÖδÏìÓ¦ÀϰëÌ죡
ËÑË÷ÁËϲŷ¢ÏÖÔ­À´¿ÉÒÔÔÚ×¢²á±íɾ³ý
ÔËÐÐCMD >>  regedit >>
´ò¿ª×¢²á±íÕâ¸öλÖÃ:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server
ÔÚÓÒ±ßɾ³ýÎÞЧµÄSQL×¢²áÃû!


Ïà¹ØÎĵµ£º

Ò»´Î²åÈë¶àÌõÐÅÏ¢(sql)

×¢ÊÍ:Ö»Êʺϵ¥±íµ¥ÁÐÊý¾Ý,
create database test
go
use test
go
create table users
(
:id int identity(1,1) primary key not null,
:name nvarchar(20)
)
go
create proc sp_Inserts
@Names nvarchar(4000)
as
declare @Name nvarchar(20),@ErrorSum int
:set @ErrorSum = 0
:begin tra ......

sql ¸÷ÖÖ×Ö·û´®ºÏ²¢·½·¨ µÚ¶þÖÖ·½·¨ºÃ(ÀûÓú¯Êý)

--3.3.1 ʹÓÃÓα귨½øÐÐ×Ö·û´®ºÏ²¢´¦ÀíµÄʾÀý¡£
--´¦ÀíµÄÊý¾Ý
CREATE TABLE tb(col1 varchar(10),col2 int)
INSERT tb SELECT 'a',1
UNION ALL SELECT 'a',2
UNION ALL SELECT 'b',1
UNION ALL SELECT 'b',2
UNION ALL SELECT 'b',3
--ºÏ²¢´¦Àí
--¶¨Òå½á¹û¼¯±í±äÁ¿
DECLARE @t TABLE(col1 varchar(10),col2 varch ......

SQL ServerË÷Òýͳ¼ÆÐÅϢδ¼°Ê±¸üУ¬µ¼ÖÂÅÅÐò»ìÂÒ

½ñÌ죬Óöµ½ÁËÕâÑùµÄÒ»¸öÀý×Ó£º
SQL ServerË÷Òýͳ¼ÆÐÅϢδ¼°Ê±¸üУ¬µ¼ÖÂÅÅÐò»ìÂÒ
ÎÒÃÇÖªµÀ£¬ÔÚsql
serverÉÏ´´½¨Ë÷Òýºó£¬Í¬Ê±»á¶Ô¸ÃË÷ÒýÉϵÄÖµ½øÐÐÅÅÐò£¬µ«¶ÔÓÚÐÂÔö¼ÓµÄÖµ£¬Èç¹ûδÄܼ°Ê±¸üÐÂͳ¼ÆÐÅÏ¢£¬½«ÓпÉÄܵ¼ÖÂÅÅÐòµÄ»ìÂÒ£¬Ò²¾ÍÊÇûÓÐÅÅÐò¡£
ÕâÊDzúÉúÎÊÌâµÄÓï¾ä£º
Select * from V_L_IcStockProInEntry Where FInt ......

³£ÓÃSQLÃæÊÔÌâ £¨Ò»£©

Êý¾Ý¿âÃæÊÔ³£ÓòâÊÔÌâ(SQL Server)
ÌâÄ¿1
¡¡¡¡ÎÊÌâÃèÊö:
¡¡¡¡Îª¹ÜÀí¸ÚλҵÎñÅàѵÐÅÏ¢£¬½¨Á¢3¸ö±í:
¡¡¡¡S (S#,SN,SD,SA) S#,SN,SD,SA ·Ö±ð´ú±íѧºÅ¡¢Ñ§Ô±ÐÕÃû¡¢ËùÊôµ¥Î»¡¢Ñ§Ô±ÄêÁä
¡¡¡¡C (C#,CN ) C#,CN ·Ö±ð´ú±í¿Î³Ì±àºÅ¡¢¿Î³ÌÃû³Æ
¡¡¡¡SC ( S#,C#,G ) S#,C#,G ·Ö±ð´ú±íѧºÅ¡¢ËùÑ¡Ð޵Ŀγ̱àºÅ¡¢Ñ§Ï°³É¼¨
¡¡¡¡1. Ê¹Ó ......

SQLÊý¾Ý¿â»Ö¸´Ä£ÐÍ(ÈÕÖ¾)

----------------------------------------------------------------------
1¡¢SQLÊý¾Ý¿â»Ö¸´Ä£ÐÍ
----------------------------------------------------------------------
1£©ÍêÈ«»Ö¸´Ä£ÐÍ
-----------------
£¨1£©±¸·ÝʱҪ±¸·ÝÊý¾Ý¿âµÄÊý¾ÝÎļþºÍÈÕÖ¾Îļþ
£¨2£©»¹Ô­Ê±Ê¹ÓÃÊý¾Ý¿âµÄ±¸·ÝµÄÊý¾ÝÎļþ¸±±¾ºÍÈ«²¿ÈÕÖ¾ÐÅ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ