19 Resources for

stored procedure

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Create custom looping procedures in SQL Server 2005: Tim Chapman shows how to create system stored procedures that will allow you to loop through and execute statements against any type of object in SQL Server 2005. by Tim Chapman; Tags: Stored Procedure, Microsoft SQL Server, SQL, Microsoft SQL Server 2005, CLR, Exec, N, Tim, System Stored Procedure, NVARCHAR, Databases, Enterprise Software, Software, Data Management, Tim Chapman; Blog posts 2008-07-08
ActiveDB (txt): With ActiveDB you can access your SQL Server stored procedures from a .NET program with one line of code. It's like having IntelliSense on your database. Just point ActiveDB at your development database and let it generate all the stored procedure call stubs. Then give ActiveDB the actual connection string...; Tags: Stored Procedure, mfByte, ActiveDB; Software downloads 2008-06-23
Edwin (zip): Edwin is a wizard-based software application for creating Web-service based (Service Oriented Architecture - SOA) data layers from the structure of your underlying data source. All data-sources accessible via OLE-DB are supported, which includes the vast majority of popular databases. Edwin will automatically create a large set of Web methods...; Tags: Web, Stored Procedure, Record, DreamState Software, Edwin, Service-Oriented Architecture (SOA), Channel Management, Web Services, Middleware, Enterprise Software, Software, Marketing; Software downloads 2008-06-20
Stored Procedure & Views: I Want to create a stored procedure on MS VISUAL STUDIO.Then later use the stored procedure to develop a report using Crystal Report XI. How can this be Achieve this ?Bit confused hereYou mean you want to write some code to create the stored procedure in a database...; Tags: Databases, tmmokoena@..., stored procedure; Discussion threads 2007-07-27
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

