Óû§"sa "µÇ½ʧ°Ü SQLServer ´íÎó18456
ÓÃwindowsÕ˺Ż¹ÊÇ¿ÉÒԵǼµÄ¡£
²éÕÒÎÊÌâµÄ¹ý³Ì£º
µÚÒ»²½£º Æô¶¯ËùÓÐÓëSQLÓйصķþÎñ£¬ÎÊÌâÒÀ¾É£»
µÚ¶þ²½£º ²é¿´windows·À»ðǽ£¬±»Ä¬ÈÏÆô¶¯ÁË£¬²»Æô¶¯Ñ¡ÔñÏî±»Disabled¡£Á½¸öÌáʾ“ÓÉÓÚ°²È«¿¼ÂÇ,ijЩÉèÖÃÓÉ×é²ßÂÔ¿ØÖÆ”“Windows·À»ðǽÕýÔÚʹÓÃÄúµÄÓòÉèÖÔ£¬ÏÈÓÃgpedit.msc´ò×é²ßÂÔ±à¼Æ÷£¬»úËã»úÅäÖÃ--¹ÜÀíÄ£°å--ÍøÂç--ÍøÂçÁ¬½Ó--Windows·À»ðǽ--±ê×¼ÅäÖÃÎļþ£¬²é¿´Óұ߸÷Ñ¡ÏîÊôÐÔ£¬¶¼ÊÇδÅäÖÃ״̬£¬ÎÊÌâ²»ÔÚÕâÀï¡£
ÁíÍâÒ»¸öÌáʾÖÐÌáµ½ÓòÉèÖã¬ÓòÉèÖò»¿ÉÄܽûÓÃSQL Server,²¢ÇÒÎҲ鿴±¾µØ¿ª·Å¶Ë¿Ú£¨netstart -an£©£¬25£¬1433£¬1434¶¼ÊÇ¿ª·¢×´Ì¬¡£
ÔΣ¬»á²»»áÊÇÃÜÂë´íÎó£¿
µÚÈý²½£ºÎÒÓÃwindowsÕ˺ŵǼ£¬Á¬½Ó³É¹¦ºó,, Ñ¡Ôñ"ÊôÐÔ"£¬
ÓÒ¼üʵÀý£¬ÔÚ"ÊôÐÔ"´°¿ÚÖÐ, תµ½"Security"(°²È«ÐÔ)Ïî, ²é¿´"·þÎñÆ÷Éí·ÝÑéÖ¤"ÖÐÉèÖÃȷΪ"SQL ServerºÍWindowsÉí·ÝÑé֤ģʽ",
È»ºóÖ´ÐÐÏÂÃæµÄÓï¾äÆôÓÃsaÓû§, ͬʱ¸ü¸ÄsaµÄÃÜÂë
EXEC sp_password 'sa',null,'sa'
ALTER LOGIN sa ENABLE
Ö´Ðгö´í£º
ÏûÏ¢ 15116£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
ÃÜÂëÓÐЧÐÔÑé֤ʧ°Ü¡£¸ÃÃÜÂëÌ«¶Ì£¬²»·ûºÏ Windows ²ßÂÔÒªÇó¡£
¹þ¹þ£¬ÎÊÌâÕÒµ½¡£
±¾µØÉèÖÿÉÄܱ»ÓòÉèÖø²¸Ç¡£¶øÓòÉèÖÃÖÐÖ¸¶¨ÁË°²È«²ßÂÔ£¬ÃÜÂë±ØÐëÓÐÒ»¶¨µÄ¸´ÔÓÐÔ¡£ÖØиü¸ÄsaÃÜÂ룬
EXEC sp_password 'sa','Uiop_098Mn','sa'
ALTER LOGIN sa ENABLE
ÎÊÌâ½â¾ö£¡
Ïà¹ØÎĵµ£º
CREATE function fGetPy(@str varchar(500)='')
returns varchar(500)
as
begin
declare @strlen int,@return varchar(500),@ii int
declare @c nchar(1),@chn nchar(1)
select @strlen=len(@str),@retur ......
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚÆäËü±à³ÌÓïÑÔÖеÄʼþº¯Êý£¬SQL Server? ÔÊÐíΪ INSERT¡¢UPDATE¡¢DELETE ´´½¨´¥·¢Æ÷£¬µ±ÔÚ±í£¨ÊÓͼ£©ÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQL Óï¾ä¡£
±¾×¨ÌâµÄÄ¿µÄ²¢·ÇÊÇÏòÄúÏ꾡µØ½éÉÜ´¥·¢Æ÷£¬¶øÊÇϵͳµØÏòÄú½éÉÜ´¥·¢Æ÷µÄ³£ÓÃ֪ʶÓëÏà¹ØÓ¦Ó㬲¢ÓëÄúÒ ......
1¡¢´´½¨Êý¾Ý¿âtestdb
2¡¢´´½¨±ítest
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[test](
[id] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[name] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[sex] [bit] NULL
) ON [PRIMARY]
3¡¢´´½¨Êý¾Ý¿âdb
......
select case when c.colid=1 then object_name(c.id) else '' end as ±íÃû
,c.name as ×Ö¶ÎÃû
,t.name Êý¾ÝÀàÐÍ
,c.prec as ³¤¶È ......
ÊÂÎñµÄ¹¦ÄÜÔÚsqlserverÖÐÓÉÀ´ÒѾã¬ÒòΪ×î½üÔÚ×öÒ»¸öÊý¾Ýͬ²½·½°¸£¬ËùÒÔÓлú»áÔÙ´ÎÑо¿Ò»ÏÂËüÒÔ¼°¿ìÕյȣ¬·¢ÏÖ»¹ÊÇÓкܶ಻´íµÄ¹¦Äܺ͸ĽøµÄ¡£ÕâÀïÒÔsqlserver2008µÄÊÂÎñ·¢²¼¹¦ÄÜΪÀý£¬¶Ô·¢²¼¶©Ôĵķ½Ê½¼òÒª½éÉÜһϲÙ×÷Á÷³Ì£¬Ò»·½Ãæ×ö¸ö×ܽᱸ·Ý£¬Ò»·½ÃæÓë´ó¼Ò½øÐÐһϷÖÏíºÍ½»Á÷¡£·Ñ»°¾Í² ......