Calling Sql Server 2008 Stored Procedures Via Dblinks ?
May 6, 2010Can this be done?
View 4 Replies
Similar Messages:
SQL Server :: Transfer Some Tables And Stored Procedures From 2005 To Express 2008?
Sep 4, 2010I am trying to transfer some tables and stored procedures from SQL Server 2005 to Express 2008. I have tried using Management studio, but it isn't working....
View 5 RepliesMVC :: Calling Stored Procedures From Within MVC?
Dec 1, 2010We have an existing application with a mature database where most of the business logic is in Stored Procedures that are maintained by a separate department. Application developers are not given access to the database except via stored procedures.
I am looking for an example of calling stored procedures from within MVC.
Actually, we have done almost no development until now in ASP.Net at all. Is the difficulty in interacting with stored procedures a MVC problem or is it a more generic ASP.Net problem?
SQL Server :: Stored Procedures In Server 2008?
Dec 11, 2010Informative link for the complete tutorial about how to write stored procedure in sql server 2008and how to call it at runtime on button event generation on website page..
View 7 RepliesDatabases :: Calling Stored Procedures From C#
Sep 20, 2010I'm tyring to call stored procedures from asp.net C#.
Initially i created a stored procedure in mysql database which returns a whole table when executed.Bt i'm a bit confused on how to call the stored
procedure from c#.
Fill Business Object From Database By Calling Stored Procedures?
Jun 10, 2010I have several stored procedures in my database, some of them have params, some have no params. I tried to fill a business object by calling the stored procedures, but failed so far. How could I do that dynamically? Later, I want to use this object as a datasource for a report...but thats the next step. The important facts are:
different stored procs return different amount of columns stored procs can have params, but its not required
SQL Reporting :: Can't SSRS 2008 Handle Stored Procedures Which Return Multiple Tables
Oct 13, 2010I tried it and it only returns the first table.
View 2 RepliesSQL Server :: Script All Stored Procedures In One Hit?
Nov 18, 2010I've been working on an upgrade for an app that's currently online.
I copied the database to my development server, have been making upgrades to the db (new tables, additional stored procedures, functions, etc). The new upgraded db is now complete and ready to go back online. I developed a script for all the new tables as I created them.
Basically this new db will go with the new upgraded app at a new domain.
So my plan is this...
Copy my existing db (the original) over to the new server.Run the script I developed on my development server to upgrade the new db to the latest version. Take the original db offline once the new one is running. However when I developed the new sps and fcns I didn't script them like I did for the tables (ooops! not thinking), and I have about 100 new sps. Is there anyway to script all the sps in one hit, so that I can run one script to upgrade the new db?
Or do I have to script them individually?
MVC :: SQL Server 2005 - Stored Procedures - NO LINQ?
Jan 27, 2010I'm totally new to MVC (started this morning), and am totally at a loss where to start. I need to rebuild an existing website. I already have a SQL Server 2005 database with tables and stored procedures. In the old version of the website, I built a function to call stored procedures and return the results as a datareader in VB.Net.
I want to use ASP.NET MVC with C#.
The first question I have is: Where would I put the code for the function that calls stored procedures ?
My second question is: Where do I go from there? I just need to get a sense of the basic way to handle presenting a dynamic website. I just want to start out with a Site.Master and display my menus which need to be generated dynamically from my database. I've been googling all day and I haven't really found any posts which answer all of my questions.
SQL Server :: Retrieving Data From Stored Procedures?
Feb 2, 2011I need to retrieve data from a stored procedure, but not from a reader. I need to insert and read to see if there is an error code returned so I can Display It
[Code]....
This inserts data into a stored procedure, since I have a promotion going on, I want to check to see if anyone has tried to create several accounts to try to be Customer #100 or so on, I have achieved this in the procedure, and set RETURN @ErrorCode = 1
Have I Set up the SqlParameter Correctly, or do I now have to declare a direction for each parameter?
I have had problems reading from Stored Procedures and Tutorials Seam Straightforward, but thay are about readers only not Input Output
SQL Server :: How To Debug Queries And Stored Procedures
Mar 24, 2011How to debug queries and stored procedures in sql server 2008 like we doing in vs
View 1 RepliesSQL Server :: Working With Two Tables Using Stored Procedures?
Dec 20, 2010I am trying to insert some data into a table and update another table using the same stored procedure but it doesn't work.
ALTER PROCEDURE dbo.new_suppliers_orders_add_products
@SupplierOrderID int,
@ProductID int,
@OrderQuantity int,
@NewOrderQuantity int
AS
INSERT INTO SupplierOrderLine(SupplierOrderID, ProductID, OrderQuantity) VALUES (@SupplierOrderID,@ProductID, @OrderQuantity)
UPDATE Products SET QuantityOnOrder = @NewOrderQuantity WHERE ProductID=@ProductID
RETURN
Is it any way it can be done or I need to use two separate stored procedures?
SQL Server :: How To Return Values From Stored Procedures
Aug 13, 2010how to return list of values(single column values) from stored procedures in sqlserver 2005?
View 4 RepliesSQL Server :: Stored Procedures Output Parameters?
Mar 16, 2011I have never used stored proc ouput parameters i want to know what is the use of using output parameters?If possible provide me some code.
View 10 RepliesSQL Server :: Pass The In Out Parameters In Stored Procedures?
Dec 12, 2010how to pass the in out parameters in stored procedures
and how to execute it??
Web Forms :: Merge Two Stored Procedures In SQL Server
Oct 5, 2012I use below store procedure that don't allow insert duplicate data in database in code column
ALTER procedure [dbo].[insertestate1]
@position nvarchar(max)
,@Transfer nvarchar(20)
,@Type nvarchar(20)
,@Behcode nvarchar(10)
[Code] ....
And this is my other SP that I define Condition ,and according to that condition it update or insert data in database
USE [behtop]
GO
/****** Object: StoredProcedure [dbo].[insertestate] Script Date: 10/04/2012 11:36:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[insertestate]
[Code] ....
In first SP @code parameter is column in table that I don't want accept duplicate value and condition of that is:
IF NOT EXISTS(SELECT behcode FROM Estate_p WHERE code = @code)
And in second SP I have @code parameter that I don't want it insert duplicate data on it too. But here condition is
IF @id > 0 AND EXISTS(SELECT behcode FROM Estate_p WHERE id=@id)
Now I want merge two SP .. How I can do it?
DataSource Controls :: Prevent Server/Database To Have SQL Stored Procedures Encrypted?
May 13, 2010I have access to two servers, one with my development database on, and another with the live database on.
All SQL Stored Procedures, Functions, Views are encrypted on the live database (using WITH ENCRYPTION in my query)
However I'm concerned I might accidentally encrypt a bunch of SProcs on my development database meaning I can no longer view/edit that code.
I have full control over the server and database, and was wondering if there is a way I can prevent these from being encrypted, therefore throwing up an error when this is attempted?
SQL Server :: Want The User To Be Able To Select, Update, Delete, Add Data As Well As Execute Stored Procedures?
Aug 16, 2010I have built a web app and want the user to be able to select, update, delete, add data as well as execute stored procedures, I thought that I would get this from the db_datareader and db_datawriter roles but I get an error when trying to select data etcFor instance I get an error when trying to run the stored procedure ups_AddCustomer when the user has the assigned roles db_datareader & db_datawriter but it works fine when the db_dbowner but i would rather not have the page user having full access to the database.
View 1 RepliesMultiple Single-result Sql Server Stored Procedures Or Single Multple-result Stored Procedure?
Aug 9, 2010Background: I use stored procedures exclusively for an ASP.NET application. I am using a DataReader to load a dataset object.
View 4 RepliesDataSource Controls :: Stored Procedures Are Not Showing Up Correctly In The Stored Procedure Drop Down
Apr 27, 2010I am using Visual Studio 2008 and SQL Server 2008 and have added a SQL datasource to my form.
When I configure the datasource, I choose my connection string which looks like this in my webconfig:
<connectionStrings>
<add
name="PSFSPRD_ConnectionString"
connectionString="Data
The database I am using has a schema called EQB and as such, my stored procedures are named as EQB.usp_SelectFunds, EQB.usp_SelectAccount, etc.
On the select tab of the Configure Data Source screen, I choose to use a stored procedure. The dropdown shows my stored procedures, however, the schema name does not show up in front of the stored procedures in the drop down. I see only usp_SelectFunds, usp_SelectAccount, etc.
I select one of the stored procedures and when I click TEST, I get the message that the stored procedure is not found. If I instead choose to use a SQL statement instead on the configuration screen and enter EXEC EQB.usp_SelectFunds and click TEST, it works fine.
Why are my stored procedures not showing up correctly in the stored procedure drop down and how can I fix this?
SQL Server :: Stored Procedure Calling In Web.config
Mar 7, 2011Is it possible to call stored procedure in the web.config? I created the additional ID field in aspnet_membership, adding Stored procedure which stores additional information. This information I have entered in the web.config. Is it possible to call a Stored procedure in the web.config and write this information, or call the Stored procedure in C #?
View 2 RepliesADO.NET :: Calling Stored Procedure : Server Times Out
Aug 4, 2010So I just attempted to call a stored procedure from my VB code. Here is the code-behind function that is called to handle this:
[Code]....
And here is the Stored Procedure:
[Code]....
Then when I run this, I get an error that the server timed out. Without calling this function to reference the stored procedure, the application runs well, users can log in/create accounts, etc. But something in the function and/or the stored procedure is timing out.
SQL Server :: Calling One Stored Proc From Another In A Query?
Nov 2, 2010Is it possible to call 1 Stored procedure from another withing a sql query
sp1 :
select ID1,ID2,ID3,ID4 from table1 ;
sp2 :
select name from table2 where ID = ID1;
I want to get corresponding names of ID1,ID2 and ID3,ID4 in sp1 as a query result.Is it somehow possible to call sp2 from sp1?
Accessing The DB: Using Stored Procedures?
Aug 7, 2010I used to be a software tester. I am a little bit familiar with stored procedures from client-server apps. My understanding is that they are on a server (where they operate more efficiently than if they were a module of code on a client machine) and they are used to modify the database.
Can anyone give me information a nutshell about stored procedures and when to use them?
VS 2008 - Calling A Server Side Function From Javascript Without Using PageMethods?
Sep 17, 2010i have used PageMethods to access the server side functions in javascript , but now my problem is that with pagemethods your controls will not go throught the full page lifecyle and these leads me to have "Object not set for an instance of an object" error. Now can someone come with a differnt approach without using pagemethods. What i want is to call a server side function , i dont want to pass any parameters to it
View 5 Replies