sql select into cursor example for entire tables
This is my first time doing a cursor and i really have no idea how to do it.  I'm doing a select into and my code is below.  How can i modified this to make a cursor and keep it as simple as possible.  The point will be to call this programatically in C#, i can create the code for C# but not sure how to turn this into a cursor statement.

`SELECT * INTO targetDB.dbo.targetTable FROM sourceDB.dbo.sourceDB`

I need to cursor this in because the trigger that are on the DB don't handle multiple lines.  Any help would be great!  Thanks!
sql select into cursor example for entire tables
===

This is my first time doing a cursor and i really have no idea how to do it.  I'm doing a select into and my code is below.  How can i modified this to make a cursor and keep it as simple as possible.  The point will be to call this programatically in C#, i can create the code for C# but not sure how to turn this into a cursor statement.

`SELECT * INTO targetDB.dbo.targetTable FROM sourceDB.dbo.sourceDB`

I need to cursor this in because the trigger that are on the DB don't handle multiple lines.  Any help would be great!  Thanks!