1. 判断存储过程是否存在
IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'存储过程名') and OBJECTPROPERTY(ID, N'IsProcedure') = 1)
2. 判断临时表是否存在
IF OBJECT_ID('TEMPDB..#TMP_TABLE') IS NOT NULL

SQL字符文本显示：
1. 制表符：char(9)
2. 换行符：char(10)
3. 回车符：char(13)