Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
create procedure getConsumerID @outvar char(9) OUTPUT as declare @ConsumerID int begin transaction select @ConsumerID = fnPartID from tblParticipantNo if @ConsumerID is null begin set @ConsumerID = 1 insert into tblParticipantNo values(@ConsumerID) end else begin update tblParticipantNo set fnPartID=@ConsumerID + 1 end Select @ConsumerID set @outvar=@ConsumerID commit transaction
|How to export Access tables into Sybase tables using Rapid SQL Version 8.1.1?||2||1,094|
|I have a corrupted index on a table with this error Index row entry for data row id (817, 15) is missing from index page 1009 of index id 2 of table 'sysattributes' in database 'sag'. Xactid is (10215||3||316|
|SQL: Comparing 2 Addresses(String) - Identifying Match Percentage||9||116|
|Loading very large range partitioned tables in Sybase/ASE 15.7||5||115|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
6 Experts available now in Live!