PL/SQL Program for Prime Number Prime Number:-Prime number is a number if it is divisible by 1 or itself. For
Continue readingAuthor:
PL/SQL Program to Swap two Numbers
PL/SQL Program to Swap two Numbers :- We are going to write a PL/SQL program to swap variable with or
Continue readingPython Program To Display Powers of 2
In this blog post,we are going to learn how to display powers of the 2 using Python anonymous function. Python
Continue readingPython Program to Find HCF or GCD
In this blog post , we are going to learn how to find the H.C.F of two numbers using function
Continue readingPython Program to Swap Two Variables
In this blog post,we are going to learn how to swap two variables by using a temporary variable and swap
Continue readingHow to check connections for a particular Database in SQL Server
Below Script provides the connections details for a particular Database in SQL Server. select spid,loginame,blocked,waittype,cpu,hostname,DB_NAME(dbid) AS DB_NAME ,status from sys.sysprocesses
Continue readingSQL SERVER:- How To get List of SQL Server Jobs and Their Owners
With the help of below script we are able to get the SQL Server jobs and respective owner details in
Continue readingFind Percentage Completion Of Currently Running Processes Or Job In SQL Server
In SQL Server Some tasks that are running take a long time to run and it is sometimes difficult to
Continue readingSQL Server :- Get Statistics Of All Objects Of A Database In SQL Server
With the help of Below Query you are able to find the details about Statistics of a database in SQL
Continue readingHow to get when your SQL server was last restarted?
Through below script you are able to find SQL Server Last Restart Time:- SELECT sqlserver_start_time from sys.dm_os_sys_info;
Continue reading