SQL: Try/Catch block with rollback
In .Net we are familiar with Try/Catch blocks and you can do this in SQL Server running SQL transactions as well with the additional benefit of “undoing” what was started if something were to fail […]
Tag: SQL Development
Renaming a SQL Server database’s logical name
At times we copy a SQL Server database from one database name to another for testing or development. One thing that doesn’t change is the logical name: Using the following SQL script the logical name […]
Keyword searching using Full-Text Indexing (Getting Started)
Creating a full-text catalog in SQL Server is easy, I used a tutorial on one of our favorite SQL Server blogs: http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/ I created 4 catalogs: Each catalog is assigned to a table and columns […]
Finding the average number of documents in folders
I found an example that used syntax where I could find the average based on a group count. In this case, the group by is the folder’s tracking id (ParentTracking_ID) assigned to the document. SELECT […]
Import Format Macro Example: Creating Drop Down (Lookup) Entries
Scenario: a drop-down (lookup) key-value along with the description are included in an import file. There are data scenarios were in the drop-down (lookup) table: 1) The key (code) already exists and we would use […]
SQL: Get count using a JOIN (Grouping before the Join)
Count of records using a sub-query bypassing the limits of the Group By.