| http://www.w3.org/ns/prov#value | - The example of Dynamic SQL and creating a view is noit really dynamic at all.Here is an example of some truely dynamic SQL to create a view:DECLARE @DBSQL NVARCHAR (2000)DECLARE @DB NVARCHAR (2000)SET @DB = 'TargetDB'SET @DBSQL = 'DECLARE @SQL NVARCHAR (2000)' + CHAR (13) + CHAR (10)SET @DBSQL = @DBSQL + 'SET @SQL = ''CREATE PROCEDURE dbo.prFred as SELECT * FROM TABLENAME''' + CHAR (13) + CHAR (10
|
