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

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

?? ??? ??????

????? ???

????? ??????? 1 ????? (????? ?????? SR1 ??) ?? Microsoft Visual Studio 2005 ???? Edition ??????? "????? ????????". ????? ??? ??????? Professional 2005 Visual Studio ?? Service Pack 1 (?? ????? ????).

??????? ????

??? ????? ???????? ??????? ?? ????? ?????? SR1 ??. ??? ?? ?????? ??? ??? ???????? ???? ??????? ?????????? ???.
  • ????? ????? ???????? ????????

    ????? ??? ???? ????? ?????? ??? ???????? ???????? ?? ????? ?????? ?????? ???????? ????? ????? ?????? ??????? ?? ?? ???? ?????? ??? ??? ????? ????? ?????? (.dbmeta). ???? ??? ????? ?? ??? ??????? ???? ????? ???????? ???????? ??? ????? ????? ??????.
  • ??? ????? ??? ??? ??????? ??? SQL Server

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

    ??? ????? ???? ??????? ??? ????? ????? ????????. ????? ??? ?????? ??????? ?????? ????????? setvar ????????? ?? ??????? ?????? ?????.
???????? ??? ???? ????? ????? ?????? SR1 ?? ????? ???? ???? ???? ????? ?? Microsoft SQL Server 2005. ??????, ?? ???? ????? ????? ?????? Service Pack 2 (SP2). ???? ????? ?????? SR1 ?? ????? ???? ??????? Windows Vista.

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

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

  • Microsoft Windows 2000 Professional Service Pack 4 (SP4)
  • Microsoft Windows 2000 Server SP4
  • ???? ??????? Microsoft Windows 2000 SP4 ???? ?????
  • Microsoft Windows 2000 Datacenter Server SP4
  • Microsoft Windows XP Professional x 64 Edition (WOW)
  • Microsoft Windows XP Professional ?????? ????? ?????? Service Pack 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 ??????
  • Microsoft Windows Server 2003 Standard Edition Service Pack 1 (SP1)
  • Microsoft Windows Server 2003 SP1 Edition ???????
  • Microsoft Windows Server 2003 SP1 ??????? Datacenter
  • Microsoft Windows Server 2003 SP1 Edition ???
  • Microsoft Windows Server 2003 ?????? x 64 Edition SP1 (WOW)
  • Microsoft Windows Server 2003 ??????? x 64 Edition SP1 (WOW)
  • Microsoft Windows Server 2003 Datacenter x 64 Edition SP1 (WOW)
  • Microsoft Windows Server 2003 R2 Standard Edition
  • Microsoft Windows Server 2003 R2 ?????? x 64 Edition (WOW)
  • Microsoft Windows Server 2003 R2 Enterprise Edition
  • Microsoft Windows Server 2003 R2 Enterprise x 64 Edition (WOW)
  • Microsoft Windows Server 2003 R2 Datacenter Edition
  • Microsoft Windows Server 2003 R2 Datacenter x 64 Edition (WOW)
  • Windows Vista
???????? ??? ?????? Visual Studio 2005 ??? Intel Itanium (IA-64).

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

????? ??????? ?? ??????? ?????? ?? ??????? ???? Microsoft Visual Studio 2005 ???? Edition ??????? "????? ????????". ?????? Visual Studio 2005 ???? Edition ??????? ????? ???? ???????:
  • 2.0 ???? ???? ?? ????? ????
  • 512 ???? ???? ?? ????? RAM ?? ???? (? ???????? (GB) ?? ???? ??????)
  • ? ???????? ?? ??????? ???????? ??? ????? ??????
  • ????? DVD
  • ??? 1024 × 768 ?? ??? ???? ????? 256 ?????
  • ???? ?????? ?????? Microsoft ?? ???? ????? ??????
  • ???? Microsoft SQL Server 2005 (??????? ?????? ?? Enterprise Edition, Standard Edition ? Express Edition ?? ????? ???????)

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

???

