Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE [dbo].[crud_tst-mysql_fastCreate]
- @filters CRUDFilterParameter READONLY,
- @text nvarchar(256),
- @username nvarchar(32)
- AS
- BEGIN
- -- создание сущности в таблице по 1 полю @text
- declare @id int
- select @id = id from openquery(MYSQL1, 'select id from RemotelyCreatedTable order by id desc limit 1')
- set @id = isnull(@id, 0) + 1
- insert into openquery(MYSQL1, 'select * from RemotelyCreatedTable')
- values (@id, @text, @text)
- select 'Элемент создан' Msg, 1 Result
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement