clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335508 fiddles created (27413 in the last week).

CREATE TABLE t(i INT); INSERT INTO t(i) VALUES(1);
1 rows affected
 hidden batch(es)


CREATE PROCEDURE proc1 AS BEGIN DROP TABLE IF EXISTS t; DROP PROCEDURE IF EXISTS proc1; END;
 hidden batch(es)


SELECT * FROM t
i
1
 hidden batch(es)


EXEC proc1;
 hidden batch(es)


SELECT * FROM t
Msg 208 Level 16 State 1 Line 1 Invalid object name 't'.
 hidden batch(es)


EXEC proc1; -- Could not find stored procedure 'proc1'.
Msg 2812 Level 16 State 62 Line 1 Could not find stored procedure 'proc1'.
 hidden batch(es)