Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
Begin /* Call procedure to Update a record into the Entity Table */ If @tiEntityType = 2 /*Individual */ Begin /* Ensure that fields not provided on the Contact page do not wipe out existing data. For example, if Address3 is not provided on the "Add Contact to Vehicle page" BUT it DOES have a value in the Entity table, then this update would wipe out the Address3 value!*/ select e.vchAddress2, e.vchAddress3, e.vchFaxNumber, e.vchSpecialNote1 from dbo.Entity e where e.iEntityId = @iEntityid; Exec @iReturnValue = DSuEntity @iSiteId, @iEntityid, /*iEntityId will get set on Insert from Identity Column' */ @tiEntityType, /*Company = 1 and Individual = 2*/ @vchCompanyName, @vchSalutation, @chGender, @vchFirstName, @vchMiddleName, @vchLastName, @vchAddress1, e.vchAddress2, /* from the select statement above */ e.vchAddress3, /* from the select statement above */ @vchCity, ... ...
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.