Common Software Development Shortcut Keys & command Summary

 

SQL Server

1. view the information of a field or table in the database. segment_name and table_name can be fuzzy and accurate:

1 select * From information_schema.columnswhere column_name like '% <segment_name> % '3 4 select * From information_schema.tables5 where table_name like' % <table_name> %'

2. Run the following command to view the specific content of a procedure or function:

1 sp_helptext <pro_name or fun_name> (directly write pro_name or fun_name without quotation marks)

 

Common Software Development Shortcut Keys & command Summary