OK...let's agree to disagree. I see something like that, no good reason for something like that in a multi-user environment, and I take it to be a programmer's request...

"The point is you don't know for sure."

Actually you made that leap to multiple users not me, I took it at face value. Why would any application possibly...

I didn't see that being a requirement...where do you see that?

It wasn’t this:

“I need to pull data using multiple EXECs to get individual items. Example:”

Or this:

“Obviously, the output will be...

If you don't want to predefine the table you can use something like this:

declare @iParm int

set @iParm = 111249972

declare @sql varchar(1000)

set @sql = 'SELECT a.* into...

tnocella (10/10/2011)

---

I have a simple query:

SELECT name FROM atable WHERE a = 1

I want it to return Null if it finds nothing, but it just returns an empty...

BinaryDigit (7/20/2011)

---

Hi

I know that stored procs are a lot better than executing the same script all the time because it is able to cache, but becasue caching will mainly help...

K. Brian Kelley (5/11/2011)

---

Actually, I typed...

Is...

GilaMonster (5/11/2011)

---

What account does SQL Server...

K. Brian Kelley (5/11/2011)

---

Keep in mind that a logon trigger that blocks a certain application (like Excel) will do that for all connections of that application. So if you have...

Thank you...I passed that on to my project leader 🙂

That being understood my question remains unanswered...can a specific program\executable be blocked?

I'm no expert by any means but I posted a similar question once before. Generally speaking, just from what I was told, it really doesn't matter in basic joins....

DerbyNeal (3/2/2011)

---

Hi Tyson,

Thanks for the tip. The INSERT table/method is VERY useful - but wouldn't I still require a TRIGGER to run it though?

Using this method I would still need...

Maybe an alternative to a trigger is the OUPUT statement:

DECLARE @TmpTable TABLE (ID INT, TEXTVal VARCHAR(100))

----Insert values in real table as well use OUTPUT clause to insert

----values in the temp...