Tags → Return In Sql

Using Stored Procedures with MSSQL and ASP.NET 2.0

If you haven''t used MSSQL stored procedures before with SQL Server and in your ASP.NET 2.0 pages then you need to read this article. In this article I will list down basic questions like the following :what is a stored procedure? How can I crea...

• Categories
  • ASP.NET →
  • Tips and Tutorials
• Platforms
  • Windows
• Licenses
  • Other Free / Open Source License

Joe2Torials Admin Section

This script will allow you to have an admin section on your site which uses cookies to remember users when they return to your site. It uses MySQL to create a username and password which is encrypted and then sent into the database. When a user...

• Categories
  • PHP →
  • Scripts and Programs →
  • User Authentication
• Platforms
  • Linux
• Licenses
  • Freeware

MySQL Dialog

MySQL Dialog is a simple MySQL database access wrapper class to execute SQL queries and display the results in HTML tables. The class connects to a MySQL server, sends SQL statements, and gets the results as an array. A table with the data from the r...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Windows
• Licenses
  • Freeware

SqlCommand Class

The SqlCommand class is designed to provide a simple, effective, and yet powerful way to use Microsoft SQL Server stored procedures through PHP, with the aid of the PEAR database abstraction layer. It provides an object-oriented method of declaring a...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware

Using SUM Function in An SQL Statement

Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

Counting Records In ASP.NET

The following source code displays count of all records in a database. We will use a data command to execute an SQL statement that will return with count of records. Source code written in Visual Basic.NET can easily modify to work in an application.

• Categories
  • ASP.NET →
  • Tips and Tutorials
• Platforms
  • Linux
• Licenses
  • Freeware