I have to insert the temp record into a temp table in order to resolve the issue at last. But I think I have a lot of user store procedures to compute record sets. Do I have to create a lot of temp tables? Is it a bug or some mis-understand by me?

There are two store procedure on same DB server: create procedure usp_A as declare @ShiftName as datetime select @ShiftName=getdate() select * from LineConfig where Cur_PlanQty_0=0 GO create procedure usp_B as select * from LineConfig where Cur_PlanQty_0=1 GO I use follow sql want to get the union record sets select * from openrowset('sqloledb','trusted_connection=yes','abc.dbo.usp_A') U N I O N ALL select * from openrowset('sqloledb','trusted_connection=yes','abc.dbo.usp_B') get the follow error message: Could not execute query against OLE DB provider 'sqloledb'. The provider could not support a required property. The provider indicates that conflicts occurred with other properties or requirements. OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. if I remove the usp_A the local variable operation sentence: select @ShiftName=getdate() the error message disappear. if I add new sentence such as: declare @ShiftValue as varchar(10) the same error message display again.

if the browser support the JavaScript, please use the event.keycode properties to identify the keypress event happened and then do your functions.

The tool: Eclipse will help you after you install JavaScript model.

I think you can set the input text-box to disable status to prevent user enter the new text. please use the like below code:

document.getElementById("YourID").disabled=true;

modified on Friday, November 19, 2010 2:39 AM