???? ????? ?? ??????? ???? ??????
?? ????? ??????? ???????? ??????? ?? ??? ????? ?????? ?????? ??????:
  • ???? ?? ???? ? ALTER TABLE [WITH {?????? | NOCHECK}] {?????? | NOCHECK} CONSTRAINT
  • ???????? ???????? ? ALTER TABLE [WITH {?????? | NOCHECK}] {?????? | NOCHECK} CONSTRAINT
  • ?????? DML ? ALTER TABLE {????? | ?????} TriggerName ???????
  • ?????? DML ? "????? ??????" {[????.]TriggerName ON ObjectName
  • ?????? ????? ???????? ? "????? ??????" {[????.]????? ?????? ON TriggerName
  • ???? Server ???????? ? "????? ??????" {[????.]TriggerName ?? ???? ALL
  • ????? ? ALTER TABLE {????? | ?????} ?????? ALL
  • ????? ? ALTER INDEX ?????
  • ????? ???? ?????? ? TableName ON INDEX FULLTEXT ALTER {????? | ?????}
  • ????? ???????? ? ObjectName ????? ?????? ALTER WITH ?????? = {ON | ?????}
??? ??? ???????? ??? ???? ????? ??? ??????? ?? ?????? ?? ???????? ??? post-deployment. ????? ?? ????????? ??? ??????? ?????? post-deployment ???? ????? ??????.
??????? ??? ??????? ???????? ?? ?????? JOIN
?? ????? ????? ?????? SQL ???????? ???? ????? ?????? JOIN ??? ??? SQL Server ???? ??? ??????? ?????. ??? ???? ??????? ????? ????? ????? ????? ????? ???????:
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 SELECT SELECT FROM Table3 ?? T_T3 ? ????? ?????????.

??? ??? ??????? ???? ???? ????? ??????. ??? ???? ??????? ????? ??????? ???????? ??????? ???????? ?????? ??????:
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
?? ????? Visual Studio 2005 ???? Edition ??????? ????? ????? ????? 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 * INTO ? ????? ???? ????
?? ????? ????? ?????? SQL ???????? ???? ????? ??? * ????? ????? ???? ???? ??? ??? ?? 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;
??? ????? ?? ? ?? ???? ????????? ???????:
????? TSD3028 98: ???????? ??????? ?????? ?? ????? ????? ????????: [Variable|Column] dbo. # up.value. ?? ???? ????? ????? ???????? ?? ??? ??????? ??? ????? dbo.testtemp [?????].

????? TSD3028 99: ???????? ??????? ?????? ?? ????? ????? ????????: [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;
??? ????? ??????? ?? ???? T-SQL ?? ??????? ???????? ?? ??????? ???? Visual Studio ??????? "????? ????????" ??? Windows 2000 ??????? ?? ??? ????? ???? ??? "???????" ? ??? "???????? ????". ??? ????? ??????? ?? ?? ?? ???? ??? ?????? ????????? ???? ????. ??? ??? ???????? ???? ??????? ???????:
  1. ?? ??????? ?????? ???? ??? ??????.
  2. ?? ???? ?????? "??????" ? ?? ?????? ???? ???? ?? ???? ??? ?????? ????????.
  3. ?? ?????? ????? ????????? ?? ????? ?????? ? ???? ??? ??? ????? ???? T-SQL.
  4. ????? ?????? ?? (???? ????? ?????? ???? ??? ??? ????) ?? ?????? ??? ?? ????? ?????? ?????????.

    ??? ???? ??? ??? "???????" ? ??? "???????? ??????" ???? ????.

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

?????? ?????? ??? ???? ?? "?????? ????????"
?????? ?????? ???????? ?????? ???? (.) ?????? ????? ??????? ???? ?? ??? ???? ?? ??? ??????? ??? ????? ???? ?????? ??? ???? ???? ?????? ??? ????? (?). ??????? ????? ????? ???????? ?????? ??? ??????? ????? ? ???? ??????? ??????? ???????.

?? ???? ?? ?? ???? ???? ??????? ????.
????? ??? ????? filegroups ???????? ???????? "?????? ????"
?? ???? ??? ??? ?????? ????? ?????????? ??? ????? ????. ?? ????? ????? ??? ??? ?????? ????? ????? ???????? ????? ?? "?????? ????" ??? ??? ?????? ????? SETVAR ?? ?????? ?????? ?? ??? ???. ???? ??? ??????? ????? ??? "???? ??????" ?? ???? ?????? ??????? ??? ?????? ???? ??? ??????? ?? ????? ??????? ??????? ????? ??????? ????? ????????.

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

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

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

???????

???? ???????: 936612 - ????? ??? ??????: 26/???/1428 - ??????: 1.5
????? ???
  • Microsoft Visual Studio 2005 Team Edition for Database Professionals
????? ??????: 
kbmt kbtshoot kbinfo KB936612 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????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