Preserve SQL with CodeSmith

Posted by Seeriuss on Stack Overflow See other posts from Stack Overflow or by Seeriuss
Published on 2010-05-03T22:09:20Z Indexed on 2010/05/03 22:18 UTC
Read the original article Hit count: 416

Filed under:

codesmith

|

sql

How would I create a procedure with a PRESERVE region like this:

CREATE PROCEDURE RunSQL
AS

--region Custom processing
--endregion

SELECT * FROM SomeTable

GO

© Stack Overflow or respective owner

Related posts about codesmith

Visual Studio T4 vs CodeSmith

as seen on Stack Overflow - Search for 'Stack Overflow'
I've been using CodeSmith for the past 2 years and love what it does for me. However, I also know about T4 which is built in to Visual Studio and can do some pretty cool stuff too. Based on conversations with friends T4 in VS2010 T4 is going to be even better. So the question is: do I keep riding… >>> More
Preserve SQL with CodeSmith

as seen on Stack Overflow - Search for 'Stack Overflow'
How would I create a procedure with a PRESERVE region like this: CREATE PROCEDURE RunSQL AS --region Custom processing --endregion SELECT * FROM SomeTable GO >>> More
Generate code from SPs using codesmith or MyGeneration?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have CodeSmith and MyGeneration tools. I have SPs in SQL server. I want generate VB.Net code for SPs (not for Tables). Which templates will support for this? Please share if you know any templates that generates VB.net code from SP?. >>> More
Free CodeSmith License!

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
The catch? Attend the Ozarks .Net User Group meeting on April 1st. Here’s a list of the other prizes for the event GRAND PRIZE 1 - iPad (Wi-Fi 16GB) THIRD PARTY COMPONENTS 6 - Telerik Premium Collection 5 - Infragistics NetAdvantage for .NET 1 - Nevron Chart for .NET… >>> More
How to add generated files to multiple projects using CodeSmith tools

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using CodeSmith on my current project and I'm trying to figure out an issue. For my CodeSmith project (.csp) I can select an option to have it automatically add all generated files to the current project (.csproj). But I want to be able to add the output to multiple projects (.csproj). Is there… >>> More

Related posts about sql

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
SQL SERVER – Concat Function in SQL Server – SQL Concatenation

as seen on SQL Authority - Search for 'SQL Authority'
Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though… >>> More
Error with SQL Server Setup 2012 on Windows 2012

as seen on Server Fault - Search for 'Server Fault'
I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: … >>> More
How can I detect which version of SQL (eg SQL 2008 or SQL Azure)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure. How can I do this with detection code written in SQL? >>> More
Nested SQL Select statement fails on SQL Server 2000, ok on SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is the query: INSERT INTO @TempTable SELECT UserID, Name, Address1 = (SELECT TOP 1 [Address] FROM (SELECT TOP 1 [Address] FROM [UserAddress] ua INNER JOIN UserAddressOrder uo ON ua.UserID = uo.UserID WHERE ua.UserID = u.UserID ORDER BY uo.AddressOrder ASC) q ORDER BY AddressOrder… >>> More