Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- text box values as parameters in Stored Procedures???
- Hello,I am using asp.net in Visual Studio 2005. I am trying to get a value from a text box to use as the parameter in a stored procedure. The stored procedure would run and then display the results in the next page. I have googled and checked forums but can...
- Tags: nuSkool, programming, asp.net 2.0, grid, stored procedures
- Discussion threads 2007-01-05
- grrr, MySql stored procedures and Perl
- Ok, I have created a analysis database on my home server to track idiots that constantly try to brute force my home file server. All my development on my home machine is done in Perl 5.8. I installed the latest version of MySQL because I read about t
- Tags: stored procedures, programming, mysql, droolin, Perl, stored procedure, SELECT tb_FH.IP
- Discussion threads 2006-12-11
- Simplify your code with MySQL transactions and prepared queries, and the Perl DBI
- It would have been nice if Stored Procedures were used/shown in the articleStored procedures would have simplified the transaction example I believe. They do work with Perl, at least until you try to return multiple rows that is(at least I can'
- Tags: Scripting languages, Programming languages, Development tools, droolin, Stored Procedures
- Discussion threads 2006-11-29
Additional Resources
- A couple of MySQL stored procedures myths get busted
- Two often repeated myths about MySQL stored procedures include (1) MySQL does not support stored procedures and (2) MySQL stored procedures are too difficult to work with under typical circumstances. This tutorial busts those myths and shows you how easy it is to implement stored procedures in your database using...
- Tags: MySQL, Open Source, Databases, Enterprise Software, Software, Data Management
- Download resources 2007-06-29
- Using .NET Stored Procedures in Oracle
- For a .NET developer, one of the most exciting features of Oracle Database 10g Release 2 for Windows is the ability to implement stored procedures using the .NET language of his or her own choice, via Oracle Database Extensions for NET. In this paper, the reader will learn a step-by-step...
- Tags: Procedure, Oracle Corp., .Net, Application Servers, Middleware, Software Development, Software/Web Development, Enterprise Software, Software
- White papers 2005-11-01
- Can I get a clear idea about stored procedures
- where Can I get a clear idea about stored procedures..More information pleaseWhat kind of procedures? What kind of storage?SQL Stored proceduresin SQL, stored procedures are like 'macros' that run on the server as opposed to the client. Is this what you mean?Have you had a look at the sql...
- Tags: Programming languages, Databases, msundar82@..., SQL
- Discussion threads 2007-07-16
- MySQL 5.0 Stored Procedures: MySQL 5.0 New Features Series - Part 1
- A stored procedure is a procedure like a subprogram in a regular computing language that is stored in the database. Correctly speaking, MySQL supports "Routines" and there are two kinds of routines: stored procedures which a person calls, or functions whose return values are used in other SQL statements the...
- Tags: Procedure, MySQL, MySQL 5.0, Open Source, Databases, Enterprise Software, Software, Data Management
- White papers 2005-03-01
- Recovering just the stored procedures in a local database
- We use many stored procedures, and they are located in the local database, not the master.Is there a way to restore from backup a subset of the stored procedures without restoring the entire database?
- Tags: Storage, Databases, dave@..., stored procedure, database
- Discussion threads 2007-05-24
- Visual Basic .NET Code Sample: Use Stored Procedures (exe)
- This application demonstrates how to programmatically create and use stored procedures with ADO .NET and Microsoft SQL Server. The use of a query (a.k.a., stored procedure) in a Microsoft Access database is also demonstrated. This version is the first release on CNET Download.com.
- Tags: Microsoft Visual Basic, Microsoft Corp., Microsoft Visual Basic.Net, Microsoft Development Tools, Programming Languages, .Net, Databases, Microsoft Office, Development Tools, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Office Suites
- Software downloads 2007-09-07
- Stored Procedures, UDFs and Triggers - Common Logic or Common Problem?
- DB2 Stored Procedures, user-defined functions, and triggers are becoming more prevalent on the mainframe, and can be part of a valuable implementation strategy. Use of these advanced database objects dramatically extends the capabilities of the database, and can be a performance benefit - or a performance problem - for distributed...
- Tags: Performance, Compuware Corp., Performance Management, Databases, Human Resources, Workforce Management, Enterprise Software, Software, Data Management
- Webcasts
- EZStoredProc (exe)
- EZStoredProc generates stored procedures. Simply right-click to generate stored procedures for databases and tables. Execute stored procedure script directly from EZStoredProc. Option to use identity field and/or primary key fields in where clause. Generate grant execute statement for each stored procedure. Return identity value from table.
- Tags: Procedure, Identity, EZStoredProc
- Software downloads 2006-08-25
- Accessing Oracle 9i Stored Procedures Using ADO.NET
- The Oracle .NET data provider makes it easy to execute stored procedures and access the return values, whether they are one or more scalar values or result sets. You can use Oracle procedures together with the OracleDataAdapter to fill a DataSet, work with the disconnected data, and update the changes...
- Tags: Procedure, Oracle Corp., Microsoft ADO.NET, Oracle9i, Programming, .Net, Development Tools, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- White papers 2004-04-01
- Crystal Report v. 11 vs. SQL 2000 Reporting Tool
- What tool is more effective and advantageous in writing stored procedures report? Crystal Report v. 11 or SQL 2000 Reporting Tool?I'd vote for Crystal 11SQL 2000 reporting is just above version 1.x, it is very limited on features, depending on the complexity of your reporting requirements it may do just...
- Tags: Programming languages, Databases, Crystal Report, SQL 2000 Reporting Tool
- Discussion threads 2006-04-27
- A couple of MySQL stored procedures myths get busted
- Check out PostgreSqlMySql has come a long way in the past few years, but I'm wondering why it is so much more popular than Postgres in the open source community. Postgres has had advanced features like stored procedures, views, transactions, etc. years before MySql. Postgres also uses the...
- Tags: OPEN SOURCE, Databases, pointzerotwo@..., MySQL, Postgres
- Discussion threads 2007-07-11
- SQL Replication
- Just wondering if you can help me out with something or give me some tips. I am creating a SNAPSHOT and Transactional replication to various sites. My co-workers don't think it will be possible to put the stored procedures into the Publication because of this: if they need to...
- Tags: collazo21@..., hardware, Publication, SQL
- Q&A 2005-05-12
- Dynamic Import of Excel?
- Sorry for the duplicate post, but I didn't see the question section and I would really like a targeted response and not just a discussion. What I really need is to accomplish this without manual intervention, for the table to be populated automatically. What's the best way to accomplish this,...
- Tags: bill.bowman@..., Microsoft Excel
- Discussion threads 2007-10-09
- Utilize MySQL's features through .NET
- Your listings are wrong!The link to Listing B is Listing AThe link to Listing C is Listing BThe link to Listing D is Listing Cetcetcetc...The listings have been correctedWe've updated the listings. Thanks for bringing this to our attention!Mary WeilageNewsletter EditorLack of stored procedures IS a show-stopper!. . . and...
- Tags: devGuy, Listing B, Microsoft .NET, MySQL, programming, stored procedure
- Discussion threads 2005-05-04
- Copying Numerous Stored Proc by Script
- I'm a novice SQL admin and I'm wanting to backup some databases to a flat file. To do this I need to copy quite a few stored procedures from the msdb database to each db I want to backup. How can I do this quickly? Right now...
- Tags: database, db, programming, smittyrt@...
- Q&A 2004-12-07
- Database Naming Standards
- In the late 80s, the only naming standard I saw for database objects were vague ones like 'tbl' for table, 'qry' for query. I noticed that these were pretty useless when you would get a list of about fifty tables and a few hundred stored procedures. For tables,...
- Tags: mattohare@..., database
- Discussion threads 2007-04-04
- Exchange Data Using Arrays in SQL PL: New Capabilities for Exchanging Data Between Applications and Stored Procedures
- IBM DB2 9.5 for Linux, UNIX and Windows introduces support for array data types in SQL Procedural Language SQL PL. In addition to being useful as a data structure to develop algorithms, arrays are particularly useful in SQL PL as a vehicle for exchanging collections of data between applications and...
- Tags: Array, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- White papers 2007-10-25
- << Previous
- page 1 of 1
- Next >>
