No announcements
Found 1539819 threads
-
1 VotesStored Procedure Insert then Select
I have added a stored procedure to a DataContext , this stored procedure contain an insert to a temp table then a select , so when i ...Answered | 1 Replies | 3987 Views | Created by Matelin - Sunday, January 17, 2010 8:55 AM | Last reply by Matelin - Sunday, January 17, 2010 5:06 PM
-
0 Votes
Using the same stored procedure for Insert and Update functions
i am trying out the entity framework for the first time... I have a stored procedure which inserts/updates a record.(if record exists then updates, else ... -
0 Votes
problem while running the stored procedure
I have a problem while running the stored procedure. I have 2 databases and tempdb database 1 has Latin1_General_CI_AS ...Proposed | 1 Replies | 6397 Views | Created by Anthu - Friday, December 11, 2009 8:06 AM | Last reply by Kalman Toth - Friday, December 11, 2009 8:50 AM -
0 Votes
Stored procedure help
Hello all, I have a program and I select a line number and it takes me to a new page then I select a detail comment and then hit the ...Answered | 4 Replies | 3211 Views | Created by mxstar45 - Tuesday, May 4, 2010 7:14 PM | Last reply by Janus007 - Tuesday, May 4, 2010 11:31 PM -
0 Votes
Stored Procedure using a declared variable in insert query (inline or using EXEC)
Hello, I have a stored procedure where I run an insert statement. I want to knwo if it is possible to do it using a variable for the table name ...Unanswered | 1 Replies | 5509 Views | Created by b42 - Wednesday, May 14, 2008 1:06 PM | Last reply by Tom Phillips - Wednesday, May 14, 2008 1:49 PM -
0 Votes
performance Issue with Oracle union all
if all the 5 queries are fast by themselves, you could make a stored procedure and insert each select in a temp table, then select all the rows of ...Answered | 1 Replies | 3145 Views | Created by Surendra_Thota - Friday, September 7, 2012 3:13 PM | Last reply by Alex Jean - Friday, September 7, 2012 6:12 PM -
0 Votes
Nested Try/Catch in a stored procedure going to outer
I am using Service Broker to move data to a historical database and then delete it from the current table in a second stored procedure that gets the information passed to ... -
0 Votes
Execute Stored Procedure in a batch file using a result from Query as a Parameter.
Add single quotation and remove bracket in the stored procedure parameter. i.e "Execute dbo.Procedure_Upsert_Item 'Select * from ...Answered | 1 Replies | 1613 Views | Created by BU Systems - Wednesday, September 25, 2013 1:25 AM | Last reply by Ch. Rajen Singh - Wednesday, September 25, 2013 1:44 AM -
0 Votes
Stored Procedure Doesn't Return All the Data to the Report
. Then I reterieve the information from the temp table by using some filtering criteria. The issue is, the stored procedure works well in query analyser ... -
1 Votes
Call a stored procedure from a stored procedure
to get the output values then insert into the template table @riderinf, the getmuttsdailyride stored procedure which you post can run well. So we ...Answered | 5 Replies | 1254 Views | Created by Dave Parker - Saturday, October 5, 2013 2:30 AM | Last reply by Ch. Rajen Singh - Sunday, October 13, 2013 1:46 AM -
0 Votes
Alternative for Stored Procedure in Smart Device Developement
using the NextResult property of the SqlCeDataReader. So, We need to generate existing stored procedure script .sql file. ...Answered | 1 Replies | 3676 Views | Created by AmbroseSL - Thursday, March 29, 2007 8:32 AM | Last reply by Alex Yakhnin - Thursday, March 29, 2007 1:29 PM -
0 Votes
how to implement a function in a stored procedure
How do I get my Stored Procedure to use a function? The function takes in four parameters...amount, current currency, currency to convert to, and todays date...I am trying to use the ...Answered | 1 Replies | 5091 Views | Created by Spawn10 - Monday, February 1, 2010 4:58 PM | Last reply by Kent Waldrop - Monday, February 1, 2010 5:15 PM -
0 Votes
TableAdpater and Typed DataSet woes
We are using SQL Server 2005 with stored procedures and trying to develop using typed datasets. If I add a typed dataset with a select and say an insert stored ... -
0 Votes
vb.net app using a temp table and/or a stored procedure
In a vb.Net 2010 application, I want to insert records into a SQL Server #temp table and then do a select on all the rows to be displayed in an object like a gridview ...Answered | 3 Replies | 1646 Views | Created by midnight_car - Thursday, March 17, 2016 4:28 AM | Last reply by Paul P Clement IV - Thursday, March 17, 2016 1:23 PM -
0 Votes
INSERT Stored Procedure into Table
I have a stored procedure that I have scheduled as a job to run nightly at midnight. I want the stored procedure to insert the data into a table when it ...Answered | 1 Replies | 687 Views | Created by ITMgr-WynneTransport - Tuesday, October 22, 2019 11:41 AM | Last reply by Erland Sommarskog - Tuesday, October 22, 2019 9:44 PM -
3 Votes
Can you use Multiple Select Statements in a Stored Procedure?
changes. For the stored procedure my advice try to combine all the table using join statement and then try to sum it out. Vote me if its ...Answered | 2 Replies | 13824 Views | Created by NT86 - Wednesday, January 6, 2010 11:22 AM | Last reply by Kumar Senthil - Thursday, February 28, 2013 7:01 AM -
0 Votes
Do a delete and then Insert in a single stored procedure
You need to wrap it in a BEGIN END clause, as follows I am trying to do a delete and then an insert in a stored procedure. It will do the ...Answered | 4 Replies | 4302 Views | Created by daktmacfan - Friday, February 26, 2010 9:04 PM | Last reply by Naomi N - Friday, February 26, 2010 9:42 PM -
0 Votes
Calling Stored Procedure using ADO w/ C# returns closed recordset
key table and then returns the next unique key value. The code below calls the stored procedure. If I change the stored procedure so it ...Answered | 1 Replies | 4559 Views | Created by Dwight Kulkarni - Wednesday, September 20, 2006 1:17 PM | Last reply by Sahir Shah - Wednesday, September 20, 2006 1:45 PM -
0 Votes
EF4: insert stored procedures with Input/Output primary key
I am trying to setup an insert stored procedure so that a primary key may be provided by the client, but automatically generated if no key is provided. The primary key ... -
0 Votes
insert stored procedure and null values
how do i allow for null values in a insert stored procedure? if i do not enter a value then the "procedure or function ...Answered | 1 Replies | 4492 Views | Created by Webmonkeymon - Thursday, January 27, 2011 2:28 PM | Last reply by Paul P Clement IV - Thursday, January 27, 2011 3:43 PM - Items 1 to 20 of 1539819 Next ›
No announcements
