Oracle SQL Developer is a free download straight from the oracle web site.....but i think they require you to register:

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

i think the Op is doing two or more things ...not real sure now after rereading...

IF EXISTS(...)

BEGIN

PRINT 'do something conditionally'

PRINT...

lallu_jaya (8/5/2011)

---

The if exists statement that I included performed the check but it also updated the column group values that were not equal to 2 (<>2) made 2.

It updated the...

lallu_jaya (8/5/2011)

---

I want to include this check within the stored procedure. I want sql to automatically check when stored proc is called by JOB...Can I do that?? or should I...

soemthing like this?

If EXISTS(select [group] from dbo.group_data WHERE [group]<> 2)

BEGIN

EXEC MyProcedure @param

--email that the proc was run?

END

AFAIK, the C2 trace should already have the STOP on error flag in place,

at least when i read this:

http://technet.microsoft.com/en-us/library/cc293615.aspx

it's a requirement of that type of audt.

double check with the SQL...

it has to do with one of the parameters in the trace creation:

http://msdn.microsoft.com/en-us/library/ms190362.aspx

if you have a trace like this, where @options = 2:

you need @options = 6 to enable stop...

it's not really a dumb question, but one that you will end up tripping over more than once.

when you do an update like this:

UPDATE SomeColumn = (SELECT....)

the SELECT statement has...

sure...but what is the question?

you could build a string in the application and do ExecuteNonQuery("insert....")

or you could use a datatable and...

not possible from SQL. doesn't matter if you are talking exchange or an SMTP/POP3 service, there's no built in way to READ emails back.(sp_send_dbmail lets you SEND an email)

you'd have...

that kind of issue is tough...anytime you have dates in a non-datetime field, you would ideally want to change the datatype to fix that in the future. otherwise you get...

it can be confusing how you are able to get data back from a procedure.

there are three ways, and you can use them ALL at the same time:

1. reutrn a...

{Edit} just noticed you posted this in SQL2000, and CTE's are only available in 2005 and up...so the compatibility mode i mentioned isthe most likely culprit if you are...

gotcha; an exclusive table lock might occur if you are updating the whole table (SET name = UPPER(name))

or if you were updating on a range(' WHERE name like 'S%') ....the...

this is the core question for me:

Create controls dynamically per template

How is it doing that? from specific list?

tweaking the templates behavior is somethign i'd consdier.

you could have the template...