select 'drop procedure '+name from sys.procedures where name like'%%'

Copy the result and execute it

Thanks

for Your Immediate Response

But TestId is not unique ,number of male can give same test ,then

DECLARE @Data TABLE (test_id INT , gender TINYINT NOT NULL CHECK (gender BETWEEN 1...

The answer is ABCD

as union remove all the duplicate values

if You want to retain all values please use UNION ALL 🙂

Hello

you can create a non clustered on the column which is mainly used in where clause with fill factor of 90%

hello

temporary tables are least in use as they consume the memory resource

Instead of temporary tables you can use the table variable as the table variable is just like...