A collection of 10 tutorials for you to get started quickly with running Transact-SQL statements on SQL Server 2005. Clear examples are provided for running CREATE TABLE, INSERT, UPDATE, DELTE, SELECT, CREATE USER, GRANT EXECUTE statements. Topics included in this collection are:
How to use Transact-SQL statements to access the database engine?
How to create new databases with "CREATE DATABASE" statements?
How to create new table with "CREATE TABLE" statements?
How to insert and update data into a table with "INSERT" and "UPDATE" statements?
How to read data in a table with "SELECT" statements?
How to create a login to access the database engine using "CREATE LOGIN" statements?
How to create a user to access a database using "CREATE USER" statements?
How to create a view and a stored procedure using "CREATE VIEW/PROCEDURE" statements?
How to grant a permission using "GRANT EXECUTE" statements?
How to delete database objects with "DROP" statements?
Category:
SwisSQL - Sybase to Oracle Migration Tool helps you migrate Sybase Adaptive Server Transact-SQL Procedures, Views and Triggers to Oracle PL/SQL language. When enterprises migrate from Sybase to Oracle, application migration is one of the tedious tasks and there are no good tools which can ease the process of migrating Sybase Stored Procedures to Oracle PL/SQL. Using SwisSQL - Sybase to Oracle Migration Tool and through AdventNet's superior support, enterprises can realize significant time and cost savings during the migration and testing process.
Category:
Smart Report Maker is an easy-to-use PHP/MySQL report generator, it allows you to create and manage unlimited number of MySQL Reports based on tables or queries, it’s friendly wizard style interface allows you to select only the Tables and fields which you like to view on your report, Set Multiple grouping levels, sort the data ascending or descending , define table relationships to create reports based on multiple tables, export reports to PDF, XML OR CSV files , the ability to send generated reports by email from within the script and Mor
Category: