Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (nike.apache.org: local policy)
From: Alain Kuchta <alain.kuchta@etegent.com>
To: "derby-user@db.apache.org" <derby-user@db.apache.org>
Subject: Converting SQL Server Scripts to be compatible with Derby
Thread-Topic: Converting SQL Server Scripts to be compatible with Derby
Thread-Index: Ac1wzQfmf07n4eL0QZa2IxEvNNlp/A==
Date: Thu, 2 Aug 2012 16:36:58 +0000
Message-ID: 
 <BA35FB323D092143B4F8335A0CAC0EE418472074@SN2PRD0610MB396.namprd06.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: multipart/alternative;
	boundary="_000_BA35FB323D092143B4F8335A0CAC0EE418472074SN2PRD0610MB396_"
MIME-Version: 1.0

--_000_BA35FB323D092143B4F8335A0CAC0EE418472074SN2PRD0610MB396_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,

I'm currently evaluating Derby as a potential tool for use at my company. W=
e currently use SQL Server for "stand-alone" deployments of our software. (=
the database is hosted locally) We are considering implementing Derby for t=
his situation instead.

We would like to reuse the database creation and population scripts that we=
 have written for SQL Server as much as possible for Derby.

Beyond simple differences in syntax there are a two issues which are hinder=
ing implementing our scripts with derby.

1) Conditionals. How does one effectively replicate the IF/ELSE statement a=
vailable in Transact-SQL when using Derby?
2) Local variables. Dow does one achieve a similar effect to the local vari=
able declaration available in Transact-SQL?

Thanks,

AK

--_000_BA35FB323D092143B4F8335A0CAC0EE418472074SN2PRD0610MB396_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 12 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"blue" vlink=3D"purple">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hello,<br>
<br>
I&#8217;m currently evaluating Derby as a potential tool for use at my comp=
any. We currently use SQL Server for &#8220;stand-alone&#8221; deployments =
of our software. (the database is hosted locally) We are considering implem=
enting Derby for this situation instead.<br>
<br>
We would like to reuse the database creation and population scripts that we=
 have written for SQL Server as much as possible for Derby.<br>
<br>
Beyond simple differences in syntax there are a two issues which are hinder=
ing implementing our scripts with derby.<br>
<br>
1) Conditionals. How does one effectively replicate the IF/ELSE statement a=
vailable in Transact-SQL when using Derby?<br>
2) Local variables. Dow does one achieve a similar effect to the local vari=
able declaration available in Transact-SQL?<br>
<br>
Thanks,<br>
<br>
AK<o:p></o:p></p>
</div>
</body>
</html>

--_000_BA35FB323D092143B4F8335A0CAC0EE418472074SN2PRD0610MB396_--