update query in stored proc

Question

0.00/5 (No votes)

See more:

Hi every one,

I have stored procedure created

SQL

USE [WAAS]
GO
/****** Object:  StoredProcedure [WAAS].[ADMIN_ADD_TEMPLATES]    Script Date: 11/30/2012 12:00:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [ADD_RECORDS]
(	
    
	@GrpId bigint,
	@DispName varchar(50),
	@FullName varchar(50),
	@LastValue varchar(50),
	@ActiveDirName varchar(50),
        @ClassVal int,
	@UID varchar(15)
		
)
As
BEGIN
        
                INSERT INTO table(GrpId,
				DispName,
				FullName,
				LastValue,
				ActiveDirName,
				ClassVal,
				CreatedBy,
				CreatedDt)
	VALUES(@LobGrpId,
			@DispName,
			@FullName,
			@LastValue,
		        @ActiveDirName,
			@ClassVal,
			@UID,			
			GETDATE())
END

This is my stored procedure created to add records into database.

Now I would like to update the details by writing the update query to update the values in the same stored procedure.

values needs to be updated:

LobGrpId
FullName
ActiveDirName
ClassificationVal
UID
updatedby
updatedtime

Can anyone help me?

Thanks in advance

Posted 29-Nov-12 23:38pm

msweety

Updated 29-Nov-12 23:41pm

André Kraak

v2

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

damodara naidu betha · Answer 1 · 2012-11-30T00:27:00

Hi..

Before INSERT query you need to check whether there is a record with same @LobGroupId in your table. Try the following procedure in your Stored proc..

SQL

IF EXISTS(SELECT * FROM Table Where GrpId = @LobGroupId)
BEGIN

   -- write your Update query

END

ELSE
BEGIN

   -- write your Insert query

END

Note :- Rename the parameter @GrpId bigint to @LobGrpId bigint in the parameter section of your Stored procedure..

Thank you

Krish - KP · Answer 2 · 2012-11-30T00:03:00

Solution 1

Hope

Quote:
GrpId

is unique in this table. if so, check for existence and can update or insert accordingly

Ex:

Posted 30-Nov-12 0:03am

Krish - KP

Patel Shailendra · Answer 3 · 2012-11-30T00:16:00

You can do one thing u can pass 1 as insert 2 as update 3 as delete and so on pass the value with value 1 if u want to insert 2 to update
and check in if(@check=1) then in begin and end block write insert query
and check if (@check=2)then in begin and end block write update query and so on...

__TR__ · Answer 4 · 2012-11-30T20:27:00

Solution 4

Here is an article you might find helpful
Combining Insert/Update to one Procedure[^]

Posted 30-Nov-12 20:27pm

__TR__

update query in stored proc

4 solutions

Solution 3

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0