Interesting SQL scripts for Sql Server.
Russell Hankins
09b28d7057
Fixed an issue with databases user can't access.
|
6 달 전 | |
|---|---|---|
| README.md | 8 달 전 | |
| csp_DropColumnDescriptions.txt | 1 년 전 | |
| csp_ExportColumnDescriptions.txt | 1 년 전 | |
| csp_SetColumnDescription.txt | 1 년 전 | |
| fn_SplitPK.txt | 1 년 전 | |
| sp_ColumnsInATable.txt | 1 년 전 | |
| sp_CreateForeignKey.txt | 1 년 전 | |
| sp_CreateUserDefinedType.txt | 1 년 전 | |
| sp_DropColumn.txt | 1 년 전 | |
| sp_ExportTable.txt | 1 년 전 | |
| sp_Find.txt | 6 달 전 | |
| sp_FindColumn.txt | 1 년 전 | |
| sp_FindGuid.txt | 1 년 전 | |
| sp_FindInAllProcs.txt | 1 년 전 | |
| sp_FindInProc.txt | 1 년 전 | |
| sp_List.txt | 6 달 전 | |
| sp_ListFields.sql | 1 년 전 | |
| sp_varinsp.txt | 1 년 전 |
README.md
SQL-Server-Tools
- sp_ColumnsInATable - Lists the columns in a table in a comma delimited list. Useful to copy and paste to a select or insert statement.
- sp_CreateForeignKey - Given a primary table, primary key, foreign table, foreign key, output the sql to create the foreign key.
- sp_CreateUserDefinedType - Helps deal with issues of user defined types such as not being able to update it because it's being used. 6 actions are available:
- CREATE - Drop, then Creates a new user defined type. Only works if no proc is using it.
- LIST - Lists all the procedures using this user defined type.
- DROP - Drops the type IF it`s not being used.
- KILL - Drops the type AND all procs using it.
- ALTER - Drops all the procs using it, drops the type, creates the new type, then recreates the new procedures.
- FORCE - Similar to ALTER, except:
- ALTER will fail if the change would cause a stored proc to fail to compile.
- If this user defined type would cause a proc to not compile, FORCE drops that proc, then lists it.
- sp_DropColumn - Alter table drop column doesn't work if it has a constraint. This finds and drops the constraints too.
- sp_Find - Searches all databases for a column, table, or procedure name containing the text you are searching for.
- sp_FindColumn - Searches all databases for a column name containing the text you are searching for. If you give it two parameters, both strings are used.
- sp_FindInAllProcs - Searches all databases in all procedures for the text you specified. If you specify two parameters, both are used. A good use for this is to search for a table name and the word insert.
- sp_FindInProc - Searches the current databases in all procedures for the text you specified. If you specify two parameters, both are used. A good use for this is to search for a table name and the word insert.
- sp_List - Lists a stored procedure if an exact match is found to what you passed in. Otherwise, lists stored procedures containing that string.
- sp_ListFields - Lists the columns in a table. Also displays field types, column comments and foreign key relationships.
- sp_varinsp - Searches a stored procedure you specify for a text string you specify. Recursively searches all the procedures this procedure calls also. Will output a tree diagram of where the text is in and how to traverse there in the stored procedure heirarchy.
- fn_SplitPK - Split a comma delimited list of integers into a table. Assumes that the list is unique. The table is indexed. This helps for inner joining with large tables.
- sp_FindGuid - Searches all uniqueidentifier columns in all tables for a specific guid. Returns the table names it was found in and the SQL to display the rows.
- csp_SetColumnDescription - Adds,updates,deletes,displays a column description.
- csp_ExportColumnDescriptions - Exports the column descriptions of a table into a format to be sent to another database.
- csp_DropColumnDescriptions - Deletes all the column descriptions on a table.
- sp_ExportTable - Exports a table by outputting a sql statement to insert the records.