update table using function

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 374,181 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,409 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 983 | Replies: 1

•

Join Date: Nov 2004

Posts: 225

Reputation: sam1 is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

sam1

Offline

Posting Whiz in Training

update table using function

Mar 18th, 2008

hi,

I have a table with two columns. i want to insert into first column the values of 2nd column where it is between 7 and 10. the table is #temp as well.

so i can not use views... i need to make a function. can you guys please help me how to do it and if you could explain it would be great.

thanks

•

Join Date: Aug 2006

Location: Egypt

Posts: 743

Reputation: RamyMahrous is on a distinguished road

Rep Power: 3

Solved Threads: 53

RamyMahrous RamyMahrous is online now

Online

Master Poster

Re: update table using function

Mar 18th, 2008

View won't help and I think UDF (User Defined Function) won't help too, the best practice is to use Stored Procedure

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE procedure sam1
AS
INSERT INTO tableX(column2) VALUES (SELECT column1 FROM tableX)
Create procedure sam1
AS
Insert into tableX(column2) values (select column1 from tableX)