??????? ??????????? ?? ??? Visual Studio 2005 ??? ??????? ?? ??? ???? ???? (SR1) 1 ??????

???? ?????? ???? ??????
???? ID: 936612 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

???? ???? 1 (SR1) Microsoft Visual Studio 2005 ??? ??????? ?? ??? ??????? ??????????? ?? ??? ?????? ??? ?? ?????? ?? ??? ?????? ??? 1 (?? ?????? ???????) ?? ??? Visual Studio 2005 Professional ?????? ???

???? ???????

????? ???????? ?? ???? SR1 ??? ??? ???? ???? ?? ???????? ?? ?????? ?? ???????? ?? ??????????? ?? ?????? ?? ???? ??? ???
  • ?????-??????? ??????

    ?????? ?? ????? ?? ?? ??????? ????????? ?????? ?? ????? ?? ?? ??????? ????????? (.dbmeta) ?? ???????? ?? ????? ??????? ??? ???????? ?????? ?? ???? ???? ?? ?????? ?? ?? ?? ???? ?? ?? ???? ??????? ????????? ??? ?????-??????? ?????? ?????????? eliminates.
  • SQL ????? ????? ?????? ??? ????? ?? ?????? ??? ?????

    ?? ??????? ?? ????????? pre-deployment ?????? ??? ???? ???? ????? ???? ?? ????? ?? ??????? ????????? ??? ?? ??? ??? ????? ?????? ??? ??????? ????????? ?? ???? ????
  • ???????

    A?????????????? ??? ????? ????? ??? ?? ??? ????? ???? ?? ????????? ???? ?? ??? ?????setvar??????? ????????? ??? ????? ?? ??? ???
??? ??, SR1 Microsoft SQL Server 2005 ?? ?????? ???? ??? ?????? ?????? ???? ??? ??????? ???, ?????? ?????? ??? ?????? ??? 2 (SP2) ??? SR1 ?? Windows Vista ???????? ?????? ?? ???????

?????? ??????????

??????? ???????? ????????

  • Microsoft Windows 2000 Professional ?????? ??? 4 (SP4)
  • Microsoft Windows 2000 ????? SP4
  • Microsoft Windows 2000 ????? SP4 ????? ????
  • Microsoft Windows 2000 Datacenter ????? SP4
  • Microsoft Windows XP Professional x64 ??????? (WOW)
  • Microsoft Windows XP Professional ?????? ??? 2 (SP2)
  • Microsoft Windows XP Home Edition SP2
  • Microsoft Windows XP Media Center Edition 2002 SP2
  • Microsoft Windows XP Media Center Edition 2004 SP2
  • Microsoft Windows XP Media Center Edition 2005
  • SP2 ??????? ??? Microsoft Windows XP ??? ??????? PC
  • Microsoft Windows Server 2003 Standard Edition ?????? ??? 1 (SP1)
  • Microsoft Windows Server 2003 ??????????? ??????? SP1
  • Microsoft Windows Server 2003 SP1 ??????? ??? Datacenter
  • Microsoft Windows Server 2003 SP1 ??????? ??? ???
  • Microsoft Windows Server 2003 ???? 64 ??????? SP1 x (WOW)
  • Microsoft Windows Server 2003 ??????????? ??????? SP1 64 x (WOW)
  • Microsoft Windows Server 2003 Datacenter 64 ??????? SP1 x (WOW)
  • Microsoft Windows Server 2003 R2 Standard Edition
  • Microsoft Windows Server 2003 R2 ???? x 64 ??????? (WOW)
  • Microsoft Windows Server 2003 R2 ??????????? ???????
  • Microsoft Windows Server 2003 R2 ?????????? x 64 ??????? (WOW)
  • Microsoft Windows Server 2003 R2 Datacenter ???????
  • Microsoft Windows Server 2003 R2 Datacenter x 64 ??????? (WOW)
  • Windows Vista
???:????? Studio 2005 Intel Itanium (IA-64) ?? ??????? ???? ???

???? ?????? ??????????

