SQL 2008 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL 2008

Author

Topic

Raju75
Starting Member

3 Posts

Posted - 2008-03-18 : 14:30:21

changes in 2008 version

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2008-03-18 : 15:06:34

Are you trying to UPdate an existing Record or insert a new one?

Jim

Raju75
Starting Member

3 Posts

Posted - 2008-03-18 : 15:40:43

When ever the buisness Analyst change the data they want to get it Updated in the Backend.Please help me.Thanks in advance.

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2008-03-18 : 18:23:20

This portion of the code above does updating
UPDATE TherapeuticArea
SET TherapeuticAreadescription =@TherapeuticAreaDescription
FROM TherapeuticArea TA, iftTherapeuticArea ifta
WHERE TA.TherapeuticAreaId=ifta.TherapeuticAreaID
AND Ifta.IFTID=@iftno
And TA.TherapeuticAreaId=@TherapeuticAreaId

Your statement can be written as
UPDATE TherapeuticArea
SET TherapeuticAreadescription = 'cancer'
WHERE TherapeuticAreaId = 3

Hope that's what you're looking for

Jim

Raju75
Starting Member

3 Posts

Posted - 2008-03-18 : 23:17:50

Hi Jim,
According to my code I am inserting if the conditions dont satisfy.Actually why I have to insert I dint understand.can you please look into my Tables and if Possible can you send me an update procedure for the given requirement.Hope I am not confusing you.
Thanks in advance

Requirement:
Pass in iftno,TherapeuticAreaid(TAID) to update backend with selected TherapeuticArea(TA)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources