DROP TABLE #temp CREATE TABLE #temp (ch CHAR(1)) DECLARE @sTableName VARCHAR(MAX) SET @sTableName = '#temp' IF object_Id(@sTableName)is not null EXEC('DROP TABLE ' + @sTableName) CREATE TABLE #temp (ch CHAR(1))Any idea what I'm doing wrong here?
>CREATE FUNCTION dbo.fnTableExists > (@sTableName VARCHAR(50)) > >RETURNS TinyInt >AS > >BEGIN > > RETURN CASE WHEN object_id(@sTableName) IS NOT NULL THEN 1 ELSE 1 END > >END >