Tip SQL

 Tip dùng SQL 

1. Xóa database

-- Xóa các kết nối

declare @DatabaseName nvarchar(50)

set @DatabaseName = N'[Database_name]'

declare @SQL varchar(max)

select @SQL = COALESCE(@SQL,'') + 'Kill ' + Convert(varchar, SPId) + ';'

from master..SysProcesses

where DBId = DB_ID(@DatabaseName) AND SPId <> @@SPId

exec(@SQL)

-- Xóa DB

drop database [SweetSoft.GamingMS_2025]

2. Xóa record trong table

delete from [Table] where Id in (

    '4F01B341-1F71-4DFF-A305-7AE204971743'

    ,'629C2042-11FE-4EB8-A8B4-B688C4AB13DA'

    ,'69F126A1-8F9B-4FA6-A063-BCF52E32D618'

    ,'0289D4B3-9DCD-491E-9696-8C1F1529BB24'

);

select * from [Table]