Use Service Broker Internal Activation in SQL Server 2005: DBA Tim Chapman walks you through the process of building a small Service Broker application that uses Internal Activation to process messages when they are passed. In previous articles, I covered the theory behind message-based systems and introduced the components of Service Broker, the new feature in...; Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, Databases, Service Broker, Internal Activation, Service Broker application, queue, stored procedure, SQL Server Newsletter, Message, Procedure, Statement, GO, SalesQueue, Sales Strategy, XML, Enterprise Software, Sales, Software/Web Development, Web Development, Software, Data Management; Technical articles 2007-02-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
Anticipate the worst when developing SQL Server databases: Arthur Fuller advises DBAs to try to break their software in order to make sure their SQL Server databases can withstand potential attacks. See if your code can hold up to his suggested tests. A long time ago, I learned the hard way that you must anticipate the...; Tags: Microsoft SQL Server, Arthur Fuller, Databases, stored procedure, database, SQL Server Newsletter, TechRepublic Inc., Path, Enterprise Software, Software, Data Management; Technical articles 2006-09-25
Database Stored Procedures in .NET: I am having a problem using .NET to implement a stored procedure for inserting a row into a database. FYI, I am using C# and SQL Server. None of the code examples in MSDN show the specific table that is being accessed. What parameter of what object do I set...; Tags: .net, database, Microsoft .NET, M_a_r_k, programming, stored procedure; Discussion threads 2005-11-15
Debugging stored procedures in SQL Server's Query Analyzer: When Arthur Fuller learned that one of his colleagues was unaware that there was a debugger built into SQL Server's Query Analyzer, he figured that other developers may be in the dark about this great feature. Find out how to get the most benefit out of the debugger. While...; Tags: Arthur Fuller, Mice, Databases, Programming languages, Microsoft development tools, Microsoft SQL Server, server, debugger, Query Analyzer, Object Browser, stored procedure, SQL Server Newsletter, TechRepublic Inc., Procedure, Enterprise Software, Hardware, Peripherals, Software, Data Management; Technical articles 2005-07-01
Call multiple trigger bodies with a single trigger: Within a single schema, a table or view can only have triggers of each of the four main types defined: before row, after row, before statement, and after statement. See how you can avoid that kind of conflict. TechRepublic's Oracle newsletter covers automating Oracle utilities, generating database alerts, solving...; Tags: Databases, Scott Stephens, Programming languages, trigger, ROWTYPE, PL/SQL, stored procedure, Oracle Tips Newsletter, TechRepublic Inc., Problem, Table, Listing C, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Technical articles 2005-05-10
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
JOIN table and stored procedure: Is is possible to JOIN a table and the results of a stored procedure (ANSI SQL, Oracle, MySQL or SQL Server)join...You would have to put the results of the stored proc in at least a temp table, then do the join. Is that what you are looking for? ...; Tags: Databases; Discussion threads 2005-02-25
MySQL and stored procedures: MySQL is "The World's Most Popular Open Source Database," at least according to the MySQL Web site. But in spite of this popularity many corporations are resistant to adopting MySQL. There are several reasons for this, from the misguided belief that open source is the software equivalent of a child’s...; Tags: Databases, OPEN SOURCE, Edmond Woychowsky, MySQL, stored procedure; Technical articles 2004-04-06
Application Development: SQL Server "Yukon" and CLR integration: If you're a Microsoft programmer, you have probably invested quite a lot in the transition from Windows NT/SQL Server 7 to Windows 2000/SQL Server 2000. The transition to Longhorn/Yukon is going to require a similar investment. Enhancements to SQL Server Yukon will include more complex reporting services and better handling...; Tags: .NET, Application servers, Programming languages, Middleware, Databases, Development tools, CLR, application development, Sanders Kaufman, Jr., server, stored procedure, Yukon, Microsoft .NET, SQL, Microsoft SQL Server; Technical articles 2004-03-16
Easily handle Web app list data with this simple database function: I once worked on a project to convert a discontinued enterprise resource planning ERP system into a Web-based application because the original system would not work on our Windows XP desktop machines. The original, off-the-shelf system was designed to be customized to fit each client. For the Web-based version, our...; Tags: Development tools, Application servers, Databases, database, stored procedure, Allaire ColdFusion, server; Technical articles 2003-03-26
ADO tips: Firehose cursors and raising errors from stored procs: Tweak your ADO code for more efficiency with these two VB tips. Find out how to use a firehose cursor and how to raise errors from stored procedures.Working with ActiveX Data Objects ADO is a core part of many VB6 applications. Try these two ADO tips to tweak your VB...; Tags: Microsoft development tools, Databases, John Welch, stored procedure, ActiveX Data Objects; Technical articles 2002-12-04
Increase SQL Server stored procedure performance with these tips: Database developers often use stored procedures to increase performance. Here are three tips to help you get the most from your SQL Server stored procedures. We've even thrown in a bonus performance tip for counting records without accessing a table.Developers often take advantage of stored procedures to enhance the performance...; Tags: Performance management, Databases, server, Kevin Brown, stored procedure, Use NOCOUNT, database, performance, Microsoft SQL Server; Technical articles 2002-03-05
Database management through stored procedures: Joe Barnes describes how to use and create stored procedures to manage your database.What are stored procedures? Are they database queries? Sometimes. Are they used by DBAs database administrators or DBOs database owners? Sometimes. So, what are they? The best description I’ve found for a stored procedure is that it’s...; Tags: Databases, Storage, Joe Barnes, database management, database, Microsoft SQL Server, Query Analyzer, stored procedure, server, Microsoft Corp., Microsoft SQL Server 7.0; Technical articles 2000-02-07

Additional Resources

VB6 Data Report calling SQL stored procedure: I have a VB6 data report with a data environment DE where the DE command properties list a stored procedure that exists and works fine. The stored proc has 2 parameters which are defined in the DE. I invoke the report by clicking a name in a combo box. The...; Tags: Programming languages, rcox@..., SQL, data environment, Microsoft Visual Basic 6.0; Discussion threads 2007-05-09

<< Previous
page 1 of 1
Next >>

Content Types

Blog posts (1 results)

Discussion threads (6 results)

Software downloads (2 results)

Technical articles (10 results)

Stored Procedure Jobs

Help Desk Trouble Ticket Form: The Help Desk Trouble Ticket is an important document for the technical support professional. This form contains all the essential fields for maintain ...; Buy Now

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now