??????? ??????????? ?? ??? Microsoft Visual Studio 2005 ??? ??????? ??? ???????? ?? ????? ?????? ?? ??? ?????????? ??? ???? ??????? ??????????? ?? ??? Visual Studio 2005 ??? ??????? ?? ??????? ???? ?? ??? ?? ??????? ???? ??? ?????:
  • 2.0 GHz ?? ???? ????????
  • RAM ?? ???? 512 MB (1 ???????? (GB) ?? ???? ????????)
  • ????? ????? ????? ?? 3 GB
  • ??? DVD ??????
  • ???? 1024 x 768 ?? ????-??????????? ?? ???????? 256 ????? ??? ??
  • ??? ???????? ?? ?? Microsoft ???? ?? ???? ????? ??????
  • Microsoft SQL Server 2005 (?????? ???????, ??????????? ???????, Standard Edition, ????????? ??????? ?? ????????? ???????) ?? ??? ???????

????? ?????

???????

???????? ?? ????????? ?????? ??? ??? ????????
?? ????????? ?????? ?????????? ?? ??? ??????? ????? ??? ????? ??? ?? ????? ???? ?? ????:
  • ?????? ? ?? ???? ????ALTER ?????? [?? ??? {?? ???? ???? | NOCHECK}] {?? ???? ???? | NOCHECK} ????????
  • ????? ????? ?ALTER ?????? [?? ??? {?? ???? ???? | NOCHECK}] {?? ???? ???? | NOCHECK} ????????
  • DML triggers ?ALTER ?????? {ENABLE | DISABLE} ?????? TriggerName
  • DML triggers ?{[??????.] ?????? ????? ????TriggerName ???? ObjectName
  • ??????? triggers ?{[??????.] ?????? ????? ??????????? TriggerName ???? ????
  • ??? ????? triggers ?{[??????.] ?????? ????? ??????? ????? TriggerName ???? ????
  • ???????? ?ALTER ?????? {????? | ?????} ??? ??????
  • ??????????? ?ALTER ??????????? ????? ????
  • ?????-??? ????????????? ?' ????? ' ALTER ???????? INDEX ???? TableName {| DISABLE}
  • Queues ?ALTER ???? ObjectName ?????? ?? ??? = {???? | OFF}
?? ?????? ?? ?? ???? ?? ??? ?? ??? ?? post-deployment ????????? ??? ?? ?? ?????? ????? ???? ?????? ???? Post-deployment ????????? ???? ?? ???? ??? ???? ??????? ?? ??? ?????? ???????? ??????
?????????? ?? ????? ?? ??? ??? ??????? ?????? ?? ???? ???
???? ??? ????? Transact SQL ??? ?? ?? ????? ?? ??? ?? ??? ?? SQL Server ?? ????? ???????? ??? ??????? ???? involves ?? ??? ??? ??????? ??????? ?? ???? ??? ?????? ?? ???, ?? ????? ????? ??????? ??? ???? ???:
CREATE VIEW [dbo].[View1]
AS 
	SELECT column_2 FROM 
	Table1 LEFT OUTER JOIN (SELECT column_1 FROM Table2 as T_T2) as B on 1 = 1
	   LEFT OUTER JOIN (SELECT column_1 FROM Table3 as T_T3) as C on 1 = 1
???????, ?? ??????? ????? ?? ? ?? ??? ???? ?? ??? ???? column_1 T_T3 ?? ??? ??? Table3 ?? ? ?????? ?? ????????? ???

?? ?????? ?? ?? ???? ?? ??? ???? ??? ?????? ????? ????? ?????? ?? ???, ????? ??? ?? ???????????? ???? ?? ??? ????? ??? ?? ????? ?? ???? ???:
CREATE VIEW [dbo].[View1]
AS 
	SELECT column_2 FROM 
	Table1 LEFT OUTER JOIN (SELECT column_1 FROM Table2 as T_T2) as B on 1 = 1
	   LEFT OUTER JOIN (SELECT T_T3.column_1 FROM Table3 as T_T3) as C on 1 = 1
Vardecimal ?????? ??????
????? Studio 2005 ??? ??????? ??????? ??????????? ?? ??? vardecimal ?????? ?????? ???? ?????? ???? ????? ?? ?????? ?? ?????? SQL Server 2005 SP2 ??? ???? ???? ??? ??? ??? ?? ??? ?????? vardecimal ?????? ?????? ?? ??????? ?? ??? ?? ?? ?? ???? ???????? ?? ??? ????? ???? ?? ?? ???? ??????? ?? ???? ?? ??, ?? vardecimal ?????? ?????? ?????? ????? ???? ??? ??? ?????? ??????? ?? ???? ??? ???????, ScriptsIgnoredOnImport.sql ????? ?? ??? ??? ????? ????? ???? ???? ?? ????? ?? ??????? ????????? ?? ????????? ?? ???? ???? ???????, ????? ????????? ???? ??? vardecimal ?????? ?????? ??? ??? ?????? ?? ??????? ????

?? ?? ? ???????? ??? ?? ?? ????????? ?? ????? ????? ??? ???? ????:
-- enable vardecimal storage format for database
exec sp_db_vardecimal_storage_format 'DatabaseName', 'on'
-- enable vardecimal storage format on t1 in database
exec sys.sp_tableoption 'TableName', 'vardecimal storage format', 'on'
??????? ?????? ?????? ?? ??? ??? ScriptsIgnoredOnImport.sql ????? ??? ???? ?? ???? ??? ?????? ?????? ?????? ?? ??? ?????? ?? ??? ??????? ??? ???? ?? ???? ??? ?????? ?????? ?? ??????? ?? vardecimal ????? ???? ?? ?? ??? ????????? ???? ???? ??? ?? ??????? ??????? ????????? ?? ?????? ???? ???? ?? ???? ??? ?? ??? ?? ???? ???? ?? ??? ?????? ?????? ?????? ?? ???? ???? ???

?? ?? ???? ??????? ?? ?? ?????? ?? ???? ???? ??? ?? ?????? ?? ?? ????, ???? ?? ??? ??????exec sp_db_vardecimal_storage_format??? pre-deployment ????????? ?? ??? ??? ???, ??????exec sys.sp_tableoption??? ???????? ??? ?????? ?? vardecimal ?????? ?????? ?? ????? ???? ????? ????

?? ?? ?? ????????? ???? ?????? ?? ??????, ???? ?? ??? ??????exec sp_db_vardecimal_storage_format??? pre-deployment ????????? ?? ??? ???
?? ?? ???? ??????? ?????? ????????? ???? ?? ??? ? SELECT * ??? ? ??? ?? ????? ???????? ??????????
??? ????? Transact SQL ??? ?? ?? involves ?? ??? ??? ??????? ??????? ?? ???? ?? ?? ?????? ??? ???? *??? ??? ?? SQL Server ?? ????? ???????? ??? ??????? ???? ??? ??????? ?????? ?? ????????? ???? ?? ??? ??? ?????? ?? ???, ?? ????? ??? ????????? ?? ???? ??:
CREATE TABLE [dbo].[userprofile] (
    [user_id] [INT] NOT NULL,
    [keyname] [VARCHAR](30) NOT NULL,
    [value] [VARCHAR](50) NOT NULL,
)

CREATE PROCEDURE [dbo].[testtemp]
AS
BEGIN
    SELECT * INTO #up FROM [dbo].[userprofile]

    UPDATE #up 
        SET value='value'
    WHERE keyname='key'
END;
???????, ????? ?????????? ????? ?? ???? ??:
98 TSD3028 ???????: ????? ?????????? ??? ???? ??????? ????????? ?? ??? ??: [Variable|column] dbo. # up.value. ???? ??????? ????????? ?????? ?? ???? ?? ???? ?? ?? [?????????] dbo.testtemp ????????? ???

99 TSD3028 ???????: ????? ?????????? ??? ???? ??????? ????????? ?? ??? ??: [Variable|column] dbo. # up.keyname. ???? ??????? ????????? ?????? ?? ???? ?? ???? ?? ?? [?????????] dbo.testtemp ????????? ???
?? ?????? ?? ?? ???? ?? ??? ???? ??? ?????? ????? ????? ?????? ?? ???, ????? ??? ?? ???????????? ???? ?? ??? ????? ??? ?? ????? ?? ???? ???:
CREATE PROCEDURE [dbo].[testtemp]
AS
BEGIN
    SELECT user_id, keyname, value INTO #up FROM [dbo].[userprofile]

    UPDATE #up 
        SET value='value'
    WHERE keyname='key'
END;
??? ?? ???? ?????? ?? ????????? Visual Studio ??? ??????? ?? ?????? ??????? ??? T-SQL ?????? ??? Windows 2000 ?? ??????? ??????????? ?? ???, ??? ??? ????? ?????? ??? ?? ??????? ?? ?????? ??? ????????? ???? ?? ??? ????? ???? ??? ?????? ??? ?????? ???? ??? ?? ????????? ???? ?? ???? ?? ???? ????? ???? ?? ???? ?? ?????? ?? ?? ???? ?? ???, ????? ????? ?? ???? ????::
  1. ????? ????????????? ??,??????.
  2. ???????????????? ????? ???, ??????? ??????????????, ?? ???? ???????? ?? ???.
  3. ??????????-???? ???? ?? ??? ???????? ??????????? ???, ????? ????T-SQL ?????? ?????? ???.
  4. ??? ?? ??? ????????? ????????? (?? ????? ?????? ??????? ????? ????? ????? ???? ??)??????:??? ????? ?? ??? ?? ?????? ???? ?????? ???? ???

    ?????? ??? ?? ??????? ?? ?????? ??? ?? ????????? ???? ????? ??? ??? ???

???? ?? ????? ?? ?? ?????? ?? ????? ??

???? ?? ????? ??? ??? ????? ??????
???? ?? ????? ?? ????? ?????? ?? ?? ??????, ???? ????????? (,) ??? ????? ????? ?????? ???? ?? ????? ???? ???? ????? ?? ??? ?? ??? ?? ??????? ?? ??? ????? ?????? ?? ??? ??? ????? ?? ????? (.) ?????? ???? ???? ??????, ???????? ?? ???, ???? ??????? ?? ??? ????? ?????? ????? ?????

???? ?? ?????? ?? ??? ??? ?????? ??? ???
?? ?? ?????? filegroups ?? ??????? ?? ????? ??? ?????? ?? ????? ?? ?????????
?? ?? ??????? ?? ???? ?????? ?? ?????? ???? ?? ??? ????? ?????? ?? ????? ??? ??? ?????? ?? ???? ??? ??? ?? ????? ?? ????? ??? ?????? ?? ?????? ??????? ?? ?????? ???? ?? ?????? ???? ??? ?? ?????? ????? ??????? ?? ???? ?? ???SETVAR?? ????? ?? ?? ???? ?? ???? ?? ?????? ???? ?? ??????? ?? ??? ?? ????????? ???? ?? ??? ??????? ???? ?????? ?? ????? ?????????????????? ????????? ??? ????

?? ?????? ?? ?? ???? ?? ???, ????? ????? ?? ???? ????::
  1. ????? ????????:???? ??,?? ??????? ?????? ????-????? ????, ?? ???? ?????????:.
  2. Transact SQL ?????? ??? ?????? ??? ?? ????? ???? ?? ??? ?????? ????????? ?? ??? ?? ??? ??????SETVAR?? ????? ?? ?? ???????? ???? ??? ????? ???? ????
  3. ????? ????????:???? ??,T-SQL ???????? ????-????? ????, ?? ???? ???SQL ????????? ????.

SR1 ?????? ??????? ???? ?? ??? ???? ????

??????? ??????????? ?? ??? Microsoft Visual Studio 2005 ??? ??????? ?? ??? ???? ???? 1 (SR1) ??????? ????, ????? Microsoft ??? ???? ?? ????:
HTTP://www.Microsoft.com/downloads/details.aspx?FamilyID=9810808c-9248-41a5-bdc1-d8210a06ed87

???

???? ID: 936612 - ????? ???????: 06 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft Visual Studio 2005 Team Edition for Database Professionals
??????: 
kbtshoot kbinfo kbmt KB936612 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:936612

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com