Hai...
if i execute a procedure as my code starts as follows...
PROCEDURE PROC_SY_ADD_INSERT_FUNCTION
GO
IF EXISTS (SELECT * FROM sysobjects
WHERE id = OBJECT_ID('PROC_INS_FUNCTION')
AND OBJECTPROPERTY(id, 'IsProcedure') = 1)
DROP PROCEDURE PROC_INS_FUNCTION
GO
CREATE PROCEDURE PROC_INS_FUNCTION
()
...
...
...
after executing(creating) above procedure.. ... will it clear existing cache?....will it create new execution plan when next time this sp called?... any help on this?
Thanks in advance...