| |
| Title |
|
Description |
|
| Connecting to SQLServer via IP |
|
Where:
- xxx.xxx.xxx.xxx is an IP address
- 1433 is the default port number for SQL Server.
- "Ne |
| COUNT |
|
Will return record count of the return. You can COUNT specific fields doing this as well. |
| Dynamic SQL in StoredProc |
|
Build a SQL statement in a stored proceedure, and execute it |
| INNER JOIN |
|
Standard inner join statment |
| INSERT Statement |
|
Basic Insert Statement - Using ColdFusion variables. |
| MAX |
|
Will Return the last record or highest value of the specified field. |
| MySQL Dump Backup |
|
This snip will dump the entire database. Was originally used to migrate from mysql4.0 to mysql4.1 |
| ORDER BY |
|
Will sort LastName from A-Z, use DESC for Z-A sort. Items can be ORDER BY Date, Text or numeric val |
| Remove Duplicate Rows from a Database |
|
The following SQL example shows you how to eliminate all duplicate rows from a table. This example |
| SELECT DISTINCT |
|
This will select all unique values. It will ignore all duplicate entries. |
| SELECT TOP 10 |
|
Although the SQL Server BOL claims that T-SQL doesn't support the TOP keyword, in fact it does—and t |
| SET ROWCOUNT |
|
You're probably familiar with the typical "SELECT * FROM Table" SQL statement, which returns all the |
| UPDATE Statement |
|
Basic Update Statement - Using ColdFusion variables. |
