SqlServer ʵÏÖÈÕÆÚ²»Í¬¸ñʽµÄת»»£¡£¡
select
convert(char(4),auth,120)+'Äê'+
substring(convert(char(10),auth,120),6,2)+'ÔÂ'+
substring(convert(char(10),auth,120),9,2)+'ÈÕ',
convert(char(4),appr,120)+'Äê'+
substring(convert(char(10),appr,120),6,2)+'ÔÂ'+
substring(convert(char(10),appr,120),9,2)+'ÈÕ'
from a
ÒÔÉÏ´úÂëʵÏֵŦÄÜÊÇ°ÑÈÕÆÚ2008-10-10ת»»2008Äê10ÔÂ10ÈÕ
Ïà¹ØÎĵµ£º
±íA
tmpA:
id name
00 Ãû×ÖA
01 Ãû×ÖB
02 Ãû×ÖC
03 Ãû×ÖD
04 Ãû×ÖE
tmpB:
id class
02 °à¼¶A
06 & ......
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°æ± ......
1¡¢ÊµÀýÒ»£º
public void SqlConnectionOpen()
{
SqlConnection myConn=new SqlConnection();
myConn.ConnectionString="server=(local);database=pubs;Trusted_Connection=yes";
......
1£©Ð½¨Êý¾Ý¿âRESTORE
2£©ÔÚ¸ÃÊý¾Ý¿âÉÏÑ¡Ôñ£ºÈÎÎñ->»¹Ô->Êý¾Ý¿â
3£©ÔÚ»¹ÔÊý¾Ý¿â-RESTOREµÄ¶Ô»°¿òÖÐ
Ä¿±êÊý¾Ý¿âÊÇRESTORE
Ö¸¶¨ÓÃÓÚ»¹ÔµÄ±¸·Ý¼¯µÄÔ´ºÍλÖÃ->Ô´É豸->Ñ¡Ôñ×îºóÒ»¸öÍêÈ«µÄ±¸·ÝBAKÎļþ
¹´Öл¹ÔCheckBox
4£©Ñ¡Ôñ×óÉϽǵÄÑ¡Ïî
ÔÚ»¹ÔÑ ......
SQLSERVERµÄʼþ̽²âÆ÷ÊÇÒ»¸öºÜÇ¿´óºÜÖ±¹ÛµÄ¹¤¾ß£¬µ±ÎÒÃÇÔÚERPϵͳÀïÃæ×öÒ»¶¨²Ù×÷µÄʱºò£¬¶¼»áÔÚÊý¾Ý¿âÀïÃæÐγɲéѯ»òÕßÔöɾ¸ÄµÄT-SQLÓï¾ä¡£Í¨¹ýʼþ̽²âÆ÷¾Í¿ÉÒÔÖªµÀERPÀïÃæµÄµ¥¾ÝÔÚÊý¾Ý¿âµÄÄĸö±íÀïÃ棬ÉõÖÁÄĸö×Ö¶ÎÀïÃæ¡£»¹¿ÉÒÔ¸ù¾Ý̽²âµ½µÄSQLÓï¾ä·ÖÎöERPϵͳµÄ±í½á¹¹£¬±íÖ®¼äµÄ¹ØÁª×Ö¶ÎÊÇÄĸö¡£
´ó¼Ò³õ´ò¿ªÊ¼þ̽²âÆ÷ ......