Non cluster index , SQL Server Table
CREATE NONCLUSTERED INDEX IDX_tblppd_data_P03
ON tblppd_data ( PPD_LT, PPD_Period, PPD_Period_Source
);
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/create-nonclustered-indexes?view=sql-server-ver15
SELECT OBJECT_NAME(OBJECT_ID) AS ObjectName,
last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'mfdb')
AND OBJECT_ID=OBJECT_ID('tbl_verGLData_DD')
create table #name ( id int identity(1,1), name varchar(10))
drop table #tem1
INSERT INTO #name (name)
--OUTPUT Inserted.ID
select '1111' union select '2222'
SELECT SCOPE_IDENTITY() aaa into #tem1
select * from #tem1
https://www.oracle.com/technetwork/topics/parameterized-url-red-paper-128781.pdf
For Batch number:-
https://jdepd.xxxxx.com/jde/HostedE1Servlet?OID=P0011_W0011A&FormDSTmpl=|2|&FormDSData=|123456|
