TSQL-Syntax-Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hallo NG,ich bastele gerade eine tsql prozedur, wo ich u.a. einen Cursor
dynamisch aufbaue.Ich benutze dazu folgendes statement:

SET @sqlm = 'Declare csr_slave CURSOR FOR SELECT Count(table_name) FROM
information_schema.views WHERE table_name = ''' + @vw_name + ''''
Exec(@sqlm)..

welches auch korrekt folgenden String produziert:Declare csr_slave CURSOR FOR
SELECT Count(table_name) FROM information_schema.views WHERE table_name =
'CONSTRAINT_TABLE_USAGE'

Im Query analyser funktioniert der SQL-Aufruf auch einwandfrei, nur beim
Aufruf der SP kommt nach der Declare-Anweisung die Fehlermeldung:Zeile 3:
Falsche Syntax in der Nähe von '='.Wer kann sich einen Reim darauf
machen?

Gruss, Helmut
.

Relevant Pages

  • KeyEvent consume() not working on JTextField, what am I done wrong?
    ... the characters while moving the cursor. ... 2007/100 13:12:34 is the time string. ... public static final int YEAR_1 = 0; ... public void nextPosition(int intKeyCode, int intCharPos) { ...
    (comp.lang.java.programmer)
  • KeyEvent consume() not working on JTextField, what am I doing wrong?
    ... the characters while moving the cursor. ... 2007/100 13:12:34 is the time string. ... public static final int YEAR_1 = 0; ... public void nextPosition(int intKeyCode, int intCharPos) { ...
    (comp.lang.java.gui)
  • KeyEvent consume() not working on JTextField, what am I doing wrong?
    ... the characters while moving the cursor. ... 2007/100 13:12:34 is the time string. ... public static final int YEAR_1 = 0; ... public void nextPosition(int intKeyCode, int intCharPos) { ...
    (comp.lang.java.help)
  • make a textbox Autoexpand (aka Autocomplete)
    ... 'As far as I can tell it makes a textbox behave just like a combo box ... 'Private Sub txt_box_KeyPress ... Public Function expand(strBox As String, strTable As String, strField ... Dim cursor As Integer ...
    (microsoft.public.access.formscoding)
  • Re: wide screen text mode?
    ... on the stack and perform a far call to the routine. ... update yx with cursor address/not 0008/0000 ... PUSH BP;save BP ... TEST AL,02H;00/01 CHAR OR 02/03 STRING? ...
    (comp.os.msdos.programmer)