Search for text in procedures (no cursors)
This function returns a list of all procedures and functions that contain the given text value. It has an additional parameter to exclude procedures that contain a second text value.
2004-04-08
207 reads
Func. generates insert and select for large table
Generates an insert statement including column list. Useful for identity table data copying. Just modify the code generated to select and insert the needed fields. Saves time on large table inserts (also generates a select statement. Use part or all of the SQL generated. Saves development time when dealing with large tables.
2003-02-21
166 reads
Gen. vars, types and select into vars for a table
Generates a declare statement including data types for a table and generates a select statement to set the variables from the table. Speeds development time when dealing with getting values into variable from large tables.
2003-02-21
133 reads
Blogs
Bash: ^^}: bad substitution – upgrade your Bash version (macOS)
By HamishWatson
This blog post is about a situation where you are capitalising an argument in...
Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”
By HamishWatson
This blog post relates to where you might be doing scale operations of your...
Bash: “command not found” in IF statement
By HamishWatson
This blog post is about a situation where writing an IF THEN ELSE statement...
Forums
Power Query or SQL Server? Which, when and why
Comments posted to this topic are about the item Power Query or SQL Server?...
Are You Empowered?
Comments posted to this topic are about the item Are You Empowered?
Strange Code
Comments posted to this topic are about the item Strange Code
Ask SSC