|
Welcome to SQL world on Planet Source Code! This site is one of the Internet's largest online databases of free code! You can search for particular code, simply browse by category, or just peruse! The site is filled with programs, .zip files, examples, snippets, and tutorials so feel free to jump on in! For all you masochists, here is a list of all the code in the Planet Source Code database for this world, all 31,203 lines of it!!! |
|
Introduction to PL/SQL (Series 3) Cursors
PL/SQL introduces a new dimension of power programming capability for the developer. The goal of reusable code measurely improves quality verse vast amounts of non-reusable SQL. PL/SQL packages describe function and procedure specification and body. The specification describes the package interface to the calling application. The package specification approach is part of good design. The package specification exposes procedures and their parameter properties to external applications.
Each specification has a package body. Within the package body various data structures, such as arrays and tables can be referenced, functions called, and procedures executed. Developers new to PL/SQL often understand insert, update, and delete data manipulations; but are confused about selection. This is because they don't know about cursors.
Sorting a String using T-SQL This is a User Defined Function in T-SQL for MSSQL Sevre 2000 which sorts the input string, and returns it to the caller. Optinals include sort direction (ascending/descending), sort preference(lower case / upper case preference), sort type (case sensitive / insensitive). Protecting against TSQL virii, worms and time bombs Yes, the first virus made in TSQL has been created! But even more dangerous, worms can be made applying similar but simpler techniques. What could be worse than that? Time bombs hidden somewhere in the code, waiting… This article is in PDF format. Get size in bytes of SP, View, Trigger, UDF or Rule This UDF and its equivalent stored procedure will return the size of a stored procedure, view, rule or user defined function in bytes . Extended stored procedure tutorial part I Extended stored procedure tutorial in PDF format. Rijndael Encryption SP’s/UDF’s with TSQL calling activeX These are stored procedures and functions to encrypt/decrypt data using Rijndael encryption algorithm. This is an interesting and useful example of calling COM objects with TSQL. RC4 Encryption SP’s/UDF’s with TSQL calling activeX These are stored procedures and functions to encrypt/decrypt data using the RC4 encryption algorithm. This is an interesting and useful example of calling COM objects with TSQL. How to use SOME | ANY Simple examples to show how to use SOME | ANY Access 2000: Controlling Report Data It is often the case a developer will need to create an Access 2000 reports application capable of data selection. For example, all transactions for a member. The data is input as parameters with in a form and passed to the report as query criteria. This is the simplest method to control report output resulting from user selected data criteria. Quick Start Guide To Data Mining With Naive Bayes Online guide to data mining on relational databases like SQL Server, Oracle, Ms Access using Naive Bayes Classifiers and Decision Trees Algorithm. sql2vss Scripts a sql server 2000 database, all the objects, scripts, tables, indexes to a Visual Source Safe repository. Product Moment Correlation in T-SQL A T-SQL (MSSQL) stored procedure to compute Covariance and Correlation Access 2000 Calculating Working Days This article explains how to use Access 2000 date functions when determining 1) the number of work days representing an interval between two dates 2) the projected end working date calculated from a start date and number of hours worked. using the CUME_DIST Oracle analytic function Showing how to select a N percent portion from the DATASET (top OR bottom) Visual Basic Data Mining With Naïve Bayes Version 2.0 New Release October 1, 2002: visual-basic-data-mining.net is pleased to announce the release of their visual basic data mining application. Developed with Visual Basic 6, Visual Basic Data Mining With Naïve Bayes Version 2.0 Release is designed for data mining on relational databases (RDBMSs) including Microsoft® Access®, Microsoft SQL Server®, etc. The application features a wizard driven data mining GUI guide and is available for free download with the source code at http://www.visual-basic-data-mining.net/DesktopDefault.aspx. Drop User-defined Indexes This stored procedure will drop all nominated user-defined indexes from a database. Splitting text for search purposes This is a simple, but useful, script on how to split text into a temp table. This enables you to perform different types of searches ASP Enterprise Manager This is a web-based version of Enterprise Manager for SQL Server and MSDE. An online demo is available at http://www.aspenterprisemanager.com/. This is an Open Source Project that is in the early stages, so any contributions, feedback or additions are greatly appreciated. Introduction to PL/SQL (series2) Welcome back to Introduction to PL/SQL I'll be describing Select, Insert, Update, and Delete; all the CRUID about data manipulation. ColDefinition or helping upsert SP writing Help programmers to easily build insert/update stored procedures. It will create almost all the TSQL code for you. Page 1 of 28 found. Entries 1 - 20 of 540 found Next 20 entries |