RE: A SELECT statement that assigns a value to a variable must not be
From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 10/19/04
- Next message: Philippe [MS]: "Re: SET NOCOUNT ON OPTION"
- Previous message: David Ku: "Re: Design for store pocedure if return more than 1 record"
- In reply to: KritiVerma_at_hotmail.com: "A SELECT statement that assigns a value to a variable must not be"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 01:45:05 -0700
A SELECT statement may either assign variables or return results but not
both. The SELECT list of your query must include some columns that you
haven't assigned to variables.
You should avoid using cursors whenever you can. Probably you don't need a
cursor to do what you are doing. Have you conidered any alternatives?
-- David Portas SQL Server MVP --
- Next message: Philippe [MS]: "Re: SET NOCOUNT ON OPTION"
- Previous message: David Ku: "Re: Design for store pocedure if return more than 1 record"
- In reply to: KritiVerma_at_hotmail.com: "A SELECT statement that assigns a value to a variable must not be"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
