View Complete Post
My SQL Server 2008 is on the Windows Server 2008.
I have a stored procedure which is transferred from SQL 2000 (on Windows Server 2003). Now I would like to have that stored procedure executes every 15 minutes, how do I do that in the SQL 2008/Win 2008 environment?
Thanks for help.
I am breaking my head on this issue since long. I have stored procedure in MS SQl and when I try to execute that procedure by providing all the parameters in SQL Query, it takes long time to execute but when I try to directly run the query which is there
in SP it executes in no time. This is affecting my application performance also as we are using stored procedures to fetch the data from DB Server.
I'm using Dynamic Data with Entity Framework in VS2010.
Let's say my table has these fields:
MyTableID (PK)PersonID (FK)LocationID (FK)TotalItemsSold
Hypothetical scenario (it's easier for me to explain this way, so just bear with me for now)... But let's say each row in the table represents "how many items were sold by such-and-such employee at such-and-such location," where location and person are foreign keys which are referencing other tables. Basically, there should be no more than a ONE row which has a particular combination of Person and Location. Makes sense?
So, when inserting new rows using my Dynamic Data app, the insert form displays editable fields for Person (dropdown), Location (dropdown), and Items Sold (textbox). How do I prevent users from inserting another row into the table containing an already-existing combination of Person and Location? How do I displaying useful feedback to them in the event that they DO attempt to do this?
I have several thoughts about this, but since I'm new to Dynamic Data, I'm not sure which way to go. For example:
Option 1: Use "cascading dropdowns" approach in the insert form and only pull in the "allowed" combinations of the two dropd
I'm have on my web page a text search box which I want users to type in there favourite football team and this will display a gridview of the teams with the replica shirts I offer.
This is where I thought about creating a stored procedure to carry out this task.
I looked online for ideas but I not found anything as yet.
If anyone done anything similar to my request please let me know.
I have a gridview that calls data via a stored procedure. I am unable to enable the gridview columns to be sortable. I need to set the parameter in the Stored Procedure, can someone help me with this?
Here is my gridview:
<asp:GridView ID="AllUsersGrid" runat="server" AutoGenerateColumns="False" DataKeyNames="UserName"
GridLines="Vertical" Width="900px" DataSourceID="SqlDataSource1" AllowSorting="True"
SelectedRowStyle-Height="30px" CellPadding="4" BackColor="White">
<asp:TemplateField HeaderText="Full Name" SortExpression="lastname">
<asp:Label ID="DisplayName" runat="server" Text='<%# Eval("firstname").ToString() & " " & Eval("lastname").ToString() %>' />
<asp:BoundField HeaderText="User Name" DataField="UserName" />
I am looking for a stored procedure generator with full source code(C#) compatible with Visual studio 2010. I want to create my custom stored procedure code. Please send some link.
Is it possible to change the select, insert and update stored procedure of an SqlDataSource at run time. I don't mean to change the definition of the stored procedure, but I mean to change the assignment, i.e. To change the select stored procedure from "selectSP1" to "selectSP2" at run time. Is it possible?
we are creating a custom report tool, which could be used for generate the report as per end user's needs. In that we are providing an option as user could create a query and procedure as well.
In sql server we can use "EXEC" function for execute dynamic query.
Could anyone help me for create the dynamic query in Oracle?
I just tried with "execute immediate", which would throws error as
Please help me.
Please help me.
MSDN Magazine January 2001
I have a C# web page that calls a stored procedure. The page passes few parameters to the stored procedure and call it. The stored procedure does so many time consuming tasks on a huge number of database records but does not return any value.
Since the page is not expecting any return from the stored procedure, I want to execute the stored procedure asyncronously so that the user can continue working on the web page and other web pages while the stored procedure is running in the background. Also, I do not want the web server processes to be busy with the running stored procedure.
Any help, please.
I'm using VS 2008 and SQL 2008.
I have created the tables and the stored procedures in SQL 2008.
In VS 2008, I created DataSet1.xsd in App_Code and created the connectionString in web.config file.
Then when I go into the DataSet1.xsd and try to add a TableAdapter, strange things happened.
First I chose the data connection, then selected "Use existing stored procedure", then there was nothing listed in the dropdownlists (in Select, Insert, Update, or Delete).
I'm sure the connectionString is correct because if I choose "Use SQL statement" and type in a "select * from mytable1", the TableAdapter can be created without any problem.
I am working on updating a reporting system that uses Crystal Reports. All of the 250+ reports were created in CR 8 and I have been opening up the old files in Visual Studio 2005 and updating the database location. All I have had to do with all connections to views and even a couple of stored procedures is create a new connection to the database and then update the old report's datasource location. The reason I need to update the location is so that the .NET application will use the correct driver. Everything has worked fine up until I got to one stored procedure. The old version of the report works perfectly with the stored procedure, but when I try to run the report using VS 2005 I keep getting errors.
First I connected to the database using the Oracle OLE DB provider, then updated the location of the stored procedure in the report. It then prompts me for the two parameter values for the stored procedure, both of which I keep as NULL so that the report parameters will be passed to the procedure. Then I get the following error:
Query Engine Error: 'ADO Error Code: 0x
Description: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'STORED_PROCEDURE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored'
Here is my SP:
create or replacePROCEDURE ZGETUSERSSIGNONS (vUid IN VARCHAR2, p_getuserssignon_recordset1 OUT SYS_REFCURSOR) ASBEGIN Open p_getuserssignon_recordset1 for SELECT Distinct(Userid), UserPassword, SecurityLevel, ActiveStatusFROM ZSIGNON WHERE substr(UserId,1,2) <> vUidOrder By UserId;END ZGETUSERSSIGNONS;
I would like to run this SP from code and fill a gridview with the result.
I am not sure how to go about this, as I have found several different examples, other than the one I think I need.
I am using the oracle data provider and I have an input parameter (vUid, which will equal "zz").
First question. When filling a gridview with a result set from a stored procedure should the recordset OUT be defined as a REFCURSOR (like i did above)?
Do you have example code as to how to execute the SP and fill a gridview? I keep trying different variations of code i've found on the internet without any success other than getting more confused.
(I am using VS 2005, VB).
I wanted to know how to prevent more than one user from
uploading the report at a time .I am new to .net ,plss help with the
code that would be great.Details are below:
This is a Windos based
app written in c# . When User A clicks Upload option on one server
from the menu to upload the files and at the same time when User B
clicks Upload option on different server , User B should be alerted a
message saying "User A's uploading is in progress,pls wait" . How to
achieve this, plsss help with the code.. I am thinking this logic should be kept in a stored proc, How do I write that proc? plss help
Thanks in advance!