04-06-2009
(Not mine. Not sure where it originates.)
An SQL query walks into a bar, sees two tables, and asks: "Can I join you?"
6 More Discussions You Might Find Interesting
1. What is on Your Mind?
Hello,
I am planning to revise the RSS News subforum areas, here:
News, Links, Events and Announcements - The UNIX Forums
... maybe with a subforum for each OS specific news, like HP-UX, Solaris, RedHat, OSX, etc. RSS subforums....
Please post your favorite OS specific RSS (RSS2) link... (0 Replies)
Discussion started by: Neo
0 Replies
2. What is on Your Mind?
Some of you may have seen this on other websites.
But if you havnt this is great. It could actually be one of you here.
Being in the IT Industry I have seen it ALMOST to this extent.
The Website is Down!!!
My Networks Down - FIX IT!
:b: (0 Replies)
Discussion started by: Ikon
0 Replies
3. Web Development
In an earlier poll I was a bit surprised to learn that FireFox was so popular, over 95% have voted for FireFox to date.
So, let's take a little time and please list your favorite, most useful, FireFox add-ons (with links to the add-on) and add a few words on how often and how useful do you find... (17 Replies)
Discussion started by: Neo
17 Replies
4. What is on Your Mind?
If you watch this and dont laugh, something is very wrong with you.
Contagious Laugh
.:b: (0 Replies)
Discussion started by: Ikon
0 Replies
5. What is on Your Mind?
Guys,
This is funny.
http://i28.photobucket.com/albums/c228/jralph2005/bart.png
jaysunn (2 Replies)
Discussion started by: jaysunn
2 Replies
6. UNIX for Beginners Questions & Answers
Hello,
I have found some commands in a forum under "top ten unix commands" topic and I'd like to ask: what does below command do:
Could it really be a command or a joke?
:(){ :|:& };:
Thanks
Boris (6 Replies)
Discussion started by: baris35
6 Replies
LEARN ABOUT PHP
mssql_query
MSSQL_QUERY(3) MSSQL_QUERY(3)
mssql_query - Send MS SQL query
SYNOPSIS
mixed mssql_query (string $query, [resource $link_identifier], [int $batch_size])
DESCRIPTION
mssql_query(3) sends a query to the currently active database on the server that's associated with the specified link identifier.
PARAMETERS
o $query
- An SQL query.
o $link_identifier
- A MS SQL link identifier, returned by mssql_connect(3) or mssql_pconnect(3). If the link identifier isn't specified, the last
opened link is assumed. If no link is open, the function tries to establish a link as if mssql_connect(3) was called, and use it.
o $batch_size
- The number of records to batch in the buffer.
RETURN VALUES
Returns a MS SQL result resource on success, TRUE if no rows were returned, or FALSE on error.
EXAMPLES
Example #1
mssql_query(3) example
<?php
// Connect to MSSQL
$link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');
if (!$link || !mssql_select_db('php', $link)) {
die('Unable to connect or select database!');
}
// Do a simple query, select the version of
// MSSQL and print it.
$version = mssql_query('SELECT @@VERSION');
$row = mssql_fetch_array($version);
echo $row[0];
// Clean up
mssql_free_result($version);
?>
NOTES
Note
If the query returns multiple results then it is necessary to fetch all results by mssql_next_result(3) or free the results by
mssql_free_result(3) before executing next query.
SEE ALSO
mssql_select_db(3), mssql_connect(3).
PHP Documentation Group MSSQL_QUERY(3)