Database

munklefish wrote:

SELECT @key = addMaster_Key FROM tbl_AddressBookMaster WHERE addMaster_UserId = @tmp_custID AND addMaster_Title = 'Default' IF @key IS null

set @now = getdate()

IF @key IS null
begin
    INSERT INTO tbl_AddressBookMaster ([addMaster_UserId], [addMaster_Title], [addMaster_Description], [addMAster_NoRecipients])
    VALUES (@tmp_custID, 'Default', @tmp_Description, 0)
    SELECT @key = SCOPE_IDENTITY()
end

INSERT INTO tbl_AddressBookAddresses ([adds_ABMId], [adds_Email], [adds_RecipientForename], [adds_RecipientSurname])
VALUES (@key, @tmp_Email, @tmp_Forename, @tmp_Surname)

IF @key IS null
       --address book doesnt exist just so create default
       BEGIN
       INSERT INTO tbl_AddressBookMaster ([addMaster_UserId], [addMaster_Title], [addMaster_Description], [addMAster_NoRecipients])
       VALUES (@tmp_custID, 'Default', @tmp_Description, 0)
       SELECT @newSignUpID = SCOPE_IDENTITY()
       
      --add addresses to second table
       INSERT INTO tbl_AddressBookAddresses ([adds_ABMId], [adds_Email], [adds_RecipientForename], [adds_RecipientSurname])
       VALUES (@newSignUpID, @tmp_Email, @tmp_Forename, @tmp_Surname)

      END

       ELSE
       --default already exists
       BEGIN
       --add addresses to second table
       INSERT INTO tbl_AddressBookAddresses ([adds_ABMId], [adds_Email], [adds_RecipientForename], [adds_RecipientSurname])
       VALUES (@key, @tmp_Email, @tmp_Forename, @tmp_Surname)

        END

GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [test\me].[GIStoCRW]

AS
BEGIN

	SET NOCOUNT ON;

EXEC sp_addlinkedserver 
   @server = 'CRW',
   @provider_name = 'SQLNCLI',
   @datasrrc = 'TheServerName',
   @catalog = 'TheTablename'

EXEC sp_addlinkedsrvlogin CRW, FALSE, 'My Login’, NULL

update CRW.GEO_UDF set WATERDISTRICT = 'TEST' where SITE_APN = '123'

END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [domain\me].[TestUpdate]

AS
BEGIN

update gis.crw_gis_data set block = 'test' where id = '123'

END

GO

Sharma Dinesh Kumar wrote:

i want encrypt data inside the table of database .