Search Results

Search found 8893 results on 356 pages for 'stored'.

Page 1/356 | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• Retreive a value inside a stored procedure and use it inside that stored procedure

  - by sai

  delimiter // CREATE DEFINER=root@localhost PROCEDUREgetData(IN templateName VARCHAR(45),IN templateVersion VARCHAR(45),IN userId VARCHAR(45)) BEGIN set @version = CONCAT("SELECT saveOEMsData_answersVersion FROMsaveOEMsData WHERE saveOEMsData_templateName = '",templateName,"' ANDsaveOEMsData_templateVersion = ",templateVersion," AND…

  Read the article

• SQL SERVER – Replace a Column Name in Multiple Stored Procedure all together

  - by pinaldave

  I receive a lot of emails every day. I try to answer each and every email and comments on Facebook and Twitter. I prefer communication on social media as this gives opportunities to others to read the questions and participate along with me. There is always some question which everyone likes to read and remember. Here is one of the…

  Read the article

• SQL SERVER – Select Columns from Stored Procedure Resultset

  - by Pinal Dave

  It is fun to go back to basics often. Here is the one classic question: “How to select columns from Stored Procedure Resultset?” Though Stored Procedure has been introduced many years ago, the question about retrieving columns from Stored Procedure is still very popular with beginners. Let us see the solution in quick steps. First…

  Read the article

• Stored procedure Naming conventions?

  - by Chris

  One of our senior developers has stated that we should be using a naming convention for stored procedures with an "objectVerb" style of naming such as ("MemberGetById") instead of a "verbObject" type of naming ("GetMemberByID"). The reasoning for this standard is that all related stored procedures would be grouped together by…

  Read the article

• SQL SERVER – Question to You – When to use Function and When to use Stored Procedure

  - by pinaldave

  This week has been very interesting week. I have asked few questions to users and have received remarkable participation on the subject. Q1) SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*) Q2) SQL SERVER – Puzzle – Statistics are not Updated but are Created Once Keeping the same spirit up, I am asking the third…

  Read the article

• SQL SERVER – Stored Procedure and Transactions

  - by pinaldave

  I just overheard the following statement – “I do not use Transactions in SQL as I use Stored Procedure“. I just realized that there are so many misconceptions about this subject. Transactions has nothing to do with Stored Procedures. Let me demonstrate that with a simple example. USE tempdb GO…

  Read the article

• SQL SERVER – sp_describe_first_result_set New System Stored Procedure in SQL Server 2012

  - by pinaldave

  I might have said this earlier many times but I will say it again – SQL Server never stops to amaze me. Here is the example of it sp_describe_first_result_set. I stumbled upon it when I was looking for something else on BOL. This new system stored procedure did attract me to experiment with…

  Read the article

• Better languages than SQL for stored procedures

  - by Ken Paul

  I'm getting increasingly frustrated with the limitations and verbosity required to actually commit some business logic to stored procedures, using languages such as Transact-SQL or PL/SQL. I would love to convert some current databases to Oracle and take advantage of its support for Java…

  Read the article

• Dynamically call a stored procedure from another stored procedure

  - by Greg

  I want to be able to pass in the name of a stored procedure as a string into another stored procedure and have it called with dynamic parameters. I'm getting an error though. Specifically I've tried: create procedure test @var1 varchar(255), @var2 varchar(255) as select 1 create…

  Read the article

• oracle display for every stored procedure the execution time

  - by CC

  Hi all. I'm working on a stored procedure. Inside this one, there are many call to the other stored procedures. There are a bunch of them. I was wondering if there is a option to be able to have the execution time of every stored procedure involved, every function (with a start and…

  Read the article

• SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree

  - by pinaldave

  Many years ago I wrote article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server where I demonstrated using undocumented Stored Procedure to find the drive letter in local system and available free space. I received question in email from reader asking if…

  Read the article

