Strong Number:- A number is called strong number If the sum of factorial of the digits in any number is
Continue readingAuthor:
Delete Duplicate Rows in MySQL
Duplicate records in the database are old age problem that almost every organization has to deal with that.Duplicate may appear
Continue readingHow To Delete Duplicate Rows in SQL Server
Duplicate records in the database are old age problem that almost every organization has to deal with that.Duplicate may appear
Continue readingPerformance Tuning :- How to identify blocking And Lead blocker in SQL Server
During normal processing in a database, it is blocked. Blocking is “by design” because your database is on ACID. In
Continue readingDifferent Types Of Cursor In java
If we want to get objects one by one from the collection we should go for cursor. There are 3
Continue readingJava Program to Find Equilibrium Index of an Array
The following code snippet find Equilibrium Index of an Array in java. class IndexEquilibrium { int findIndexEquilibrium(int A[], int n)
Continue readingJava – GMT to IST Conversion
The following code snippet convert GMT to IST in java. import java.util.*; import java.io.*; import java.text.*; public class GmtToIstConversion
Continue readingJAVA – Convert GMT to EST
The following code snippet convert GMT to EST in java. import java.util.*; import java.io.*; import java.text.*; public class GmtToEstConversion {
Continue readingSQL Server – Cannot detach a suspect or recovery pending database
I tried to detach the database in one of our SQL servers, but received the following error:- Cannot detach
Continue readingGallon to liter conversion in java
To convert Gallon to liter we are using a formula “liter = gallon * 3.7854118“. Java Program to covert Gallon to
Continue reading