﻿<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>StrataFrame Forum » StrataFrame Database Deployment Toolkit » Enhancement Requests  » SQL Functions</title><generator>InstantForum 2017-1 Final</generator><description>StrataFrame Forum</description><link>http://forum.strataframe.net/</link><webMaster>StrataFrame Forum</webMaster><lastBuildDate>Tue, 09 Jun 2026 07:48:49 GMT</lastBuildDate><ttl>20</ttl><item><title>SQL Functions</title><link>http://forum.strataframe.net/FindPost2269.aspx</link><description>In the scenarios that I'll be deploying, I know always that I will be going against SQL Server, which allows functions&lt;br&gt;
&lt;br&gt;
I'd like to be able to include the functions, and get them created in the correct order.  I consider it perfectly acceptable for the client to be unable to install against back ends that don't allow the use of functions&lt;br&gt;
  Need:  Some of the Views use functions (Pure SQL functions, NOT .Net functions (Yet, but that's coming soon too), for speed reasons.  The view creation explicitly fails if the function doesn't exist.  Next project is quite likely to require function usage.  To add to the fun, some functions use other functions, so should probably be dumped into the creation pool with the views (e.g. Create all Tables, Create all Views/Functions, then Create procs.  At least this is the modifications I would have to make to our own, custom deployment app, hoping you guys handle it already!)&lt;br&gt;</description><pubDate>Fri, 18 Aug 2006 08:52:06 GMT</pubDate><dc:creator>Jim Schepflin</dc:creator></item><item><title>RE: SQL Functions</title><link>http://forum.strataframe.net/FindPost2271.aspx</link><description>The DDT does not support the deployment of UDFs or UDTs... if you need to deploy them, then you'll need to stick to scripting or some other database deployment model.&lt;/P&gt;&lt;P&gt;However, the Application Framework supports them and quite frankly doesn't care where the data comes from, so you could use it for your application without any problems.</description><pubDate>Fri, 18 Aug 2006 08:52:06 GMT</pubDate><dc:creator>StrataFrame Team</dc:creator></item></channel></rss>