Transactional replication in SQL Server is a robust feature that allows you to replicate data from a primary database (publisher) to one or more secondary databases (subscribers). While this is…
Read MoreIntroduction: This SQL query is used to fetch the Holidays list for Employees like Employee number, Holiday name, Start date, End date etc… Cause of the issue: Business wants a…
Read MoreIntroduction: This SQL query is used to fetch the data of Employees Salary details (CTC)like Annual salary, Fixed CTC, Employee number, DOJ, Base element name etc .. Cause of…
Read MoreOverview: This blog talks about VPD (Virtual Private Database) in Oracle Apex, a feature that helps address security concerns by restricting access to data at the row level based on…
Read MoreEvery time a customer or client asks for a list of EBS Users and their responsibilities, the DBA team would generally execute the “Active Users” Concurrent Program from the System…
Read MoreIntroduction: Effectively managing large log and output files is crucial for maintaining optimal performance in Oracle E-Business Suite 12.2. Despite the availability of purge programs to address both database and…
Read MoreSTEP – 1 1 First download .netframework 3.5 Completed. Now the .net framework 3.5 has been installed in the windows system STEP-2 -Download software for the sqlserver -User the…
Read MoreIntroduction: This SQL query is used to fetching the data of Employees Work Schedule changes like Work Schedule id, Name etc… In this Last update date is used as…
Read MoreIntroduction: This SQL query is used to fetching the data of Employees Assignment changes like Manager change, location change etc… In this Last update date is used as a parameter…
Read More1. Overview This document talks about how to generate OTP & Integration of SMS. 2. Technologies and Tools Used The following technologies has been used to Integrating SMS & generating SMS. Ø MS SQL Server Ø DotNet & Angular 3. Use Case Assume that there is a requirement to generate OTP & Send SMS to Respective Person. 4. Architecture Following steps explains in detail, Step 1: It validates and generate OTP , It allows to generate New OTP Maximum 3 times and resend OTP Maximum 5 Times. It is not allowed Maximum of OTP. This Query for generating OTP. SELECT CAST(1000000-CEILING(RAND()*899003)+DATEPART(MS, GETDATE()) AS INT) Step 2: Generating OTP and insert OTP into table. BEGIN SET NOCOUNT ON; DECLARE @EmployeeReferralID int; DECLARE @OTP varchar(6); DECLARE @CurrentDatetimeIST datetime=(SELECT (GETDATE() as TIME ZONE ‘Eastern Standard Time’) AT TIME ZONE ‘India Standard Time’); SELECT @OTP= CAST(1000000-CEILING(RAND()*899003)+DATEPART(MS, GETDATE()) AS INT) END Step 3: Verify OTP for respective Mobile Number. BEGIN DECLARE @OTPInput varchar(6); DECLARE @OTP varchar(6); SELECT @OTP=top 1 otp from tblemployeeOTP where mobileno=@mobileno order by desc; if(@OTPInput=@OTP)…
Read More