yes of course I want to restrict delete query based on some condition.

for example ,

assume a table named sample, and one of the column is tag which holds value 1,2

trigger...

Hi I done like this

create trigger heaven on tablename instead of delete as

SELECT T.text FROM sys.dm_exec_requests R cross apply sys.dm_exec_sql_text(...

yes...

yes your query is very simple ..

but i cant understand ..

Please explain what is cross apply ..

how dose it work in this query?

thanks many

yeah its working ...

any other simple method ???

yes.

but null values need not to be cheked

thank u

Hope this will help,

create table stu_details

(name varchar(1000),

mark int)

insert into stu_details values ('heavenguy',100)

insert into stu_details values ('Tristan',99)

insert into stu_details values ('Jack',98)

insert into stu_details values ('helan',92)

insert into stu_details values ('Jenni',94)

delete a from...

Works fine but im a newbie to SQL ...

Please explain how it works....

hats off to you...

Thanks for the query..

I have derived the output but that was quite complex

create table SampleTable2

(id int identity(1,1) ,Categoryvarchar(100), Organisams varchar(100) )

insert into SampleTable2(Category)

select distinct Category...