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

SQLServer֨װ±¨´íERROR 17750£¬ERROR 8355

СµÜ֨װSQLServer·þÎñÆ÷£¬»¹Ô­MasterÊý¾ÝÆô¶¯ºó±¨´íERROR 17750£¬ERROR 8355¡£
´íÎóÐÅÏ¢ÈçÏ£º
ERROR 17750
Could not load the DLL LEServer.dll, or one of the DLLs it references. Reason: 126(error not found).
ERROR 8355
Service Broker is disabled in MSDB or MSDB failed to start. Server level event notifications can not be delivered. Event notifications with FAN_IN in other databases could be affected as well.
²¹³ä˵Ã÷£º
»¹Ô­MASTERûÓÐÈκδíÎ󣬻¹Ô­ÖØÆô·þÎñºó²Å³öÏÖ¡£MasterÊý¾Ý¿â±¸·Ýǰ×ö¹ýDBCC£¬Ã»Óб¨´í¡£

Çë¸÷λ¸ßÊִͽÌ
SQLʲ麼°æ±¾

ÔÙ²¹³äWIN2003ÆóÒµ°æ+SQLServer2005ÆóÒµ°æ

»¹Ô­materÊý¾Ý¿â?

»Ø4Â¥
Ó¦¸Ã˵ÊÇ×ö±¸·ÝÓþµÏñµÄSQLServer·þÎñÆ÷£¬»¹Ô­ÆäËüÊý¾Ý¿âºó²»Äܵǽ¡£·þÎñÆ÷ȱÉٵǽÓû§¼°Õ˺ţ¬»¹ÓÐMasterÊý¾Ý¿âÄÚ°üº¬Óкܶà·þÎñÆ÷ÉèÖÃÐÅÏ¢¼°Î¬»¤½Å±¾£¬ËùÒÔÐèÒª»¹Ô­MasterÊý¾Ý¿â¡£

ÒýÓÃ
ÔÙ²¹³äWIN2003ÆóÒµ°æ+SQLServer2005ÆóÒµ°æ

ÐèÒªÓÃsqlcmd»òOsql

¸Ðлroy_88µÄÈÈÐĻشð

СµÜÎÒÒѾ­»¹Ô­ÁËMASTERÊý¾Ý¿â£¬²Ù×÷ûÓÐÎÊÌ⣨Ïàͬ²Ù×÷ÒÑÔÚÆäËü·þÎñÆ÷ÉÏ×ö²ÅÈô¸É´ÎʵÑ飩¡£
ÕâMASTERµÄÔ­·þÎñÆ÷²»ÊÇСµÜÎÒ°²×°µÄ£¬ÆäÖпÉÄÜÊÇËù°²×°µÄ²¿¼þ»òÕß²ÎÊýÉèÖò»Í¬¡£ËùÒÔ»¹Ô­ºó³öÏÖÕâÁ½¸ö´íÎó¡£
»¹Íû¸÷λÔٴͽ̡£

ÊÔÊÔ osql/s ·þÎñÆ÷Ãû/u Óû§Ãû/p ÃÜÂëÄܲ»ÄÜÁ¬½ÓÉÏ
ÔÚwindowsÃüÁî´°¿ÚÖ´ÐÐ

Master»¹Ô­ºó
·þÎñÆ÷ÔËÐÐÕý³££¬¾ÍÊÇ·þÎñÆô¶¯Ê±±¨´í¡£

ÒýÓÃ
Master»¹Ô­ºó
·þÎ


Ïà¹ØÎÊ´ð£º

Çó½Ì ²é¿´SqlServerÖ´ÐйýµÄ´æ´¢¹ý³Ì״̬

ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæÊ±²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

SwingÀïÃæµÄʼþÓëSQLserverÊý¾Ý¿âµÄÁ¬½ÓµÄÎÊÌâ

СµÜÏÖÔÚSwingÔÚÁ¬½ÓÊý¾Ý¿âÉÏÓöµ½Ò»µãÎÊÌ⣬ÇëÎÊSwingÀïÃæµÄʼþºÍSQLserverÊý¾Ý¿âµÄÁ¬½ÓÓÐʲôºÃµÄ×ÊÁÏÊéÍÆ¼öÂð£¿
Õâ¸öÓ¦µ±Ã»ÓÐÊ²Ã´ÌØ±ð,ÓëÆäËûµÄ±à³ÌÒ»Ñù.

JDBC

ÇëÎÊÔÚSwingÖмÓÔØ±³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿
......

sqlserver²éѯʱ¼ÓÉϱêʾÊýµÄÎÊÌâ

Êý¾Ý±í 1
Æ·ÖÖ    ¼Û¸ñ    ÈÕÆÚ
Ãæ°ü      1      1ºÅ
Ãæ°ü      2      1ºÅ
Ãæ°ü      3  & ......

sqlserver ´æ´¢¹ý³ÌÈçºÎ¶¯Ì¬µÄÉùÃ÷ ±äÁ¿

create procedure test

as
declare @var_0 varchar(100)
declare @cc int
set @cc=0
exec('select @var_'+@cc +'=fullName from contact')

go
exec test


......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