08-21-2002
I would suggest the "SQL Server Books-on-line" that ships with SQL Server. One of the best references for SQL Server that I have found.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
sqlplus -s / <<EOF > /dev/null
insert into table1 (a1, a2, a3) values ('a',1,'b');
commit;
EOF
in the above code can i pass the values to the insert command from shell script like this:
insert into table1 (a1, a2, a3) values ('$a',$b,'$c');
If yes, how is it passed??
Any... (2 Replies)
Discussion started by: abey
2 Replies
2. Solaris
is there any good doc which explains the systems command reference manual for sun solaris
for ex: related to memory
disk space
booting
rsh enabling
restarting
LOM etc etc
pls help... (1 Reply)
Discussion started by: gini
1 Replies
3. HP-UX
hi everybody,
i m AIX guy....
due 2 some reason i was also askd 2 work in HP-UX
so i think all d concepts r same as AIX....
so i thought it s easy to learn by comparitve study....
if so
then wr can i get the materials????????
thanks in advance........ (1 Reply)
Discussion started by: rrlog
1 Replies
4. Shell Programming and Scripting
Hi,
Table1
======
Code1
Field1
Table2
======
Code1
Field1
Would anyone be able to help me know what's the best sql command to delete the entry in Table1 if its Code1-Field1 combination is already existing in Table2.
I used this one -
delete from Table1 where Code1 in (select... (1 Reply)
Discussion started by: gholdbhurg
1 Replies
5. AIX
Sir,
Iam required AIx simulator If any send the download link
I required it for practice (2 Replies)
Discussion started by: arif185
2 Replies
6. SuSE
Is there a command that will output all mysql details. eg. host name, port etc?
Cheers
Paul (1 Reply)
Discussion started by: runnerpaul
1 Replies
7. Shell Programming and Scripting
Guys,
May i know how can we de reference the code reference variable.?
my $a = sub{$a=shift;$b=shift;print "SUM:",($a+$b),"\n";};
print $a->(4,5);
How can we print the whole function ?
Please suggest me regarding this.
Thanks for your time :)
Cheers,
Ranga :) (0 Replies)
Discussion started by: rangarasan
0 Replies
8. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
9. Shell Programming and Scripting
I have data that looks like this:
<Country code="US"><tag>adsf</tag><tag>bdfs</tag></Country><Country code="CA"><tag>asdf</tag><tag>bsdf</tag></Country>
I want to grab the country code save it, then drop each new "<..." onto a new line with the country code added to the beginning of each
So,... (9 Replies)
Discussion started by: JenniferAmon
9 Replies
LEARN ABOUT DEBIAN
oarresume
oarresume(1) OAR commands oarresume(1)
NAME
oarresume - resume a job in OAR batch scheduler.
SYNOPSIS
oarresume [--array][job_ids][--sql "sql syntax"][-V][-h]
DESCRIPTION
Ask OAR to change job_ids states into Waiting when it is Hold or in Running if it is Suspended.
OPTIONS
--array
Resume array job(s) passed as parameter (all the sub-jobs of the given array job(s))
--sql
Resume jobs which repond to the SQL where clause on the table jobs (ex: "project = 'p1'")
-V, --version
Print OAR version number.
-h, --help
Print help command message.
oarsub(1), oardel(1) oarstat(1), oarnodes(1), oarhold(1)
COPYRIGHTS
Copyright 2008 Laboratoire d'Informatique de Grenoble (http://www.liglab.fr). This software is licensed under the GNU Library General Public License. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
oarresume 2012-05-23 oarresume(1)