[procedure] Forum Topics

Hi, Please look at my code Declare @tableName varchar(100), @total int, @sql nvarchar(2000),@id varchar(4) set @tableName='details'; set @id='C'; SELECT @sql= ' select @total = count(*) from details where id='+@id exec sp_executesql @sql, N'@total int output', @total output select @total Error: Msg 207, Level 16, State 1, Line 2 Invalid column …

Hi guys, I'm still new to .NET and your answers to my questions have been so helpful. I have another question yet again, however. This time my question has to do with sql server and handling it with code behind. I am creating a stored procedure which is supposed to …

CREATE OR replace FUNCTION fn_findraise (dept_in IN VARCHAR2, salary_in IN FLOAT) RETURN NUMBER IS salaryraise NUMBER; BEGIN IF dept_in = 'MIS' THEN salaryraise := salary_in * .10; ELSIF dept_in = 'SALES' THEN salaryraise := salary_in * .15; ELSIF dept_in = 'HR' THEN salaryraise := salary_in * .20; END IF; RETURN …

HI All, I'm writing an application in Visual Basic .NET but the application will use a SQL backend. If the user runs the application and the backend database is not set up, I want the user to select a SQL Database Instance, supply an administrator user ID (sa) and Password …

how can i link my file to this question? its cpp format

The procedure for Insert/update.I use datagridview get and display the data. I get the error message "Procedure or function Updatedata has too many arguments specified." // this is my Procedure ALTER PROCEDURE [dbo].[Updatedata] @item char(30), @uom int,@group int,@orqty int,@avgcons int,@reorder int AS BEGIN SET NOCOUNT ON; IF EXISTS( SELECT * …

For a Gridview: I am trying to use a stored procedure for the first time in a SQLDataSource for the UpdateCommand: <asp:SqlDataSource ID="TECT_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:OracleConnectionString %>" ProviderName="<%$ ConnectionStrings:OracleConnectionString.ProviderName %>" SelectCommand="SELECT MPID, User_Id, Last_Name, First_Name FROM Scripts.vw_Tect_Exam" UpdateCommand="P_TECT_UPD_EXAM_ID" UpdateCommandType="StoredProcedure"> <UpdateParameters> <asp:Parameter Name="MPID" Type="Int32" /> <asp:Parameter Name="User_Id" Type="String" /> </UpdateParameters> </asp:SqlDataSource> …

Hi, Needs to construct the tables with the meta info retrived by another stored procedure I wrote, given the table id or name. There could be some flaws in the logic, not sure. The flow is - - iterate through one table which stores tbl name, id info - pass …

i created a dll file using vb.net then it has a shared function that will execute a stored procedure of mysql but my code is something long and when accessing it, it has a big risk that it can produce an error if there is an incorrect string input, i …

Hello everyone, im doing a small program where i have a stock table with my Items and the current stock status. How do i substract from that stock status when i insert a new order in my ordertable. My tables are: STOCK: Item_ID Stock status ORDER Item_FK: Qty So i …

Ahoy, I'm having a bit of trouble executing a stored procedure using PHP's SQLSRV package thing. It's pretty much just a simple select query, with the parameters being passed through a php (it's from a property search). SqlSrv is a tough nut to crack as docuemtnation is either non existent, …

Hi All I am programming a Black Jack. I made a procedure to calculate the Score of the Cards. Here is the code: int calculatescore (int* spieler, int i0) //Der Score wird berechnet { int ausgabe; int i1; int i2; for(i1=0; i1!=9; i1++) { if(spieler[i0][i1]!=0) { i2=spieler[i0][i1]%13; if(i2>=10) { ausgabe=ausgabe+10; …

