Browse by Tags

• How-To
• SQL
• Trigger

• Simple Insert Trigger Example

  I previously posted about using an update trigger to enforce data rules in SalesLogix. Since I was working on another trigger now, I also wanted to post a simple example of an Insert Trigger. Posted Mar 01 2011, 01:01 PM by Jason Buss with | with no comments Tags: How-To, SQL, SQL Functions, Trigger

• Recombining Parsed data in SQL

  A couple of weeks ago, I posted about using User Defined functions and Cross Apply to parse data in SQL server. The second part of the import I was working on required me to take that parsed data, perform some manipulations, and then recombine that data. Surprisingly, I found that putting that data together was much more difficult then pulling it apart in the first place. After much experimentation, this is what I came up with... Posted Mar 30 2010, 08:10 AM by Jason Buss with | with no comments Tags: How-To, SQL, SQL Functions