User Profile

Collapse

Profile Sidebar

Collapse
pavelcc
pavelcc
Last Activity: Jun 4 '10, 04:43 PM
Joined: Jun 2 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pavelcc
    replied to How to insert data into table after validation
    in SQL Server
    I found the solved it:
    Code:
    DECLARE 
	@NAME VARCHAR(150), 
	@PNAME VARCHAR(150), 
	@AM VARCHAR(150), 
	@DIVISION VARCHAR(150), 
	@B_ADDRESS VARCHAR(150), 
	@AE VARCHAR(150), 
	@SUGAR_ID VARCHAR(150), 
	@OOID_C VARCHAR(150)

SELECT @SUGAR_ID =  ID FROM DEVSUGARCRM.DBO.ACCOUNTS				-- GETTING ID AN @SUGAR_ID 
IF EXISTS (SELECT * FROM ADVERTISER WHERE @SUGAR_ID = SUGAR_ID)  -- EXISTS
    ...
    See more | Go to post
    Last edited by Niheel; Jun 4 '10, 08:40 AM. Reason: added code tags, please use code tags to display code

      Leave a comment:

    • pavelcc
      started a topic How to insert data into table after validation
      in SQL Server

      How to insert data into table after validation

      I need to insert data into a table after validating that the data doesn't already exist on the table.

      In addition to that I need to update data if there are any changes.

      I got the insert part as:

      Code:
      DECLARE 
@SUGAR_ID VARCHAR (150)	
SELECT @SUGAR_ID =  ID FROM DEVSUGARCRM.DBO.ACCOUNTS --@SUGAR_ID 
	IF NOT EXISTS (SELECT * FROM ADVERTISER WHERE SUGAR_ID = @SUGAR_ID)  --NOT EXISTS
      ...
      See more | Go to post
      Last edited by Niheel; Jun 2 '10, 07:12 PM. Reason: Please proviide all your question details in one post in the future.
      No activity results to display
      Show More
      Working...