bitbucket-25253 (12/12/2012)

---

Just a wild idea, but when writing triggers I tend to be rather specific in specifying when they fire for example:

Create trigger orders_update_inventory on orders

for update

As...

Yes. You just build your parameters string dynamically.

declare @Params nvarchar(max) = '';

if @Param1 is not null

set @Params += ', @Param1 int';

if @Param2 is not null

set...

You theoretically could set up a proc that would run indefinitely, which would check the state of the SQL Agent every few seconds, and send an e-mail when it finds...

In that case, I'd need table definitions, sample data (insert statements, please), and the full create script for the trigger.

Once I can reproduce the error, it should be simple the...

You're right. I'm so used to using sp_executeSQL (which definitely does nvarchar(max)), that I missed that exec() had been changed. I'm used to getting an error message on...

Is the actual delete rolled back anywhere in your script?

Will something like this work for what you need?

USE ProofOfConcept;

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T;

CREATE TABLE #T

(ID INT IDENTITY

...

Yes. But when database objects are part of what's dynamic, you can't parameterize those. So...

Yep. And it's a valid sample. Only reason I pointed out improvements in it is that the original question was...

I know of a company that tested its generators every month. Then, when disaster struck, it turned out they had half an hour's worth of fuel left, because they'd...

Are you actually using SQL 2000 (or 7), as per the forum, or do you have a more recent version available? Which solution to use depends on that.

If it's...

jeetsingh.cs (12/12/2012)

---

See Dyanmic Sql is used where we dont want to hard code the values in

our query.

For example if we wan to run this command against a database

than

Create procedure...

The check constraint was simply to make it all numeric. It checks if there are any characters other than numbers, and rejects them. I based that on your...

CELKO (12/11/2012)

---

>> --But I need the result as below (i.e, the order should be same as how I had input the value in the IN() ) <<

You have no idea...

There are a number of things Try...Catch won't Catch, in T-SQL. Compile-time errors are one of those. That includes lost remote connections, since those have to be compiled...