10-10-2018
You mean you did a query into your PICK DB and stored the results in a flat text file; and you are asking how to do a PICK DB query and store the results in what format exactly?
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Does anyone know how many ways to pick out last charactor of a string?
Thanks! (7 Replies)
Discussion started by: cin2000
7 Replies
2. Solaris
Hey guys I am new here and like this forum alot. I went to get into Solaris and would like to buy a sun box on ebay. NON rackmount. Problem is there is so many diff types. I am looking for one under the $800 range that can support solaris 10 and have the basics and decent ram.
Can you guys... (11 Replies)
Discussion started by: Gnfanatic
11 Replies
3. UNIX for Dummies Questions & Answers
How can i pick distinct records which consists of duplicate data from a ASCII file using UNIX commands (3 Replies)
Discussion started by: ss4u
3 Replies
4. Shell Programming and Scripting
Hi,
How do i pick a particular value from a group of lines using python.
for instance from the below sample. How do I pick Value=1 of OuterLines=1 and InnerLine=1 (11 Replies)
Discussion started by: ahmedwaseem2000
11 Replies
5. Shell Programming and Scripting
I want to be able pick columns from 2 files with similar reference data:
File 1
Last NameFirst NameSalaryCityDunnJohn $42,000.00 ChicagoGrantSuzy $95,000.00 GaryLoweMike $80,000.00 MilwaukeeGrantMike $59,000.00 JolietLoweKaren $48,000.00 South BendFile 2
TitleFirst NameLast... (2 Replies)
Discussion started by: sigh2010
2 Replies
6. Shell Programming and Scripting
Hi, I have a problem I am trying to solve with bash.
I need to search in a file system (data base) with hundreds of directories and thousands of subdirectories and millions of files. The files have a specific format with a header that gives the properties. Directories are organized so... (1 Reply)
Discussion started by: majest
1 Replies
7. What is on Your Mind?
I have been wondering how do Systems Administrators do the jump into Systems Engineering? Is it only a matter of time and experience or could I actually help myself get there?
Opinions? Books I could read?
Thanks a lot for your help! (0 Replies)
Discussion started by: svalenciatech
0 Replies
8. Shell Programming and Scripting
Hi Friends,
I'm facing an issue. I am having a file as under :
a1
b1
c1
a2
a3
a4
b4
a5
b5
and I need to get the output as under:
a1 b1
a4 b4
a5 b5
i.e. to pick the columns where a and b are consecutive and ignoring rest.
I was trying some thing sily as: (2 Replies)
Discussion started by: vanand420
2 Replies
9. Filesystems, Disks and Memory
Hi all,
I'm a bit new to advanced filesystem types. I've just only learned that if you wish to share a single fibre channel extent with many servers you need to use a clustered filesystem to prevent data corruption.
looking through a list of clustered file systems I saw gfs2 which I thought... (1 Reply)
Discussion started by: jokken
1 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)