View Complete Post
[UserID] = @UserID
I work for a software manufacturing company and I am doing a project for a very large potential customer. This customer has a SQL Server 2008 DB and claims that his emplpyee's can only access the DB (read or write) using a stored procedure.
Now the catch is we cant re-write the software to accomidate this customer, and our requests to see the stored procedure to see how hes using it have failed. But I need to be able to access his DB at no additional cost to the customer. Is there
any way to call a SP using a Data Source Driver? Or any other ideas, I need an answer for this cutomer today :(
I have created a CLR stored procedure that invokes the CRM Web service to delete records, the code complies fine but when I try to deploy it it just times out. I feel that I am missing something, has anyone any suggestions.
There are a number of blogs about the subject of invoking Web services from a CLR stored procedure but they are about doing it in 2005, is the procedure the same?
I have a stored procedure insertXXX that has one OUTPUT parameter of type numeric. The stored procedure looks like:
PROCEDURE [dbo].[insertIntoTable]@outputID AS numeric OUTPUT
I will really appreciate if someone can post step by step process to call an Oracle Stored Proc from SSIS. Here is the Stored Proc Spec:
ÃÂ ÃÂ ÃÂ PROCEDURE Interface_Begin
ÃÂ ÃÂ ÃÂ (p_from_dttmÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ OUT varchar2,
ÃÂ ÃÂ ÃÂ ÃÂ p_error_codeÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ OUT number,
ÃÂ ÃÂ ÃÂ ÃÂ p_error_textÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ OUTÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ varchar2,
ÃÂ ÃÂ ÃÂ ÃÂ p_proc_nameÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ OUT varchar2);ÃÂ ÃÂ
I have 2 tables:
(1) tblSpecies with Columns ID int, Code nvarchar(50), Description nvarchar(50)
(2) tblSpeciesCrossReferenceCodes with Columns ID int, SpeciesCode nvarchar(50), etc. etc.
I want to invoke the following procedurewith 3 input parameters in Paged GridView.
When I test this procedure under ServerControl with the value of @SpeciesCode ="APQ"
I get the error:
" Invalid Column Name APQ."
This points to the statement:
WHERE (X.SpeciesCode LIKE ' + @SpeciesCode + '))
I would be grateful if an Expert could tell why I should I
get this message and where am I going wrong?
ALTER PROCEDURE [dbo].[StoredProcedureFilterXCodes] ( @startRowIndex int, @maximumRows as int, @SpeciesCode as nvarchar(50) )AS
IF @SpeciesCode IS NULL EXEC dbo.GetSpeciesCrossReferenceCodes @startRowIndex, @maximumRowsELSE
SET @startRowIndex=@startRowIndex+1 DECLARE @sql nvarchar(4000)
SET @sql = 'SELECT ID, PresentationCode, StateCode, FreshnessCode, SizeCode, Sp
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" />