SQL Server queries

All backup history is stored in msdb database. Following stored procedure can be execute with parameter, here we clean history before 30 days.     USE   msdb GO DECLARE   @BeforeDays   DATETIME SET   @BeforeDays   =   CONVERT ( VARCHAR ( 10 ),   DATEADD ( dd , - 30 , GETDATE ()),   101 ) EXEC   sp_delete_backuphistory   @BeforeDays GO

Using This Query you can remove special characters from string in sql DECLARE @str VARCHAR ( 400 )     DECLARE @expres  VARCHAR ( 50 ) = '%[~,@,#,$,%,&,*,(,),.,!]%'       SET @str = '(remove) ~special~ *characters. from string in sql!'       WHILE PATINDEX ( @expres , @str ) > 0           SET @str = Replace ( REPLACE ( @str , SUBSTRING ( @str , PATINDEX ( @expres , @str ), 1 ), '' ), '-' , ' ' )       SELECT @str