need a sp for table update

Question

Post reply

need a sp for table update

Arti Dev.06

Grasshopper

Points: 19
More actions
May 6, 2011 at 1:08 pm

#239115

hey can neone giv me a simple stored procedure syntax where i can change a name for particular id
m all new in this, on d way to learn ASP.net programming.....plz help....

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Here's a very simple example.

CREATE PROCEDURE update_customername

(

@customer_id int,

@customer_name varchar(25)

)

AS

BEGIN

SET NOCOUNT ON;

UPDATE customers

SET customer_name = @customer_name

WHERE

customer_id = @customer_id

END

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Arti Dev.06 Grasshopper Points: 19 More actions · Answer 2

ohhhh, worked:w00t:...thnx a tonnnn Jack...!!!

i'll b back wid new simple question, though tough for me...

Jeff Moden SSC Guru Points: 1004642 More actions · Answer 3

Arti Dev.06 (5/6/2011)
ohhhh, worked:w00t:...thnx a tonnnn Jack...!!!
i'll b back wid new simple question, though tough for me...

Since you're new to SQL, my recommendation is the you look at an online tutorial such as w3schools.com to learn the basics and then learn how to use "Books Online" which is the free help system that comes with SQL Server.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Arti Dev.06 Grasshopper Points: 19 More actions · Answer 4

Thanks Jeff..........

w3schools.com is a grt help.....

Jeff Moden SSC Guru Points: 1004642 More actions · Answer 5

You bet. Just remember that W3Schools teaches "ANSI" SQL which is fairly rudamentary compared to T-SQL which is found in SQL Server. It IS a decent place to start, though.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)