怎么使用delete语句删除数据

IF OBJECT_ID('tempdb..#tblDelete') IS NOT NULL DROP TABLE #tblDelete;

CREATE TABLE #tblDelete(

    Code varchar(50),       

    Total int   

);

insert into #tblDelete(Code, Total) values('Code1', 30);

insert into #tblDelete(Code, Total) values('Code2', 40);

insert into #tblDelete(Code, Total) values('Code3', 50);

insert into #tblDelete(Code, Total) values('Code4', 6);

select * from #tblDelete;

delete #tblDelete where Code = 'Code3'

select * from #tblDelete;

delete from #tblDelete where Code = 'Code2'

select * from #tblDelete;

delete from #tblDelete;

truncate table #tblDelete;