SQL

• SQL Insert
• SQL Update
• Trucate
• Rename a Database stored procedure
• Copy one database column to another
• Copy a table from one database to another - SQl 2005
• Check if table exists in a database
• Add New Column After another
• Copy a table from one database to another - SQl 2000
• Truncate All Tables with SQL Server
• Search All tables for keyword - Stored Procedure
• Alter Table
• Add Primary Key
• Create Table
• Delete table contents
• Drop (Delete) Table
• Cross table update - MySQL
• Import CSV into MySQL
• SQL Version & Service Pack
• Find SQL Language and Date format
• Insert Multiple Records in one query
• Add New table and copy data from existing table
• Get Last Inserted ID (MySQL)
• Export MySQL to text file
• Change single user table back to multi-user (SQL 2005)
• Random Records in SQL2000 / 2005
• Find duplicate records
• Force Insert Primary key ID in SQL
• Show running processes in MySQL
• Rename Database (SQL 2000)
• Create a Temporary Table in SQL2005
• Create a table only if it doesn't exist - SQL 2005
• Find Active Connections in SQL 2005
• Find Duplicates (MYSQL)
• Delete Duplicate records leave first one present

Please log in to add/edit entries:

Username
Password

Categories

Home
Ajax
ASP
C#
CSS
Excel
HTML
Javascript
PHP
SQL
WYSIWYG
XML/XSL
Bookmarks