sp_makewebtask在sql 2008中不可用 [英] sp_makewebtask is not available in sql 2008
问题描述
以下查询的任何替代代码,因为sp_makewebtask在sql 2008中不可用
Pl帮助
USE pubs
GO
EXECUTE sp_makewebtask @outputfile ='C:\ WEB \MULTIPLE.HTM',
@query = 'SELECT title,price FROM titles SELECT au_lname,au_fname
FROM authors SELECT pub_id,pub_name FROM publishers SELECT au_lname,
au_fname FROM authors',@ templatefile ='C:\\ \\ WEB \ MULTIPLE.TPL',
@dbname ='pubs',@ wingcnt = 5,@ whentype = 9
GO
Any Alternate code for below query, because sp_makewebtask is not available in sql 2008
Pl help
USE pubs
GO
EXECUTE sp_makewebtask @outputfile = 'C:\WEB\MULTIPLE.HTM',
@query = 'SELECT title, price FROM titles SELECT au_lname, au_fname
FROM authors SELECT pub_id, pub_name FROM publishers SELECT au_lname,
au_fname FROM authors', @templatefile = 'C:\WEB\MULTIPLE.TPL',
@dbname = 'pubs', @rowcnt = 5, @whentype = 9
GO
推荐答案
检查此替代
帮助替换已弃用的SP_MAKEWEBTASK [ ^ ]
这篇关于sp_makewebtask在sql 2008中不可用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!