How to declare a variable in MS SQL and use it in the same Stored Procedure

Posted by Nicklas on Stack Overflow See other posts from Stack Overflow or by Nicklas
Published on 2010-05-08T08:10:29Z Indexed on 2010/05/08 8:18 UTC
Read the original article Hit count: 326

Filed under:

declare

|

variable

|

stored

|

procedure

Im trying to get the Value from BrandID in one tabel and add it to another tabel. But I can't get it to work. Anybody know how to do it right?

CREATE PROCEDURE AddBrand AS

DECLARE @BrandName nvarchar(50), @CategoryID int, @BrandID int

SELECT @BrandID = BrandID FROM tblBrand WHERE BrandName = @BrandName)

INSERT INTO tblBrandinCategory (CategoryID, BrandID) VALUES (@CategoryID, @BrandID)

RETURN

© Stack Overflow or respective owner

Related posts about declare

"Développer pour l'iPhone, c'est servir un propriétaire terrien", déclare l'inventeur du XML : posit

as seen on Developper.com - Search for 'Developper.com'
Mise à jour du 16/02/10 "Ceux qui créent des applications pour l'iPhone servent la volonté d'un propriétaire terrien" Déclare le créateur du XML : y-a-t-il une fronde des développeurs contre Apple ? Pour ne pas travailler pour Oracle, le co-inventeur du XML vient de quitter Sun… >>> More
forward declare typedef'd struct

as seen on Stack Overflow - Search for 'Stack Overflow'
I can't figure out how to forward declare a windows struct. The definition is typedef struct _CONTEXT { .... } CONTEXT, *PCONTEXT I really don't want to pull into this header, as it gets included everywhere. I've tried struct CONTEXT and struct _CONTEXT with no luck (redefinition of basic… >>> More
How to declare more than one header on PHP

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to send my users to different pages based on user action. So I made multiple functions at the top of the page like so: <?php function one() { header("location: pagea.php"); } function two() { header("location: pageb.php"); } function three() { header("location: pagec.php"); } … >>> More
c declaring variables in blocks

as seen on Stack Overflow - Search for 'Stack Overflow'
I know that in C++, I can declare variables pretty much everywhere. I recall once reading that in C, variables must be declared at the top of a function i.e. the following is invalid: void foo() { int good; if (...) { int bad; } } In the above code, is the declaraing of the bad varaible… >>> More
c declaraing varibles in blocks

as seen on Stack Overflow - Search for 'Stack Overflow'
I know that in C++, I can declare variables pretty much everywhere. I recall once reading that in C, variables must be declared at the top of a function i.e. the following is invalid: void foo() { int good; if (...) { int bad; } } In the above code, is the declaraing of the bad varaible… >>> More

Related posts about variable

PHP variable in variable

as seen on Stack Overflow - Search for 'Stack Overflow'
I have set an array in my config file that I use global in my functions. This works fine, but now I want to pass the name of this array as a @param in my function. // in config file: $album_type_arr = array("appartamento", "villa"); global $album_type_arr; // pull in from db_config echo $album_type_arr[0]; function… >>> More
JavaScript variable to ColdFusion variable

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a tricky one. By means of a <cfoutput query="…"> I list some records in the page from a SQL Server database. By the end of each line viewing I try to add this in to a record in a MySQL database. As you see is simple, because I can use the exact variables from the output query in to… >>> More
Swapping two variable value without using 3rd variable

as seen on Stack Overflow - Search for 'Stack Overflow'
One of the very tricky question asked in an interview... we need to swap the values of two variables like a=10 and b=15 Generaly to swap two variables values, we need 3rd variable like.. temp=a a=b b=temp Now the requirement is, swaping value of two variable values without using 3rd variable… >>> More
PHP - Variable inside variable?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys... $bookA = "123"; $crack = "A"; I want to do something similar to this: echo $book$crack; Such that the output is 123. What is the correct syntax for the echo command? Thanks. >>> More
variable inside a variable in a php class

as seen on Stack Overflow - Search for 'Stack Overflow'
is it possible to copy a variable like this this? class Colours { var $var = "one"; var $var2 = array('something', $var); } >>> More