Results 1 to 2 of 2

Thread: exec stored proc question

  1. 12-04-2000, 01:45 PM #1
    Rick O Guest

    exec stored proc question


    I am working on a project to re-code SQL Anywhere to T-SQL (SQL Server 2000) and am encountering many instances where the original code contained a SELECT statement that calls a stored procedure. T-SQL does not allow calling a procedure from a SELECT statement as far as I can see. Does anyone have any good ideas on working around this??

    Thanks

    Reply With Quote Reply With Quote
  2. 12-04-2000, 02:43 PM #2
    Ray Miao Guest

    exec stored proc question (reply)

    You can use user defined function in sql2k.


    ------------
    Rick O at 12/4/00 1:45:01 PM


    I am working on a project to re-code SQL Anywhere to T-SQL (SQL Server 2000) and am encountering many instances where the original code contained a SELECT statement that calls a stored procedure. T-SQL does not allow calling a procedure from a SELECT statement as far as I can see. Does anyone have any good ideas on working around this??

    Thanks

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules