List all Collations Support by MSSQL 2000 (Microsoft SQL Server)
May 29th, 2009 SamTO List all Collations Support by MSSQL 2000 (Microsoft SQL Server) run:
SELECT *
FROM ::fn_helpcollations();
TO List all Collations Support by MSSQL 2000 (Microsoft SQL Server) run:
SELECT *
FROM ::fn_helpcollations();
There are two ways to install Gnome 2 on Freebsd:
1. run the command:
# pkg_add -r gnome2
2. run the command:
# cd /usr/ports/x11/gnome2
# make install clean
For more infomation about gnome on freebsd check out http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/x11-wm.html
TO List all Collations Support by MSSQL 2000 (Microsoft SQL Server) run:
SELECT *
FROM ::fn_helpcollations();
An easy way to Auto Increment a Field with MSSQL (Microsoft SQL Server).
CREATE TABLE Users (
id INT NOT NULL IDENTITY(1,1),
PRIMARY KEY (id) );
IDENTITY(1,1)
Round 1
Which Software Supports more Compression formats?
PeaZip: 24 compression formats (7Z, 7-Zip sfx, ARJ, BZip2, CAB, CHM, CPIO, DEB, GZip, ISO, JAR, LHA, LZH, NSIS, OOo, PAQ, PEA, QUAD, RAR, RPM, split, TAR, Z, ZIP).
7-Zip: 14 compression formats (7z, ZIP, CAB, RAR, ARJ, LZH, CHM, GZIP, BZIP2, Z, TAR, CPIO, RPM, DEB).
Winner:
PeaZip with 24 Compression Formats
Download PeaZip Now
WebSite:
Putty is a Easy Telnet, SSH, RLogin, and Raw TCP client.
With Putty you can
History
Putty was created by Simon Tatham. Putty’s first release Putty 0.45 was released on 1999-01-22.
Download Putty 0.60 Today:
Putty for Windows 95, 98, ME, NT, 2000, XP and Vista
Web Site:
So how is everyone doing?
Well today I am going to teach you how to connect to a mysql database, query a mysql database and then get back some data.
You only need one Connection.
//Start Connection
$connection = mysql_connect(’host’,'username’,'password’);//Start Connection 2 with an if statement incase the connection fails
$connection = mysql_connect(’host’,'username’,'password’);
if (!$connection) {
die(’Could not connect: ‘ . mysql_error());
}
//Select Database
mysql_select_db($dbname);//Query
$query = “SELECT * FROM Table_Name”;
//Execute the Query
$result = mysql_query($query);//Display the Data
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo “Name :{$row['name']}” .
“Subject : {$row['subject']} ” .
“Message : {$row['message']}”;
}
//Clear Results
mysql_free_result($result);
//Close Connection
mysql_close($connection);
Here are a few more MySQL functions that can help you.
//List MySQL Databases
mysql_list_dbs($connection);
//List MySQL Tables in a Database
mysql-list-tables(”Database_Name”);
//Number of Rows returned by results from a query
mysql_num_rows($result);
//MySQL Host Info
mysql_get_host_info($connection);
//MySQL Server Info
mysql_get_server_info($connection);
If you have any questions simply leave a comment with your questions.
Hey if its a question about code remember to post the code.
One of the First things you will ever do with PHP is create a Hello World Script.
Script 1
<?php
Print “Hello, World!”;
?>
Script 2
<?php
Echo “Hello, World!”;
?>
Script 1 & 2 do exactly the same thing the out the words Hello World!
Script 1 uses Print to Display Hello World!
Script 2 uses Echo to Display Hello World!
Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!