Search DaniWeb - sp1

Re: Connect and call SP in MS SQL 2000 15 Years Ago by romanne SP: [CODE][COLOR="Red"]create procedure SP_getdata as set arithabort off declare @date1 datetime, @date2 datetime create table #tmptable ( data1 char(04) null, data2 char(03) null, data3 char(03) null, .. data35 char(50) null ) INSERT INTO #tmptable… mssql_query() problem calling SQL Server Project (SP) 16 Years Ago by culebrin I have a SP (sp_test_procedure) created from a SQL Server Project in my SQL Server 2005 database, inside this SP I have a call to another SP which inside calls to a SP in another Database Server (SQL 2000) through a cross-linked connection. When I execute it from the Management Studio it works just fine. But when I call from my PHP app It gives … Problems with SQL SP 16 Years Ago by Ole Raptor I have a program that uses a Stored Procedure to create a report. Unfortunatly the SP has a problem in the VB6 code. The program could pull the information perfectly until 2 days ago. Now the program times out after 60 seconds after sending the params to the sp. I can run the sp in Management Studio and it takes approx. 3 seconds to pull 88 rows. … Re: Problems with SQL SP 16 Years Ago by Ole Raptor I had changed the sp a bit and got it to work in the program. It now takes about 10 seconds program side to run the report. This is the original problem. [code=sql] ALTER PROCEDURE [dbo].[MAR] @PatientID int = 0, @FacilityID int = 0, @IncludeVoid bit = 0, @IncludeDisc bit = 1 AS SET NOCOUNT ON --Remainder of SP [/code] The … IE hijacked-> res://sp.html#96676 20 Years Ago by Astial …:48:11 PM, on 6/29/2004 Platform: Windows XP SP1 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00… SP1 (6.00.2800.1106) Running processes: C:\WINDOWS\System32\smss.… Re: IE hijacked-> res://sp.html#96676 20 Years Ago by crunchie [list=1][*]Make sure your settings allow you to view "Hidden files". Open up any explorer windows and click on "Tools" => "Folder Options" => "View" and be sure to check off "Show Hidden Files and Folders". Uncheck the Hide protected operating system files option. [*]Press Ctrl+Alt+Delete … Re: Problems with SQL SP 16 Years Ago by Ramy Mahrous If it's not confidential, you can show us the SP to see if we can optimize it. I think in connection string you can specify the time out value play with it, it may solve the problem on the first machine. exec sp from another SP 6 Years Ago by Menzk I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset PHP+ SQL server 2005 SP problem 16 Years Ago by odysseous Hi everybody, I have a ntext problem. There are MS SQL SP in my project.And I am taking mssql_bind() warning and mssql_execute() error. But the problem is that I cannot make changes on these SPs. Because these Sp are used by other programmers who are using cold fussion as programming language. Thus I could not use cast trick. What can I do? Has … Cann't see hidden files and folders in Windows XP, SP-2 16 Years Ago by java_programmer I have Windows XP, sp-2 installed in my laptop. I have stored personal file as hidden file and set the properties 'do not show hidden files and folders' on as anyone else can't see the files. But when I tried to disable this feature and enable the feature 'show hidden files and folders' and click the apply button, it is not working. The hidden … Connect and call SP in MS SQL 2000 15 Years Ago by romanne Hi, Im new in C#, could you help with my codes. I need to connect to MS SQL DB (2000) and need to call Stored Proc to return value. Here is my codes: [CODE][COLOR="Green"]private void ExecuteStoredProcs() { SqlConnection conn = new SqlConnection(connectionString); try { conn.Open(); SqlCommand getRequestCmd = new … incorporate the UDF functionality into the Sp 15 Years Ago by vuyiswamb Good Day All I have an Sp and UDF. the UDF cant take #tables. so i want to incorporate the functionality that is being provided by the udf and make it part of the code. the first part of my statement creates a solid table that is being used in the UDF [code] truncate table temp INSERT INTO temp SELECT MTN.ID,S.DESCR,ISNULL(MTN.CYCLETEMPLATE,C.… Re: Cann't see hidden files and folders in Windows XP, SP-2 15 Years Ago by sanjitsrivastav [QUOTE=java_programmer;821285]I have Windows XP, sp-2 installed in my laptop. I have stored personal file as hidden file and set the properties 'do not show hidden files and folders' on as anyone else can't see the files. But when I tried to disable this feature and enable the feature 'show hidden files and folders' and click the apply button, it … Re: Cann't see hidden files and folders in Windows XP, SP-2 15 Years Ago by karthickj25 [QUOTE=java_programmer;821285]I have Windows XP, sp-2 installed in my laptop. I have stored personal file as hidden file and set the properties 'do not show hidden files and folders' on as anyone else can't see the files. But when I tried to disable this feature and enable the feature 'show hidden files and folders' and click the apply button, it … Check if record exists using SP & return value if it does 12 Years Ago by while(!success) 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 check if a record exists in the table and if it does, return a value so that I may … Re: Connect and call SP in MS SQL 2000 15 Years Ago by sknake What does your SP do? Does it return a cursor (does it have a Select query inside of it?) or are you just trying to get the integral return value of the sproc? Re: Connect and call SP in MS SQL 2000 15 Years Ago by romanne Hi Sknake, Theres an insert into in the SP that i need to call. Re: Connect and call SP in MS SQL 2000 15 Years Ago by romanne I also need the data that i get in my SP and i declare the per data in an array... like this one: data_1 = array[1 - 1]; data_2 = array[2 - 1]; and so on.... Re: Check if record exists using SP & return value if it does 12 Years Ago by while(!success) JorgeM, In regards to your example, when you execute Read(), will that pull that Return value from my SP? Is it at all possible to assign the value to a variable in my code behind? For instance: int retValue = (value returned from stored procedure); //then i could do if (retValue == 1) { label.Visible = true; } … shopping cart problems - xp sp 2 20 Years Ago by dandimmitt hello folks I have a problem with a laptop with windows xp sp 2. whenever I try to add something to the cart and go to checkout, I find out that there is nothing in the cart. I have the pop up window blocker turned off. I am using the firefox browser with norton internet security. I called somebody at one site, and was told to turn off the … Pass XML File as Parameter to SP and read it 17 Years Ago by sandy_b76 Hi, I need to Pass XML File as Parameter to SP and read it and store the tag value in variables. Any example for the same is preferred. Thanks Passing XML file to SP 17 Years Ago by bmantri Hello DBAs, Do you have any idea about the XML file used in SP. I want to pass it as input parameter. Thanks, BMantri error while executing SP 16 Years Ago by hanuman308 i want to add column in a table through following SP [code=sql]create procedure sp_addCol @tablename varchar (50) as DECLARE @tsql_TZ varchar (200) SET @tsql_TZ = 'ALTER TABLE [ '+@tablename+'] ADD timezone varchar (5)' EXEC(@tsql_TZ)[/code] whenever i try to execute this through EXEC sp_addcol 'MGV10SEP_MNPC_MNLD' ' it shows me the error … Vista Ultimate SP 2 Turns Off Aero Service 15 Years Ago by RamonLThomas My Dell Inspiron 1505 previously ran Vista Ultimate SP1 with all the aero services operating correctly. Following the automatic … Help with the Following SQl SP 15 Years Ago by vuyiswamb Good day All I have a Challenge. I have the Following StoredProcedure that is doing the Following [code] IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[temp]')) drop table [temp] --Creation of Temp1 SELECT MTN.ID,S.DESCR,ISNULL(MTN.CYCLETEMPLATE,C.CYCLES) AS CYCLETEMPLATE into temp FROM TBL_STAFF S INNER… Using a SP to insert only new rows in SQL Server 15 Years Ago by adamf07 Hey all, I'm trying to insert a bunch of rows from an xml document into an SQL database. I have a stored procedure that I'm calling from my program after I generate the XML string and pass it into the SP. It runs with no (visible) errors, but when I look at the table, no new rows have been inserted. I'm really stumped, as I'm fairly new to SQL … calling SQL SP from Excel (macro) 15 Years Ago by flashkarni hello all, i am new to VB. i am trying to execute SQL Stored procedures from a macro in excel. but i fail to do so. i managed to write a code that imports a table, but not to execute a SP or a function. heres my code: [code] Sub DataExtract() ' Create a connection object. Dim cnPubs As ADODB.connection Set cnPubs = New ADODB.connection ' Provide … Re: calling SQL SP from Excel (macro) 15 Years Ago by vb5prgrmr If a SP returns some sort of results (T/F, recordset) then use a recordset as you are. If it just does something use a command object... Good Luck Re: calling SQL SP from Excel (macro) 15 Years Ago by flashkarni [QUOTE=vb5prgrmr;1192326]If a SP returns some sort of results (T/F, recordset) then use a recordset as you are. If it just does something use a command object... Good Luck[/QUOTE] thanks for the response, i am using a command object, and when i run the vb script i get a message saying: OLE DB command object is not supported by the … Loading OS XP Prof SP-II 13 Years Ago by P.manidas Dear Sir/Madam, Recently, i got a problem on loading OS XP professional SP-II. I have installed the OS bringing my Hard Disk into another computer where with my Hard Disk's OS is running smoothly. But when i installing the same Hard Disk into my computer it is not loading the OS. It is saying that run in safe mod, safe mode in command prompt, …