home
Transact SQL
| sp_executeSQL | setting variables from dynamic sql |
| Retrieve Tree Hierarchy | Retrieve formatted tree structure |
| Get table row counts | Retrieve the number of rows in each table in a database |
| Find gaps in sequence numbers | Find gaps in sequence numbers |
| Create text file | Creating a text file from a stored procedure |
| spFormatOutputBuffer | Retrieve a sql server error message |
| Access Temp Tables Across SPs | Create a temp table in one SP and access from another |
| sp_CreateDataLoadScript | Create a data insert script from a table |
| Create Script File | Concatenate files to make single script |
| Move data using column definitions | Move data from import table to production table using file format definition |
| Remove non-numeric characters | Remove non-Numeric or non-alphameric characters from a string or field |
| Find non-alphameric characters | Function to return all non-alphameric characters from a string in a table |
| Primary Key Columns | Get all fields that are part of the primary key |
| Check if file exists | find file - scripting object, xp_cmdshell, xp_fileexist |
| Cursors | Advanced use of cursors in t-sql |
| Import Text Files | Import and archive text files that arrive in a directory |
| f_GetEntryDelimiitted | Get entries from csv string |
| fn_ParseCSVString | Function to return a table from a delimitted (csv) string |
| bcp | bcp using format file & quote delimitted strings |
| CSV String From Table | Create delimitted string from table entries |
| BCP all tables | BCP in and out data from all tables in a database |
| CrossTabs | Crosstabs and pivot tables |
| s_ProcessAllFilesInDir | Process all files in a directory |
| UpdateText | Inserting text data to a table in 8000 byte chunks |
| Replace Text | Search and place strings in a text column in a table |
| Table name as variable | Accessing a table from a name in a variable |
| send email | Send emails asynchronously |