Menu

#85 Print command not recognized

3.1
open-works-for-me
wmmihaa
5
2005-09-29
2005-09-21
freh
No

Try this:
Table should have an identity column.
Insert into <Table> (Fields..)
Select Fields... From <Table> where Id = ?

Print @@Identity

->No output for print!!

Discussion

  • Lindsey Lewis

    Lindsey Lewis - 2005-09-29
    • status: open --> open-works-for-me
     
  • Lindsey Lewis

    Lindsey Lewis - 2005-09-29

    Logged In: YES
    user_id=1065916

    I believe that this has been fixed on the latest 4.0 version. I
    ran a test as above and had no problems in getting the Print
    @@Identity to return values in the Message Tab of the output
    window.

    See output below, the '2' is the result of the print @@Identity
    command:

    No foreign keys reference this table.
    No views with schema binding reference this table.
    Table 'test'. Scan count 0, logical reads 4, physical reads 0,
    read-ahead reads 0.
    Table 'Admin'. Scan count 1, logical reads 2, physical reads
    0, read-ahead reads 0.
    2

     

Log in to post a comment.