Check Given Date Is Weekend Or Not In Sql

DECLARE @DT DATETIME;

SET @DT = Getdate();

SELECT CONVERT(VARCHAR(30), @DT)
       + ' : DateName -  '
       + CONVERT(VARCHAR(10), Datename(dw, @DT))
       + ' : Date In Number  -  '
       + CONVERT(VARCHAR(10), Datepart(dw, @DT)); 

Move One DataBase To New Drive

USE DatabaseName;
GO
ALTER DATABASE DatabaseName MODIFY FILE
(
NAME = DatabaseName_Mdf, FILENAME = 'd:\DatabaseName_Mdf.mdf'
)
GO

ALTER DATABASE tempdb MODIFY FILE
(
NAME = DatabaseName_Log, FILENAME = 'e:\DatabaseName_Log.ldf'
)
GO

Get Logical File Name Of Database

USE DatabaseName
GO
EXEC sp_helpfile
GO

What is the Initial Size of Temp Db ?

SELECT  NAME ,
        SIZE * 8.0 / 1024 'Current Size In MB'
FROM    tempdb.sys.database_files;

SELECT  NAME ,
        SIZE * 8.0 / 1024 'Initial Size in MB'
FROM    master.sys.sysaltfiles
WHERE   dbid = 2;  

Return Output Parameter From Stored Procedure

CREATE PROCEDURE [dbo].[USP_FindName]
      @ID INT,
      @NAME VARCHAR(30) OUTPUT
AS
BEGIN
      SET NOCOUNT ON;
     
      SELECT @NAME = NAME FROM dbo.TABLENAME
      WHERE ID = @ID
END

Disable The Windows Authentication Mode Of SQL Server

ALTER LOGIN [ADMIN\SQL2014] DISABLE
GO

Detach Multiple Database In Sql Server

USE MASTER 
DECLARE DATABASES CURSOR
FOR
    SELECT  NAME
    FROM    SYSDATABASES
    WHERE   NAME NOT IN ( 'MASTER', 'TEMPDB', 'MSDB', 'MODEL' ) 
DECLARE @DB SYSNAME 

DECLARE @SQL VARCHAR(5000) 
OPEN DATABASES 

FETCH NEXT FROM DATABASES INTO @DB 
WHILE @@FETCH_STATUS = 0
    BEGIN
        SET @SQL = 'SP_DETACH_DB ' + @DB 
        EXEC (@SQL) 
        FETCH NEXT FROM DATABASES INTO @DB 

    END 
CLOSE DATABASES 
DEALLOCATE DATABASES