SQL Server 2005 18452,18470µÇ¼´íÎóµÄ½â¾ö·½·¨
±¾ÎĵØÖ·£ºhttp://qzone.qq.com/blog/236000056-1217427602
ÎÞ·¨Á¬½Óµ½·þÎñÆ÷
·þÎñÆ÷£ºÏûÏ¢18452, ¼¶±ð16£¬×´Ì¬1
[Microsoft][ODBC SQLServer Driver][SQL Server]Óû§‘sa’µÇ½ʧ°Ü¡£ÔÒò£ºÎ´ÓëÐÅÈÎSQL ServerÁ¬½ÓÏà¹ØÁª
¸Ã´íÎó²úÉúµÄÔÒòÊÇÓÉÓÚSQL ServerʹÓÃÁË"½öWindows"µÄÉí·ÝÑéÖ¤·½Ê½£¬Òò´ËÓû§ÎÞ·¨Ê¹ÓÃSQL ServerµÄµÇ¼ÕÊ»§£¨ÀýÈçsa )½øÐÐÁ¬½Ó£¬½â¾ö·½·¨ÈçÏÂ
ÉèÖÃÔÊÐíSQL ServerÉí·ÝµÇ¼(»ù±¾ÉÏÕâ¸öºÜÓÐÓÃ)
²Ù×÷²½Ö裺
1¡£ÔÚÆóÒµ¹ÜÀíÆ÷ÖУ¬Õ¹¿ª"SQL Server×é"£¬Êó±êÓÒ¼üµã»÷SQL Server·þÎñÆ÷µÄÃû³Æ
2¡£Ñ¡Ôñ"ÊôÐÔ"
3¡£ÔÙÑ¡Ôñ"°²È«ÐÔ"Ñ¡Ï
4¡£ÔÚ"Éí·ÝÑéÖ¤"Ï£¬Ñ¡Ôñ"SQL ServerºÍWindows"
5¡£È·¶¨,²¢ÖØÐÂÆô¶¯SQL Server·þÎñ¡£
Èçͼ:
½Ó×ÅÓÃ"sa"ÔÚSql Server2005µÇ¼ʱ±¨ÒÔÏ´íÎó:
Login failed for user 'sa'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)
½â¾ö·½·¨:
£¨Ò»£©£ºÓÃWindowsÑé֤ģʽ½øÈëÖÎÀíÆ÷ÖÐ
£¨¶þ£©“°²È«”==¡·“Óû§”==¡·Ë«»÷Óû§sa£¨µ¯³öÊôÐÔ¶Ô»°¿ò£©==¡·“״̬”
£¨Èý£©£º°Ñ״̬¸Ä³Éenable£¬Í˳öÖÎÀíÆ÷ÖØеǼ£¨Óû§Ñé֤ģʽ£©¡£
ÎÊÌâ½â¾ö!!!
Ïà¹ØÎĵµ£º
£±.½¨Ò»ÕÅ±í¡¡´æ·ÅÊý¾Ý¡¡ÔÚÏÂÃæ£Ó£Ñ£Ìº¯ÊýÖÐÓÐÓõ½
create table solardata
(
yearid int not null,
data char(7) not null, ......
1 Export data to existing EXCEL file
from SQL Server table
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\testing.xls;',
'SELECT * from [SheetName$]') select * from SQLServerTable
2 Export data from Excel to new SQL Server table
select *
into SQLServerTab ......
½éÉÜ
ÎÒÃÇÒ»ÆðÀ´×ö¸öʾÀý£¬ÔÚ.NETÖÐн¨Ò»¸öÀ࣬²¢ÔÚÕâ¸öÀàÀïн¨Ò»¸ö·½·¨£¬È»ºóÔÚSQL ServerÖе÷ÓÃÕâ¸ö·½·¨¡£°´ÕÕ΢ÈíËùÊö£¬Í¨¹ýËÞÖ÷ Microsoft .NET Framework 2.0 ¹«¹²ÓïÑÔÔËÐпâ (CLR)£¬SQL Server 2005ÏÔÖøµØÔöÇ¿ÁËÊý¾Ý¿â±à³ÌÄ£ÐÍ¡£ ÕâʹµÃ¿ª·¢ÈËÔ±¿ÉÒÔÓÃÈκÎCLRÓïÑÔ£¨ÈçC#¡¢VB.NET»òC++µÈ£©À´Ð´´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ºÍÓ ......
SQLµ÷ÓÅ Ö® Á¬½Ó·½Ê½
JoinÊÇÒ»ÖÖÊÔͼ½«Á½¸ö±í½áºÏÔÚÒ»ÆðµÄν´Ê£¬Ò»´ÎÖ»ÄÜÁ¬½Ó2¸ö±í£¬±íÁ¬½ÓÒ²¿ÉÒÔ±»³ÆΪ±í¹ØÁª¡£ÔÚºóÃæµÄÐðÊöÖУ¬Ê¹ÓÔrow source”À´´úÌ攱픣¬ÒòΪʹÓÃrow source¸üÑϽ÷һЩ£¬²¢ÇÒ½«²ÎÓëÁ¬½ÓµÄ2¸örow source·Ö±ð³ÆΪrow source1ºÍrow source 2¡£Join¹ý³ÌµÄ¸÷¸ö²½Öè¾³£ÊÇ´®ÐвÙ×÷ ......
MySQL Date º¯Êý
ÏÂÃæµÄ±í¸ñÁгöÁË MySQL ÖÐ×îÖØÒªµÄÄÚ½¨ÈÕÆÚº¯Êý£º
º¯ÊýÃèÊö
NOW()
·µ»Øµ±Ç°µÄÈÕÆÚºÍʱ¼ä
CURDATE()
·µ»Øµ±Ç°µÄÈÕÆÚ
CURTIME()
·µ»Øµ±Ç°µÄʱ¼ä
DATE()
ÌáÈ¡ÈÕÆÚ»òÈÕÆÚ/ʱ¼ä±í´ïʽµÄÈÕÆÚ²¿·Ö
EXTRACT()
·µ»ØÈÕÆÚ/ʱ¼ä°´µÄµ¥¶À²¿·Ö
DATE_ADD()
¸øÈÕÆÚÌí¼ÓÖ¸¶¨µÄʱ¼ä¼ä¸ô
DATE_SUB()
´ÓÈÕÆÚ ......