Hello, I am getting the contents on my website from database using SQL Stored Procedure (C#). Now, I want to change the output look with XML / XSLT. How can I do this? Something like this http://forums.asp.net/t/1230093.aspx/1 but am not sure how to go about it, am new to C# …

Hey guys, We recently got a couple of new staff computers over here, and I generally just pull the older HDs out, archive them in the tech closet, and throw new ones in there before reinstalling and redistributing them to less fortunate staff members. I keep the old ones in …

So I'm trying to figure out the best way (if possible) to combine these two stored procedures. Basically these are the same, the only difference is one is looking at a 'Spot' table, the other is looking at the 'Retail' table. However, in both cases the column count is the …

This Sticky Post is intended for all potential volunteers who would like to contribute to Daniweb's Viruses, Spyware and other Nasties Forum. Please be advised that this forum remains one of the last few [I][B]open[/B][/I] Anti-Malware forums on the web. By [I]open[/I], we mean that [I]anybody[/I] in the Daniweb community …

I recently moved a script I created for Google Maps over from my development site and I changed the information in the mysqli line and now I'm recieving an error mesage -- any idea what's going on here? Here's the error message: [CODE]Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user …

Hi folks, this is my first post in danniweb, please excuse me if I am in the wrong place or the thread title lacks self explanation. I am very disoriented in the field since im new in MS SQL. Before going into the problem, I'm going to give some context: …

Hi everyone, Can anyone tell my why this does not work? I created a stored procedure that uses a variable / input value as table name, but it does not do what it's supposed to do. Here is the code: [CODE] delimiter // DROP PROCEDURE IF EXISTS userpages.respondtoconnectionrequest// CREATE DEFINER …

Hi, Does anyone know on how to convert vb.net to excel. I am new in this company and they are using Microsoft SQL Server Management Studio for their database. FYI, they are using stored procedure as well. Thank you

hello, [B]Please help me to create and using mysql procedures using php scripts.[/B] I searched in web for the solution but i didn't get a perfect support from anywhere . Thanks Anoop Ravi

Dear Sir/Madam, I have a small programe created in VB 6.0 and database MS Access. Where user can insert their only name & address and can retrieve the existing records. Just for test, I have kept this programe (.exe file and database file) in the share document of a computer …

i have to show data in datagrid using store procedure...but remember...i m using store procure in seprate class so i m facing difficulties.. how to do it.. thats my class coding... but how to pass it in main form? public Searching() { Myconnection = new SqlConnection("Data Source=.;Initial Catalog=Bahria_Managment;Integrated Security=True"); } …

Hello experts, My doubt is pretty simple, I suppose. But still I need assistance. I have a registration form as ASP.NET web form. There are 5-6 fields in it (username, password, email id, sex, country etc. ). I want to enter all the data, entered by a new user in …

what is the difference between procedure and functions??

Hi! I have a vb.net project on a jump drive that connects to an Access (2003) database (located on the jump drive). My problem is when I change computers, I have to change the drive letter the jump drive is located. Currently, I have the following code and have to …

Dear friends, I'm doing a PROJECT work in ATTENDENCE... i need to check, HOW MANY DAYS employee IS ABSENT... I need a PL/SQL PROCEDURE to ACCEPT 4 DATES: DATE 1: When he gave the LETTER for LEAVE DATE 2: When he was GRANTED leave DATE 3: FROM - DATE. which …

i have code [CODE]Protected Sub btn_submitt_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_submitt.Click Try If (ddl_Country.SelectedItem.Text = "Select Country") Then Me.Label1.Visible = True Me.Label1.Text = "Please Select Country" Else Me.Label1.Visible = False Dim n As Int32 Dim connString As String = System.Configuration.ConfigurationManager.ConnectionStrings("containerConnectionString").ConnectionString Dim con As SqlConnection = New …

hi guys! it's my first post on vb.net, it's just that u can't develop on windows 7 anymore using vb6, guess we'll just have to get used-huh. i'm developing this procedure using a timer object.the thing is the procedure is not in the timer's event procedure but i want it …

I am relatively new to delphi. what i am try to do it to open a new form from the main one as a pop-up window, let the user input certain values in there (two integers and a check box), and use these values as parameters in a procedure to …