Eclpse calls stored procedures

eclipse calls stored procedures

defines an order system based on sqlserver database. I want to call a stored procedure to automatically give a self-increasing order number in each order processing, but I don"t know how to write

in eclipse.

related codes

/ / Please paste the code text below (do not replace the code with pictures)
-- create a table SEQ_SERIAL_NO
create table SEQ_SERIAL_NO (

)
seqid int identity(1,1) primary key, -- ID
seqval varchar(1) -- Sequence

)

-- create a stored procedure that gets the latest sequence value from the SEQ_SERIAL_ no table
create procedure SP_GetSeqVal
as
begin

-- Sequence
declare @NewSeqValue int
-- 
set NOCOUNT ON
-- SEQ_SERIAL_NO
insert into SEQ_SERIAL_NO(seqval) values ("a")
-- SequenceSeqT_0101001
set @NewSeqValue = scope_identity()
-- Sequence<999999999():"YYYY" +5Sequence(201019988)SQLServer
-- set @NewSeqValue = Convert(char(4),Getdate(),112) + right("00000"+CAST(scope_identity() AS varchar(5)),5)
-- Print @NewSeqVal "201019988" Sequence

-- SeqT_0101001()
delete from SEQ_SERIAL_NO WITH (READPAST)
-- Sequence
return @NewSeqValue

end

-- use Sequence
Declare @ NewSeqVal int
Exec @ NewSeqVal = P_GetSeqVal
Print @ NewSeqVal
Print Convert (char (8), Getdate (), 112)

how can statements called in sqlserver be implemented in eclipse? Is how to get the final print Convert.

Jul.28,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1c1e871-333ef.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1c1e871-333ef.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?