Функции необходимы для записи данных в внешние источники данных.

INSERT

USE [access]

GO

CREATE PROCEDURE insert_colors

@key int,

@color nvarchar(50)

AS

BEGIN

INSERT INTO access.dbo.[colors] ([key], [color])

VALUES (@key, @color)

END

GO

Update

USE [access]

GO

CREATE PROCEDURE update_kart

@Счетчик int,
@KODK nvarchar(20),
@DataZ datetime,
@N_Serk nvarchar(4),
@N_Kart int,
@PRIZN nvarchar(20),
@KODKS nvarchar(20),
@vlad nchar(20),
@auto1 nchar(20),
@oplata int,
@datan date,
@datak date,
@salon nchar(10),
@procent int,
@fio nchar(100),
@pts nchar(30),
@auto nchar(100),
@color nvarchar(50),
@marka nvarchar(50),
@model nvarchar(50),
@gosnomer nvarchar(50)

AS

BEGIN

UPDATE [access].dbo.[Kart]

SET  [Счетчик] = @Счетчик, [KODK] = @KODK ,[DataZ] = @DataZ, [N_Serk] = @N_Serk, [N_Kart] = @N_Kart, [PRIZN] = @PRIZN, [KODKS] = @KODKS, [vlad] = @vlad, [auto1] = @auto1, [oplata] = @oplata, [datan] = @datan, [datak] = @datak, [salon] = @salon, [procent] = @procent, [fio] = @fio, [pts] = @pts, [auto] = @auto, [color] = @color, [marka] = @marka, [model] = @model, [gosnomer] = @gosnomer

WHERE [счетчик]=@счетчик

END

GO