Anil Singh | Code-sample.com

The below query sql server backup single “Test” databases DECLARE @DBNAME VARCHAR ( 50 ) -- DATABASE NAME DECLARE @ PATH VARCHAR ( 256 ) -- BACKUP FILES PATH DECLARE @FILENAME VARCHAR ( 256 ) -- FILENAME FOR BACKUP DECLARE @FILEDATE VARCHAR ( 20 ) -- USED FOR FILE NAME -- DATABASE BACKUP FILE DIRECTORY PATH AND FOLDER SET @PATH = 'E:\Shared\DatabaseBackup\BACKUP-FILE-DB\' --FILE NAME WITH DATE AND TIME SELECT @FILEDATE = CONVERT ( VARCHAR ( 20 ),GETDATE(), 112 ) + '_' + REPLACE( CONVERT ( VARCHAR ( 20 ),GETDATE(), 108 ), ':' , '' ) DECLARE DB_CURSOR CURSOR FOR SELECT NAME FROM MASTER . DBO .SYSDATABASES WHERE NAME IN ( 'Test' ) -- INCLUDE THESE DATABASES --WHERE NAME IN ('DATABASE-1','DATABASE-2','DATABASE-3','DATABASE-4','DATABASE-N') -- INCLUDE THESE DATABASES OPEN DB_CURSOR FETCH NEXT FROM DB_CURSOR INTO @DBNAME WHILE @@FETCH_STATUS = 0 BE...

The SQL SUBSTRING( ) function is used to extract a sub string from a given string's  start  to end position. Syntax: //GET SQL SUBSTRING SELECT SUBSTRING ( 'C2495E17-2B72-4FA0-969D-BE8388E4BDBC' , 5 , 19 ) as SUBS_TRING_RESULT OR //GET SQL SUBSTRING SELECT TOP 2  UPPER ( SUBSTRING ( NAME , 1 , 1 )) + LOWER ( SUBSTRING ( NAME , 2 , 255 ))               AS 'CUSTOMER_NAME' FROM CUSTOMER

I am going to share the code sample for how to   checkdependencies of table in Sql server . The example as give below. Method 1 :   using sp_depends to get table dependencies SQL Server SP_DEPENDS 'DBO.USAGE' Method 2 :   using information_schema . routines to get table dependencies SQL  Server SELECT *     FROM INFORMATION_SCHEMA . ROUTINES IS_RO     WHERE CHARINDEX ( 'DBO.USAGE' , IS_RO . ROUTINE_NAME ) > 0 Method 3   : using SYSCOMMENTS SELECT NAME FROM SYSCOMMENTS SYST     JOIN SYSOBJECTS SYSTOBJ ON SYST . ID = SYSTOBJ . ID     WHERE TEXT LIKE '%CALLTYPEID%'