Welcome to Sign in | Help

Re: DROP constrangere (SQL 2000 si SQL 2005)

  •  08-27-2008, 3:56 PM

    Re: DROP constrangere (SQL 2000 si SQL 2005)

    nu merge.... am incercat in cazul meu si nimic....

    DECLARE @T TABLE (I INT IDENTITY(1,1) PRIMARY KEY, OrderID INT, SqlStatement NVARCHAR(4000));

    INSERT INTO @T(SqlStatement,OrderID)

    SELECT

    'update sys.sysusers set uid=546 where uid=318'

    AS SqlStatement,

    2 AS OrderID

     

    DECLARE @v NVARCHAR(4000);

    SELECT @v=SqlStatement FROM @T WHERE I=1;

    EXECUTE @v;

    PRINT @v;

     

    imi da eroare si nu pot actualiza sys.sysusers

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems