Trigger to split one column and insert into another table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Trigger to split one column and insert into...

Trigger to split one column and insert into another table

Rate Topic

Display Mode

Topic Options

Author

Message

Minnu

Posted Thursday, August 30, 2012 2:10 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:34 AM
Points: 138, Visits: 411

Hi,

I need a trigger on below condition,

am having a table called "Tracker", msg_text is a column in the tracker table.

msg_text contains data like : "NAme <R> city <R> pin <R> phone <R> email <R> country <R>"

<R> Specified the seperator.

my requirement is when a user enters records into tracker table - msg_text column
in above format, data should be enter into another table
"Address" it contains column names "NAme | city | pin | phone | email | country |

Please help me....

Post #1352050

RP_DBA

Posted Thursday, August 30, 2012 6:28 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, June 06, 2013 2:35 PM
Points: 580, Visits: 816

This article might help...

http://www.codeproject.com/Articles/7938/SQL-User-Defined-Function-to-Parse-a-Delimited-Str

_____________________________________________________________________
- Nate

@nate_hughes

Post #1352149

« Prev Topic | Next Topic »

Permissions