...the SQL Query Tool that was designed with you in mind
Get Productive Today!
Home | Product Features | Screenshots | Videos | Download\Purchase | Support Forum | About

Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
Execution of multiple statements
emitch Offline
#1 Posted : Thursday, January 14, 2010 3:52:32 PM
Rank: Member

Medals:

Groups: Member
Joined: 12/31/2009
Posts: 21

Thanks: 0 times
Was thanked: 0 time(s) in 0 post(s)
If I have multiple statements running in one long script, and one of the middle statements fails, I'd like to see an messagebox like ISQL has with options to stop or continue.

We have a lot of scripts that our dba's run on multiple databases and some them just have a drop and create without checking to see if the object exists. If the drop fails, it would be nice to have the option to continue.
Sponsor  
 
Werysoft's QweryBuilder
bradwery Offline
#2 Posted : Thursday, January 14, 2010 7:12:54 PM
Rank: Administration

Medals:

Groups: Administration
Joined: 2/5/2009
Posts: 84
Location: Manitoba, Canada

Thanks: 0 times
Was thanked: 3 time(s) in 3 post(s)
Are these statements separated by GO statements? If so, this would be possible and I could look at adding it in.
Brad Wery
Lead Architect
emitch Offline
#3 Posted : Friday, January 15, 2010 7:25:53 AM
Rank: Member

Medals:

Groups: Member
Joined: 12/31/2009
Posts: 21

Thanks: 0 times
Was thanked: 0 time(s) in 0 post(s)
sometimes "go" statements, sometimes ";", sometimes they are mixed in the same script. The ability to handle both would be nice, but one or the other wouldn't be horrible, especially if its a configuration option. IIRC, CAST SqlBuilder required one or the other, but it was a configuration option.
Users browsing this topic
Guest
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFVision Theme by Jaben Cargman (Tiny Gecko)
Powered by YAF 1.9.4 RC1 | YAF © 2003-2009, Yet Another Forum.NET
This page was generated in 0.459 seconds.
Copyright © 2008-2010 Werysoft Inc. All rights reserved.
SQL Query Tool | SQL Editor | Database Development Tool | SQL References | Testimonials