All about Asp.net, C#, SQL Server, Java Script, jQuery, Angular, React, Node JS, MSSQL

First of all create a function and then after use this function when you need just number from string. CREATE FUNCTION [dbo].[RemoveAlphaCharacters]     (       @string2number VARCHAR(200)     ) RETURNS VARCHAR(200) AS     BEGIN         DECLARE @c INT         DECLARE @num VARCHAR(200)         SET @num = ''         DECLARE @txtCurrent CHAR(1)         SET @c = 1         WHILE @c <= LEN(@string2number)             BEGIN                 SET @txtCurrent = SUBSTRING(@string2number, @c, 1)                 IF ASCII(@txtCurrent) BETWEEN 48 AND 57                     SET @num = @num + @txtCurrent                 SET @c = @c + 1             END         RETURN @num     END SELECT dbo.RemoveAlphaCharacters('nikhil1711sangani') OUTPUT :  1711

SELECT ltrim(right(convert(varchar(25), getdate(), 100), 7))

Using this SQL query I will find that Particular column is exist in table or not. just pass table name and pass column name that we want to check. IF COL_LENGTH(‘Table name’,’Column name’) IS NOT NULL BEGIN PRINT ‘Your Column Exists’ END ELSE BEGIN PRINT ‘Your Column not Exists’ END

In this Post I will write a SQL Query for get last backup date of database. SELECT sdb.Name AS DatabaseName, ISNULL(CONVERT(VARCHAR(70),MAX(bus.backup_finish_date)),’-‘) AS LastBackUpTime FROM sys.sysdatabases sdb LEFT OUTER JOIN msdb.dbo.backupset bus ON bus.database_name = sdb.name GROUP BY sdb.Name