Categories
Tags → Function Sql

Copy Database for SQL Server

Copy database function for MS SQL Server allows the user to create a copy of all or selected tables to another database or server. A few options like rows selection or "identity copy mode" make copy process more flexible. This handy utility...
DETAILS

DSV PHP Editor

DSV PHP Editor is a user-friendly program for creating, editing, analyzing PHP scripts, HTML, XML, Java Script, CSS, SQL pages. DSV PHP Editor is designed specifically for PHP development, it is comfortable both for beginners and experienced programm...
DETAILS

Jeply''s Gbook

GBook is a simple Guestbook. It requires PHP and SQL to function and best part is that it''s FREE! Very easy to use and free email support!
DETAILS

How to use SCOPE_IDENTITY() in ASP.NET

In this code sample we will take a look at how to use SCOPE_IDENTITY() in ASP.NET. We use this function to get new ID of inserted record from SQL database. .
DETAILS

Insert Date into Access Database

When inserting a date into an Access database you should use the format YYYY-MM-DD. Our function AccessDate returns a date in YYYY-MM-DD format. When working with a date in Access always use the # delimiters in your SQL statement.
DETAILS

Boolean to SQL Query Translator

This is a function to convert a user''s query in boolean syntax (&"hotels AND mexico NOT cockroaches) into a SQL query over the appropriate database fields.
DETAILS

Zip Code Range and Distance Calculation class

This is a PHP class to do various calculations with zip codes. It''s primary purposes are to calculate the distance between two zip codes and to extract all the zip codes that are within a range of a given zip code. All calculations are based on...
DETAILS

crackerDB

This is a very limited, barely visual database manager. Users will need to know the SQL statements to locate the necessary data within the database. A login function has been included to allow it to be published in a less-than-secure location.
DETAILS

Page:
©2003-2019 jCay.com