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

ÀûÓÃSQLSERVERµÄʼþ̽²âÆ÷ÕÆÎÕÓÃÓÑϵͳµÄ±í½á¹¹

SQLSERVERµÄʼþ̽²âÆ÷ÊÇÒ»¸öºÜÇ¿´óºÜÖ±¹ÛµÄ¹¤¾ß£¬µ±ÎÒÃÇÔÚERPϵͳÀïÃæ×öÒ»¶¨²Ù×÷µÄʱºò£¬¶¼»áÔÚÊý¾Ý¿âÀïÃæÐγɲéѯ»òÕßÔöɾ¸ÄµÄT-SQLÓï¾ä¡£Í¨¹ýʼþ̽²âÆ÷¾Í¿ÉÒÔÖªµÀERPÀïÃæµÄµ¥¾ÝÔÚÊý¾Ý¿âµÄÄĸö±íÀïÃæ£¬ÉõÖÁÄĸö×Ö¶ÎÀïÃæ¡£»¹¿ÉÒÔ¸ù¾Ý̽²âµ½µÄSQLÓï¾ä·ÖÎöERPϵͳµÄ±í½á¹¹£¬±íÖ®¼äµÄ¹ØÁª×Ö¶ÎÊÇÄĸö¡£
´ó¼Ò³õ´ò¿ªÊ¼þ̽²âÆ÷ʱ¿ÉÄÜ»á¸ã²»´óÇå³þ£¬ÒòΪERPÔÚÔËÐÐʱ£¬ºǫ́µÄSQLÓï¾äÁ¿ÊǺܴóµÄ£¬1ÃëÖÓ¿ÉÒÔÌø¸ö¼¸Ê®Ìõ£¬Äã¸ù±¾²»ÖªµÀÄľäSQLÊÇÕë¶ÔÄãµÄ²Ù×÷µÄ¡£
ÕâÀï¾Í¸ú´ó¼Ò·ÖÏí1Ï£¬1¸öºÜºÃµÄ·½·¨¾ÍÊÇÔÚ´ò¿ªÊ¼þ̽²âÆ÷ʱ£¬ÔÚÄ£°åÉèÖýçÃæµÄµÚÈý¸öÑ¡ÏÀïÃæ°Ñ"hostname"¸øÑ¡ÉÏ£¬È»ºóÔÚµÚËĸöÑ¡Ï£¨Êý¾ÝÁУ©ÀïÃæÕÒµ½hostname£¬´ò¿ªÄ¿Â¼Ê÷£¬ÉèÖÓͬÓÚ¡¾ÄãµÄ¼ÆËã»úÃû×Ö¡¿”£¬µãÈ·¶¨¡£ÕâÑùʼþ̽²âÆ÷¾ÍÖ»¸ú×ÙÄãµçÄÔÉϵÄERPÔÚÊý¾Ý¿â×öµÄ²Ù×÷¼Ç¼¡£
Äã¿ÉÒÔ°ÑÓÐÓõÄSQLÓï¾ä¸´ÖƵ½²éѯ·ÖÎöÆ÷ÀïÃæ£¬È»ºóselect top 1 * from Ö»ÏÔʾ1ÐУ¬»á³öÀ´Êý¾Ý¡£Õâ¸öÊý¾Ý¸úǰ̨ERPÀïÃæµÄÊý¾ÝÈ¥ºË¶Ô£¬Äã¾ÍÖªµÀÕâ¾äSQLÔÚ¸ÉÂËûµÄÿ¸ö×ֶδú±íʲôÒâ˼¡£
ÓÃÓÑ×öÁ˺ܶàµÄÊÓͼ£¬¶ÔÓÚÎÒÃÇ×ö×Ô¶¨Ò屨±íÈ¡Êý¾Ý»áºÜ·½±ã¡£µ«ÊÇÕâЩÊÓͼµÄ×ÊÁÏÍøÉÏ»ù±¾ÕÒ²»µ½£¬ËùÒÔÀûÓÃʼþ̽²âÆ÷¿ÉÒÔ½Ó´¥µ½ÕâЩÊÓͼ¡£
ÁíÍâÓÃÓÑÿ¾äSQL¶¼»á´ø1¾äset nocount on ÆäʵÕâ¾ä»°Ã»Ê²Ã´Òâ˼£¬¾ÍÊÇÈÃSQLSERVER²»¸øERP·µ»Ø´Ë´Î²Ù×÷Ó°ÏìµÄÐÐÊý£¬ÕâÑù¿ÉÒÔ½ÚÊ¡Á÷Á¿¡£
ÏȽéÉܵ½ÕâÀÀûÓÃÕâ¸ö·½·¨¿ÉÒÔ½â¾öºÜ¶àºÜ¶àÎÊÌ⣬»òÕß˵¿ÉÒÔÌṩºÜ¶à½â¾öÎÊÌâµÄ˼·¡£
µ±È»ÁË£¬ÐÞ¸ÄÊý¾Ý¿âÊý¾Ý֮ǰ¶¼Òª±¸·ÝÊý¾Ý¿â¡£


Ïà¹ØÎĵµ£º

sqlserver ×Ô¶¨Ò庯ÊýËæ»ú²úÉúÖ¸¶¨·¶Î§µÄËæ»úÊý

/*
--´´½¨ÊÓͼ
create view RandomView as select re=rand()
--×Ô¶¨Ò庯Êý:È¡µÃÖ¸¶¨·¶Î§µÄËæ»úÊý
create function RandData(
@a int,
@b int)
returns decimal(38,0)
as
begin
declare @r decimal(38,0)
select @r=cast(re*(@b-@a)+@a as decimal(38,0)) from RandomView
return(@r)
end
go
s ......

SQLSERVERÍâÁ¬½Ó·û

±íA
tmpA:
id     name
00     Ãû×ÖA
01     Ãû×ÖB
02     Ãû×ÖC
03     Ãû×ÖD
04     Ãû×ÖE
tmpB:
id     class
02     °à¼¶A
06 & ......

mysql,sqlserver,oracleÈýÖÖÊý¾Ý¿âµÄ´ó¶ÔÏó´æÈ¡


mysql ´ó¶ÔÏó´æÈ¡:
ÀàÐÍÒ»°ãÓ¦¸ÃÓÃmediumblod,
blobÖ»ÄÜ´æ2µÄ16´Î·½¸öbyte,
mediumblodÊÇ24´Î·½,
Ò»°ãÀ´Ëµ¹»ÓÃÁË.longblobÊÇ32´Î·½ÓÐЩ´ó.
MYSQLĬÈÏÅäÖÃÖ»ÄÜ´æ1M´óСµÄÎļþ,ÒªÐÞ¸ÄÅäÖÃ,WIN°æ±¾µÄÔÚmysql.iniÎļþÖÐ
ÐÞ¸Ämax_allowed_packet,net_buffer_lengthµÈ¼¸¸ö²ÎÊý,»òÖ±½ÓSET GLOBAL varName=value.
linux°æ± ......

ѧϰ£ºÁ½ÖÖSqlServerÊý¾Ý¿âÁ¬½ÓµÄʾÀý´úÂë

1¡¢ÊµÀýÒ»£º
public void SqlConnectionOpen()
{
        SqlConnection myConn=new SqlConnection();
        myConn.ConnectionString="server=(local);database=pubs;Trusted_Connection=yes";
        ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