How to Terminate SQL server sessions for the Database

DECLARE @DatabaseName nvarchar(50)

SET @DatabaseName = DB_NAME()SELECT @DatabaseNameDECLARE @SQL varchar(max)SELECT @SQL = COALESCE(@SQL,'') + 'Kill ' + Convert(varchar, SPId) + ';'FROM MASTER..SysProcessesWHERE DBId = DB_ID(@DatabaseName) AND SPId <> @@SPIdSELECT @SQL  -- It will give the sessions with Kill Query which we can use in the database.