Categories
Tags → Sql Using

Counting Records in SQL Script

Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.
DETAILS

Replacing single quotes in SQL scripts

Single quote could be very harmful and broke down your all application. Any one can easily inject any damageful code into your sql script. To combat the threat of SQL injection, escape the single quotes using the Replace function.
DETAILS

dating.NET

This is a simple dating web application written in ASP.NET using VB.NET with a MySQL backend, which is usually a cheaper option than Microsoft SQL Server. It has all the typical features of a dating website including multiple-photo profiles, messagi...
DETAILS

CyberD LinkDump

A simple linkdump script using an SQL database to store links
DETAILS

phpSkelSite

phpSkelSite is a small PHP-MySQL based skinnable website skeleton that I wrote to test WireFrame logic in a Web Application I needed urgently. It is to be used only in a trusted LAN environment as a simple Web Application framework. It is very well...
DETAILS

IP Address to Country, Region, City, ISP and domain name in PHP

This is PHP script to enable lookup of country, region, city, latitude, longitude and ZIP Code from IP address by using IP2Location database. The script supports several database types such as Microsoft Access, MS SQL and mySQL. Internet geolocation...
DETAILS

IP Address to Country, Region, City, ISP and domain name in ASP.NET

This is ASP script to enable lookup of country, region, city, ISP and domain name by using IP2Location database. The script supports several database types such as Microsoft Access, MS SQL and mySQL. Internet geolocation has been widely used in...
DETAILS

InfoCaptor : Dashboard Designer and Viewer

A tool that allows users to create dashboards using simple SQL query and helps the user to organize their frequently used SQL queries. InfoCaptor is a Rapid Development tool that helps you create, manage and publish Dashboards ( Views ). InfoCapto...
DETAILS

IP Address to Country, City, Latitude, ISP and Domain Name in ASP

This is ASP script to enable lookup of country, region, city, latitude, longitude, ISP and domain name from IP address by using IP2Location database. The script supports several database types such as Microsoft Access, MS SQL and mySQL. Internet geo...
DETAILS

IP Address to Country, City, Latitude, Longitude and ZIP Code in PHP

This is PHP script to enable lookup of country, region, city, latitude, longitude and ZIP Code from IP address by using IP2Location database. The script supports several database types such as Microsoft Access, MS SQL and mySQL. Internet geolocation...
DETAILS

Page:
©2019 A--9.com