Search DaniWeb - sp

Re: Design vs. Coding 2 Months Ago by cored0mp … your allusion to the need to make application components disassembleable (sp?) and find your choice of plumbing perhaps apt. Perhaps you… Re: Connect and call SP in MS SQL 2000 14 Years Ago by romanne …); try { conn.Open(); SqlCommand getRequestCmd = new SqlCommand(SP, conn); getRequestCmd.CommandType = CommandType.StoredProcedure; getRequestCmd.CommandTimeout =…); try { conn.Open(); SqlCommand getRequestCmd = new SqlCommand(SP, conn); getRequestCmd.CommandType = CommandType.StoredProcedure; getRequestCmd.CommandTimeout =… mssql_query() problem calling SQL Server Project (SP) 15 Years Ago by culebrin … 2005 database, inside this SP I have a call to another SP which inside calls to a SP in another Database Server (SQL… need to know how to resolve this, I need that SP to work on my PHP app. So any thoughts are… Problems with SQL SP 15 Years Ago by Ole Raptor … uses a Stored Procedure to create a report. Unfortunatly the SP has a problem in the VB6 code. The program could… problem but found the solution. Parameter Sniffers. I updated to SP on the second machine and I can run the report… problem. But after I update on the Live machine the SP takes well over 3 minutes to return the data. Anybody… Re: Problems with SQL SP 15 Years Ago by Ole Raptor I had changed the sp a bit and got it to … 1 AS SET NOCOUNT ON --Remainder of SP [/code] The SP in Management Studio ran great but using VB6 …took forever. I updated the SP to the following. [code=sql] ALTER PROCEDURE [dbo… SET @IncludeVoid1 = @IncludeVoid SET @IncludeDisc1 = @IncludeDisc --Remainder SP [/code] IE hijacked-> res://sp.html#96676 19 Years Ago by Astial …\Main,Search Page = res://C:\WINDOWS\lrqxr.dll/sp.html#96676 R0 - HKCU\Software\Microsoft\Internet Explorer\…\Main,Search Page = res://C:\WINDOWS\lrqxr.dll/sp.html#96676 R1 - HKLM\Software\Microsoft\Internet Explorer\… Explorer\Main,Default_Search_URL = res://C:\WINDOWS\lrqxr.dll/sp.html#96676 R1 - HKCU\Software\Microsoft\Windows\CurrentVersion\… Re: IE hijacked-> res://sp.html#96676 19 Years Ago by crunchie …\Main,Search Page = res://C:\WINDOWS\lrqxr.dll/sp.html#96676 R0 - HKCU\Software\Microsoft\Internet Explorer\…\Main,Search Page = res://C:\WINDOWS\lrqxr.dll/sp.html#96676 R1 - HKLM\Software\Microsoft\Internet Explorer\…Microsoft\Internet Explorer\Main,Default_Search_URL = res://C:\WINDOWS\lrqxr.dll/sp.html#96676 O2 - BHO: (no name) - {683DA086… Re: Problems with SQL SP 15 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 5 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 15 Years Ago by odysseous … everybody, I have a ntext problem. There are MS SQL SP in my project.And I am taking mssql_bind() warning and… that I cannot make changes on these SPs. Because these Sp are used by other programmers who are using cold fussion… Cann't see hidden files and folders in Windows XP, SP-2 15 Years Ago by java_programmer I have Windows XP, sp-2 installed in my laptop. I have stored personal file …, which is root user. 2. The OS is Windows XP, SP-2. Thanks in advance... Connect and call SP in MS SQL 2000 14 Years Ago by romanne … new SqlConnection(connectionString); try { conn.Open(); SqlCommand getRequestCmd = new SqlCommand(SP, conn); getRequestCmd.CommandType = CommandType.StoredProcedure; getRequestCmd.CommandTimeout = commandTimeout; SqlDataReader …didnt encountered error but i think it didnt call the SP since in the logs it only says: 'Getting Data… incorporate the UDF functionality into the Sp 14 Years Ago by vuyiswamb Good Day All I have an Sp and UDF. the UDF cant take #tables. so i want … C.IDL = MTN.ID END [/code] and later in my Sp i have this line of statement [code] SELECT DESCR, dbo… Re: Cann't see hidden files and folders in Windows XP, SP-2 14 Years Ago by sanjitsrivastav [QUOTE=java_programmer;821285]I have Windows XP, sp-2 installed in my laptop. I have stored personal file …, which is root user. 2. The OS is Windows XP, SP-2. Thanks in advance...[/QUOTE] Ans- Just go to start… Re: Cann't see hidden files and folders in Windows XP, SP-2 14 Years Ago by karthickj25 [QUOTE=java_programmer;821285]I have Windows XP, sp-2 installed in my laptop. I have stored personal file …, which is root user. 2. The OS is Windows XP, SP-2. Thanks in advance...[/QUOTE] it may be a virus… Check if record exists using SP & return value if it does 11 Years Ago by while(!success) … = true; I want to store the returned value of the SP in a variable in the code behind so that I… your time and help. ***EDIT*** I have been testing my SP and it *seems* to work as I want because PlayerID… Re: Connect and call SP in MS SQL 2000 14 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 14 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 14 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 11 Years Ago by while(!success) … execute Read(), will that pull that Return value from my SP? Is it at all possible to assign the value to… shopping cart problems - xp sp 2 19 Years Ago by dandimmitt … I have a problem with a laptop with windows xp sp 2. whenever I try to add something to the cart… Pass XML File as Parameter to SP and read it 16 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 16 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 15 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 @… Vista Ultimate SP 2 Turns Off Aero Service 14 Years Ago by RamonLThomas … services operating correctly. Following the automatic updates to Vista Ultimate SP 2 and Explorer 8, I can no longer get my… Help with the Following SQl SP 14 Years Ago by vuyiswamb … Close TmpCur Deallocate TmpCur return (@RetStr) END [/code] and my sp i conbine this and Call it like this [code] Select… Using a SP to insert only new rows in SQL Server 14 Years Ago by adamf07 … I generate the XML string and pass it into the SP. It runs with no (visible) errors, but when I look… calling SQL SP from Excel (macro) 14 Years Ago by flashkarni … code that imports a table, but not to execute a SP or a function. heres my code: [code] Sub DataExtract() ' Create… Re: calling SQL SP from Excel (macro) 14 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) 14 Years Ago by flashkarni [QUOTE=vb5prgrmr;1192326]If a SP returns some sort of results (T/F, recordset) then use …