Welcome to Sign in | Help

Tabela cu "." in nume

  •  11-30-2010, 12:21 PM

    Tabela cu "." in nume

    Salut! Am o baza de date care contine o tabela "." in nume. Din cauza aceasta nu pot sa rulez scriptul urmator:

    DECLARE CRS_TABLENAME CURSOR FOR
    SELECT [NAME] FROM SYSOBJECTS WHERE XTYPE = 'U'
    OPEN CRS_TABLENAME
    FETCH NEXT FROM CRS_TABLENAME INTO @TABLE_NAME

    while @@fetch_status = 0
    begin
    DBCC DBREINDEX(@TABLE_NAME,'',0)
    FETCH NEXT FROM CRS_TABLENAME INTO @TABLE_NAME
    end

    Stiu ca trebuie sa pun delimitator "[]" dar imi da eroare daca pun. Multumesc pentru ajutor!
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems