08-09-2002
If you have MSSQL you can bring up the help window and search for Programmer's Reference. You should get a listing of topics
Interfaces, Objects, Enumerations, Collections, ....
You will have to dig for the commands, but that is one way...
If you have no clue about SQL, try searching goggle for "basic sql commands". There are quite a few that will get you started ( like this
one or this
one (sql+)
Or you can dig through the Newsgroups on Microsoft Support or the documentation at
SQL Server Support
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
sql::translator::schema::procedure
SQL::Translator::Schema::Procedure(3pm) User Contributed Perl Documentation SQL::Translator::Schema::Procedure(3pm)
NAME
SQL::Translator::Schema::Procedure - SQL::Translator procedure object
SYNOPSIS
use SQL::Translator::Schema::Procedure;
my $procedure = SQL::Translator::Schema::Procedure->new(
name => 'foo',
sql => 'CREATE PROC foo AS SELECT * FROM bar',
parameters => 'foo,bar',
owner => 'nomar',
comments => 'blah blah blah',
schema => $schema,
);
DESCRIPTION
"SQL::Translator::Schema::Procedure" is a class for dealing with stored procedures (and possibly other pieces of nameable SQL code?).
METHODS
new
Object constructor.
my $schema = SQL::Translator::Schema::Procedure->new;
parameters
Gets and set the parameters of the stored procedure.
$procedure->parameters('id');
$procedure->parameters('id', 'name');
$procedure->parameters( 'id, name' );
$procedure->parameters( [ 'id', 'name' ] );
$procedure->parameters( qw[ id name ] );
my @parameters = $procedure->parameters;
name
Get or set the procedure's name.
$procedure->name('foo');
my $name = $procedure->name;
sql
Get or set the procedure's SQL.
$procedure->sql('select * from foo');
my $sql = $procedure->sql;
order
Get or set the order of the procedure.
$procedure->order( 3 );
my $order = $procedure->order;
owner
Get or set the owner of the procedure.
$procedure->owner('nomar');
my $sql = $procedure->owner;
comments
Get or set the comments on a procedure.
$procedure->comments('foo');
$procedure->comments('bar');
print join( ', ', $procedure->comments ); # prints "foo, bar"
schema
Get or set the procedures's schema object.
$procedure->schema( $schema );
my $schema = $procedure->schema;
equals
Determines if this procedure is the same as another
my $isIdentical = $procedure1->equals( $procedure2 );
AUTHORS
Ken Youens-Clark <kclark@cshl.org>, Paul Harrington <Paul-Harrington@deshaw.com>.
perl v5.14.2 2012-01-18 SQL::Translator::Schema::Procedure(3pm)