笔记18 exec与sp_exectesql的区别

笔记18 exec与sp_exectesql的区别

1 exec与sp_exectesql的区别
2 USE GPOSDB
3 
4 DECLARE @statement NVARCHAR( 4000)
5 SET @statement ='select * from systempara'
6 EXEC sys.sp_executesql @statement
7 
8 EXEC('select * from systempara')

 

posted @ 2013-08-02 21:41 桦仔 阅读(...) 评论(...)  编辑 收藏