CREATE PROCEDURE Test2 -- Modify Temp Values

AS

UPDATE #t Set x = 2

SELECT Test2Col = x FROM #t

GO





CREATE PROCEDURE Test1

AS

CREATE TABLE #t(x INT )

INSERT INTO #t VALUES...

sure!

IN BOL:

quote:

---

...

A local temporary table created in a stored procedure is dropped automatically when the stored procedure completes. The...

besides keith suggestion make sure Col2 with Col3 have no duplicates because then you may get ramdom Col1 values!!

I think you may want:

With activeX

OR

OLE DB Provider for Microsoft Directory Services

HTH

Part I

Yes

Part II

You will have to change the strategy a little bit because Doing all the processing inside the trigger will be a little painful performance wise

This is...

This is a tricky question because the answer is very dependent on the application.

When you have large hierarchies and it is a controlled environment (security is well defined) the...

From My suggestion you will have to modify a little the stored procedures as:

ALTER PROCEDURE Proc1 (@var1 ....

DECLARE @TrackValue varbinary(128)

SET @TrackValue = CAST( @@PROCID as binary(4) )

SET CONTEXT_INFO...

Unfortunatly The ExcecutionResult Step Property is Read only.

To bypass that behaviour you could handle errors through VB or use an activeX Script task...

This Example Illustrates pretty much ALL you need. The only thing missing maybe the sp_OAGetProperty method but once you read the article its VERY easy to get that functionality...

Besides Antares686 constraint which will guarantee data quality, you could write your procedure as

insert into Table_Name VALUES (@id,@value1)

Where Table_ID <> @ID

IF @@ROWCOUNT = 0

Return = - 1 --insert...

Try here.

Be careful though, if this is not tested well enough it can become security vulnerability.

HTH

Guys,

I really appreciate ALL your posting on this thread. I have learn a lot here. Hardware has allways been my WEAKEST point (never had the opportunity to work for...

quote:

---

quote:

---

quote:

---

Your two "answers" seem to...

This is a very tricky question my answer is test, test and test.

There are "some" cases where the cursor in the winner

quote:

---

Your two "answers" seem to be for a different question from that asked by Minh.

---