éªè¯
sqlè¯å¥çæ£ç¡®æ§ï¼
-- å®ä¹ä½ æ³è¦æ£éªçSQLè¯å¥
DECLARE
@sql NVARCHAR(MAX)
--'æ£ç¡®çè¯å¥'
SET @sql = 'select * from Report_Test1'
--'é误çè¯å¥'
--SET @sql = 'select 1 from'
DECLARE @testsql NVARCHAR(MAX),
@result INT
SET @testsql = N'set parseonly on; ' + @sql
EXEC @result = sp_executesql @testsql
-- å¦æSQLè¯å¥æ误ï¼å@resultä¸ä¸º0ï¼
IF @result = 0
BEGIN
PRINT 'æ£ç¡®çè¯æ³'
--å¼å§æ§è¡æ£ç¡®çSQLè¯å¥
--exec sp_executesql @sql
END
ELSE
BEGIN
PRINT 'é误çè¯æ³'
--ä¸æ§è¡ä»»ä½æä½
END