SQL::Translator::Producer::SQLServer man page on Fedora

SQL::Translator::Producer::SQLServer man page on Fedora

Man page or keyword search:
man Server 31170 pages
apropos Keyword Search (all sections)
Output format

SQL::Translator::ProduUser:Contributed)SQL::Translator::Producer::SQLServer(3)

NAME
       SQL::Translator::Producer::SQLServer - MS SQLServer producer for
       SQL::Translator

SYNOPSIS
	 use SQL::Translator;

	 my $t = SQL::Translator->new( parser => '...', producer => 'SQLServer' );
	 $t->translate;

DESCRIPTION
       WARNINGB This is still fairly early code, basically a hacked version of
       the Sybase Producer (thanks Sam, Paul and Ken for doing the real work
       ;-)

Extra Attributes
       field.list
	   List of values for an enum field.

TODO
	* !! Write some tests !!
	* Reserved words list needs updating to SQLServer.
	* Triggers, Procedures and Views DO NOT WORK

SQLServer Create Table Syntax
       TODO

	   # Text of view is already a 'create view' statement so no need to
	   # be fancy
	   foreach ( $schema->get_views ) {
	       my $name = $_->name();
	       $output .= "\n\n";
	       $output .= "--\n-- View: $name\n--\n\n" unless $no_comments;
	       my $text = $_->sql();
	       $text =~ s/\r//g;
	       $output .= "$text\nGO\n";
	   }

	   # Text of procedure already has the 'create procedure' stuff
	   # so there is no need to do anything fancy. However, we should
	   # think about doing fancy stuff with granting permissions and
	   # so on.
	   foreach ( $schema->get_procedures ) {
	       my $name = $_->name();
	       $output .= "\n\n";
	       $output .= "--\n-- Procedure: $name\n--\n\n" unless $no_comments;
	       my $text = $_->sql();
	     $text =~ s/\r//g;
	       $output .= "$text\nGO\n";
	   }

SEE ALSO
       SQL::Translator.

AUTHORS
       Mark Addison <grommit@users.sourceforge.net> - Bulk of code from Sybase
       producer, I just tweaked it for SQLServer. Thanks.

perl v5.14.2			  2011-SQL::Translator::Producer::SQLServer(3)

[top]

List of man pages available for Fedora

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]

Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................

Vote for polarhome