• Java stored procedures in Oracle, a good idea?

  - by Scott A

  I'm considering using a Java stored procedure as a very small shim to allow UDP communication from a PL/SQL package. Oracle does not provide a UTL_UDP to match its UTL_TCP. There is a 3rd party XUTL_UDP that uses Java, but it's closed source (meaning I can't see how it's…

  Read the article

• TSQL: Call a stored procedure from another stored procedure and read the result

  - by pistacchio

  Hi, I have a stored procedure that, ending with a SELECT, returns a recordset. I can call it within anoher stored procedure like this: EXEC procedure @param How to get the returning recordset? Thanks

  Read the article

• Can anyone say Stored procedures pros and cons AND Java Stored Procedures pros and con?

  - by Debuger

  Hi! Can anyone say Stored procedures pros and cons AND Java Stored Procedures pros and con? And how to test it. Best regards!

  Read the article

• Advanced Search Stored procedure

  - by Ray Eatmon

  So I am working on an MVC ASP.NET web application which centers around lots of data and data manipulation. PROBLEM OVERVIEW: We have an advanced search with 25 different filter criteria. I am using a stored procedure for this search. The stored procedure takes in…

  Read the article

• SQL SERVER – Recompile Stored Procedure at Run Time

  - by pinaldave

  I recently received an email from reader after reading my previous article on SQL SERVER – Plan Recompilation and Reduce Recompilation – Performance Tuning regarding how to recompile any stored procedure at run time. There are multiple ways to do this. If you…

  Read the article

• Creating Stored Procedures in MySQL Using HeidiSQL 4’s Stored Routine Editor

  In the "Write MySQL Queries Using HeidiSQL 4" article, we learned how to connect to a MySQL database and execute queries against it using the free HeidiSQL GUI client. Today, we'll learn how to create a stored procedure using HeidiSQL's Stored Procedure Editor.

  Read the article

• SELECT INTO or Stored Procedure?

  - by Kerry

  Would this be better as a stored procedure or leave it as is? INSERT INTO `user_permissions` ( `user_id`, `object_id`, `type`, `view`, `add`, `edit`, `delete`, `admin`, `updated_by_user_id` ) SELECT `user_id`, $object_id, '$type', 1, 1, 1, 1, 1,…

  Read the article

• tsql - using internal stored procedure as parameter is where clause

  - by vondip

  Hi all, I'm tryng to build a stored procedure that makes use of another stored proceudre. Taking its result and using it as part of its where clause, from some reason I receive an error: Invalid object name 'dbo.GetSuitableCategories'. Here is a copy of…

  Read the article

• use result set of mysql stored procedure in another stored procedure

  - by hmak

  I have a MYSQL stored procedure SP1() that returns a result set. I want to call SP1() inside of SP2() and loop through the result set of SP1() to do some additional work. I don't want to include my logic from SP1() because it would make SP2() too…

  Read the article

• Stored Procedure generator tool

  - by ManojTrek

  I am looking for tool which will generate the basic stored procedure structure (CRUD operations) for the given table, Is there any tool for the same?

  Read the article

• Retrieving data using stored procedures with LINQ to SQL in an ASP.Net application

  - by nikolaosk

  In this post I would like to present a step by step example on how to use stored procedures with LINQ to SQL. Many people will wonder why I am bothering talking about LINQ to SQL so much. First of all I give a lot of seminars where people want to…

  Read the article

• SQL SERVER – Stored Procedure Optimization Tips – Best Practices

  - by pinaldave

  We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML…

  Read the article

• What's wrong with this MySQL Stored Function?

  - by Matt

  Having trouble getting this to apply in MySQL Workbench 5.2.15 DELIMITER // CREATE DEFINER=`potts`@`%` FUNCTION `potts`.`fn_create_category_test` (test_arg VARCHAR(50)) RETURNS int BEGIN DECLARE new_id…

  Read the article

• XML Return from an Oracle Stored Procedure

  - by Tequila Jinx

  Unfortunately most of my DB experience has been with MSSQL which tends to hold your hand a lot more than Oracle. What I'm trying to do is fairly trivial in tSQL, however, pl/sql is giving me a headache. I have the following…

  Read the article

1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >