sp_helptextdisplays the definition that is used to create an object in multiple rows. Each row contains 255 characters of the Transact-SQL definition. The definition resides in thedefinitioncolumn in thesys.sql_modulescatalog view. Note The system stored proceduresp_helptextisn't supported in Az...
当你需要寻找和使用那些很少被使用的存储过程时,你会发现自 己无法记住数据库中所有的存储过程,。当你寻找一个三到六个月才 使用一次的存储过程时,尤其如此。 你可以用 sp_stored_procedures 来列出你的数据库中的所有存储 过程,然后运行 sp_helptext 来查看过程的源代码并找到所需要的参数。 sp_stored_...
Some weeks ago, when I was submitting a stored procedure to be reviewed by my boss, he immediatly asked 'the procedure code is completely screwed'. I imediatly re-scripted it on SQL Server Management Studio and SQLDbx, seeing nothing strange. So, he said: use sp_helptext. Now I saw wh...
--利用系统储存过程,查看 视图文本内容命令格式: sp_helptext view_name 查看 [ 教务数据库 ]的 视图[ 软件班学生成绩] 文本内容命令是: sp_helptext 软件班学生成绩A.正确B.错误的答案是什么.用刷刷题APP,拍照搜索答疑.刷刷题(shuashuati.com)是专业的大学职业搜题找答案,
create view as EXEC sp Create view dynamic pivot create view from stored procedure Create view with NOLOCK CREATE VIEW WITH PRIMARY KEY CREATE/ALTER PROCEDURE' must be the first statement in a query batch. Create/Alter view with declare variable Created a new column in a select statement .How...
EXEC sp_helptext 这句话的作用是,执行这个存储过程,显示出view1视图的定义语句。A.正确B.错误的答案是什么.用刷刷题APP,拍照搜索答疑.刷刷题(shuashuati.com)是专业的大学职业搜题找答案,刷题练习的工具.一键将文档转化为在线题库手机刷题,以提高学习效率,是学习的生产力工
sp_helptext http://baike.baidu.com/view/3313988.htm http://www.yesky.com/imagesnew/software/tsql/ts_sp_help_7c38.htm sp_help http://www.yesky.com/imagesnew/software/tsql/ts_sp_help_304w.htm sp_depends http://www.yesky.com/imagesnew/software/tsql/ts_sp_da-di_9qlv....
Displays the definition of a user-defined rule, default, unencrypted Transact-SQL stored procedure, user-defined function, trigger, computed column, CHECK constraint, view, or system object.