SQL Server°²×°³ÌÐòÎÞ·¨»ñÈ¡ASPNETÕË»§µÄϵͳÕË»§ÐÅÏ¢
ǰЩÌì°²×°ÁËSQL Server2005£¬³öÁË2¸ö´íÎó£¬×îÖÕÔÚÍøÉÏÕÒµ½Á˽â¾ö°ì·¨£¬ÏÖÕûÀíһϡ£
´íÎóÒ»£º
½â¾ö·½·¨£º
ÓÃaspnet_regiisʵÓù¤¾ßÐ¶ÔØºÍÖØÐ°²×°Ò»Ï¾ͿÉÒÔÁË¡£
¾ßÌåµÄ²Ù×÷ÈçÏ£º
½øÈëCMD£º
ÊäÈë cd c:\windows\microsoft.net\framework\v2.0.50727£¬½øÈë´ËÎļþ¼ÐĿ¼Ï£¬ÔËÐÐaspnet_regiis -uÐ¶ÔØ
È»ºóÔËÐÐaspnet_regiis -i ÖØÐ°²×°£¬ÉÏÊöÎÊÌâ¼´¿É½â¾ö¡£
´íÎó¶þ£º
½â¾ö·½·¨£º
Õâʱºò¿ÉÒÔÔÝÍ£°²×°£¬²»Òªµã»÷ÖÐÖ¹¡¢ºöÂÔ£¬Ò²²»Òªµã»÷È¡Ïû¡£
°´ÒÔϲ½Öè
1¡¢É¾³ý×¢²á±íÖеļü£º
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSDTC
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC
HKEY_CLASSES_ROOT\CID
2¡¢Ê¹ÓÃcmdÖ´ÐРֹͣMSDTC·þÎñ£ºnet stop msdtc
3¡¢Ê¹ÓÃcmdÖ´ÐÐ Ð¶ÔØMSDTC·þÎñ£ºmsdtc -uninstall
4¡¢Ê¹ÓÃcmdÖ´ÐÐ ÖØÐ°²×°MSDTC·þÎñ£ºmsdtc -install
µã»÷ÖØÊԾͿÉÒÔ¼ÌÐø°²×°ÁË¡£
(ת×Ô£ºhttp://guangguang.163.blog.163.com/blog/static/32953490201001591652709/)
Ïà¹ØÎĵµ£º
Ò»¡¢ ÒýÑÔ
¡¡¡¡PHPÊÇÒ»ÖÖÁ¦Á¿Ç¿´óµ«Ï൱ÈÝÒ×ѧϰµÄ·þÎñÆ÷¶Ë½Å±¾ÓïÑÔ£¬¼´Ê¹ÊǾÑé²»¶àµÄ³ÌÐòÔ±Ò²Äܹ»Ê¹ÓÃËüÀ´´´½¨¸´ÔӵĶ¯Ì¬µÄwebÕ¾µã¡£È»¶ø£¬ËüÔÚʵÏÖÒòÌØÍø·þÎñµÄÃØÃܺͰ²È«·½ÃæÈ´³£³£´æÔÚÐí¶àÀ§ÄÑ¡£ÔÚ±¾ÏµÁÐÎÄÕÂÖУ¬ÎÒÃǽ«Ïò¶ÁÕß½éÉܽøÐÐweb¿ª·¢Ëù±ØÐèµÄ°²È«±³¾°ÒÔ¼°PHPÌØ¶¨µÄ֪ʶºÍ´úÂë-Äã¿ÉÒÔ½èÒÔ±£»¤Äã×Ô¼ºµÄwebÓ¦Óó ......
set r=%time%
echo %r%¿ªÊ¼µ¼Èë >>e:\c#\test.txt
osql -S (local) -U sa -P -d colorring -i e:\c#\11.sql >>d:\c#\test.txt
echo %r%µ¼ÈëÍê³É >>e:\c#\test.txt
ÆäÖÐ11.sqlÖÐΪ
bulk insert colorring..test from 'e:\c#\11.txt'
WITH (
FIELDTERMINATOR = ',',
ROWTERMINATOR ='\n' ......
Ò»¡¢Çå¿ÕÈÕÖ¾
DUMP TRANSACTION ¿âÃû WITH
NO_LOG
¶þ¡¢ÊÕËõÊý¾Ý¿âÎļþ(Èç¹û²»Ñ¹Ëõ,Êý¾Ý¿âµÄÎļþ²»»á¼õС
ÆóÒµ¹ÜÀíÆ÷--ÓÒ¼üÄãҪѹËõµÄÊý¾Ý¿â--ËùÓÐÈÎÎñ--ÊÕËõÊý¾Ý¿â--ÊÕËõÎļþ
--Ñ¡ÔñÈÕÖ¾Îļþ--ÔÚÊÕËõ·½Ê½ÀïÑ¡ÔñÊÕËõÖÁXXM,Õâ ......
Ò»¡¢Orcale ʱµÄ²éѯ
String hql = "from SmsTemplate t where 1=1 ";
if (model != null && !"".equals(model.getEndTimes())&& null!=model.getEndTimes() ) {
SimpleDateFormat dateFm = new SimpleDateFormat("yyyy-MM-dd"); //¸ñʽ»¯µ±Ç°ÏµÍ³ÈÕÆÚ
Date ......
¿ª·¢»·¾³£º
windows2003£¬°²×°ÁËvs2008¡¢SQL Server2005£¬ÕâÊÇ»ù´¡£¨µ±È»ÓÃvs2003£¬vs2005£¬SQL Server2000ɶµÄÒ²¿ÉÒÔ£¬²»¹ýеÄ×ÜÊǹ¦ÄÜÇ¿´óЩô£¬ºÇºÇ£©£»
ÒòΪ¿ª·¢Ê±¾ø´ó²¿·Öʱ¼äÊÇÔÚÄ£ÄâÆ÷Éϵ÷ÊÔ£¬¶ø²»ÊÇPPC£¬ËùÒÔÄ£ÄâÆ÷ÊDZØÐë°²×°µÄ¡£Õë¶ÔÄãµÄPPC²Ù×÷ϵͳѡÔñ¶ÔÓ¦µÄÄ£ÄâÆ÷Óësdk°ü£¬ÎÒ°²×°µÄÊÇWM6ÖÐÎİæµÄ¡££¨windows ......