SQL Server 中有用的系统存储过程 [英] Useful system stored procedures in SQL Server
问题描述
我最近发现我可以使用 sp_help
来获取表定义,并且从那时起就一直使用它.在我发现之前,我不得不在 SQL Management Studio 中打开对象资源管理器,手动搜索表名,右键单击表并选择设计.真是费了好大劲!
I recently discovered that I could use the sp_help
to get a table definition and have been hooked onto it since then. Before my discovery, I had to open up the Object explorer in SQL Management studio, manually search for the table name, right click on the table and select Design. That was a lot of effort!
你们都使用过哪些其他系统存储过程是你离不开的?
What other system stored procedures do you all use that you can't simply live without?
推荐答案
Alt + F1 是一个很好的 shortcut sp_help
的键.
Alt + F1 is a good shortcut key for sp_help
.
sp_helptext
是获取存储过程文本的另一个好工具.
sp_helptext
is another goodie for getting stored procedure text.
这篇关于SQL Server 中有用的系统存储过程的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!