Deployment has changed sql in a function.

Question

I have a file in my project that looks like this:

CREATE FUNCTION [dbo].[CSplit]
    (
     @RowData NVARCHAR(MAX)
    ,@Delimeter NVARCHAR(MAX)
    )
RETURNS @RtnValue TABLE
    (
     ID INT IDENTITY(1, 1)
    ,Data NVARCHAR(MAX)
    )
AS BEGIN 

When I do Deploy, the script for this function looks like this:

ALTER FUNCTION [dbo].[CSplit]
(@RowData NVARCHAR (MAX), @Delimeter NVARCHAR (MAX))
RETURNS 
    @RtnValue TABLE (
        [ID]   INT            IDENTITY (1, 1) NOT NULL,
        [Data] NVARCHAR (MAX) NULL)
AS
BEGIN 

Why is it changing the formating?
Even if I let it go thru and make the changes, every time I deploy this function is in the deployment script.

Answer 1

Hi William

Would you mind telling us which version of VS are you using?
Does it apply latest SP or not?

Thanks!

Figo Fei

MSDN Subscriber Support in Forum

If you have any feedback on our support, please contact [e-mail]

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 2

I have installed the following:
Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Microsoft .NET Framework
Version 3.5 SP1

Installed Edition: Enterprise

Microsoft Visual Basic 2008  
Microsoft Visual Basic 2008

Microsoft Visual C# 2008  
Microsoft Visual C# 2008

Microsoft Visual C++ 2008  
Microsoft Visual C++ 2008

Microsoft Visual Studio 2008 Team Explorer  
Microsoft Visual Studio 2008 Team Explorer
Version 9.0.30729.1

Microsoft Visual Studio 2008 Tools for Office  
Microsoft Visual Studio 2008 Tools for Office

Microsoft Visual Studio Team System 2008 Architecture Edition  
Microsoft Visual Studio Team System 2008 Architecture Edition

Microsoft Visual Studio Team System 2008 Database Edition GDR  
Microsoft Visual Studio Team System 2008 Database Edition GDR Version 9.1.40413.00

Microsoft Visual Studio Team System 2008 Development Edition  
Microsoft Visual Studio Team System 2008 Development Edition

Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V.  All rights reserved.

The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company.  Electronic version licensed from Lernout & Hauspie Speech Products N.V.  All rights reserved.

Microsoft Visual Studio Team System 2008 Test Edition  
Microsoft Visual Studio Team System 2008 Test Edition

Microsoft Visual Web Developer 2008  
Microsoft Visual Web Developer 2008

Crystal Reports    AAJ60-G0MSA4K-68000CF
Crystal Reports Basic for Visual Studio 2008

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB945282)   KB945282
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/945282.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946040)   KB946040
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946040.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946308)   KB946308
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946308.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946344)   KB946344
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946344.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946581)   KB946581
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946581.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947173)   KB947173
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947173.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947540)   KB947540
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947540.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947789)   KB947789
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947789.

Hotfix for Microsoft Visual Studio 2008 Team Explorer - ENU (KB946260)   KB946260
This hotfix is for Microsoft Visual Studio 2008 Team Explorer - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946260.

Hotfix for Microsoft Visual Studio 2008 Team Explorer - ENU (KB946458)   KB946458
This hotfix is for Microsoft Visual Studio 2008 Team Explorer - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946458.

Hotfix for Microsoft Visual Studio 2008 Team Explorer - ENU (KB947171)   KB947171
This hotfix is for Microsoft Visual Studio 2008 Team Explorer - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947171.

Hotfix for Microsoft Visual Studio 2008 Team Explorer - ENU (KB947180)   KB947180
This hotfix is for Microsoft Visual Studio 2008 Team Explorer - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947180.

Hotfix for Microsoft Visual Studio 2008 Team Explorer - ENU (KB948816)   KB948816
This hotfix is for Microsoft Visual Studio 2008 Team Explorer - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/948816.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB944899)   KB944899
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/944899.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB946673)   KB946673
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946673.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB948127)   KB948127
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/948127.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB953256)   KB953256
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/953256.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB971092)   KB971092
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/971092.

Microsoft Visual Studio 2008 Team Explorer - ENU Service Pack 1 (KB945140)   KB945140
This service pack is for Microsoft Visual Studio 2008 Team Explorer - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/945140.

Microsoft Visual Studio Team System 2008 Team Suite - ENU Service Pack 1 (KB947888)   KB947888
This service pack is for Microsoft Visual Studio Team System 2008 Team Suite - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947888.

Microsoft Visual Studio Team System 2008 Team Suite - ENU Service Pack 1 (KB948484)   KB948484
This service pack is for Microsoft Visual Studio Team System 2008 Team Suite - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/948484.

Microsoft Visual Studio Team System 2008 Team Suite - ENU Service Pack 1 (KB948560)   KB948560
This service pack is for Microsoft Visual Studio Team System 2008 Team Suite - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/948560.

Security Update for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB972222)   KB972222
This security update is for Microsoft Visual Studio Team System 2008 Team Suite - ENU.
If you later install a more recent service pack, this security update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/972222.

Security Update for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB973675)   KB973675
This security update is for Microsoft Visual Studio Team System 2008 Team Suite - ENU.
If you later install a more recent service pack, this security update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/973675.

SQL Server Analysis Services  
Microsoft SQL Server Analysis Services Designer
Version 10.0.2531.0

SQL Server Integration Services  
Microsoft SQL Server Integration Services Designer
Version 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )

SQL Server Reporting Services  
Microsoft SQL Server Reporting Services Designers
Version 10.0.2531.0

Update for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB956453)   KB956453
This update is for Microsoft Visual Studio Team System 2008 Team Suite - ENU.
If you later install a more recent service pack, this update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/956453.

Update for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB967143)   KB967143
This update is for Microsoft Visual Studio Team System 2008 Team Suite - ENU.
If you later install a more recent service pack, this update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/967143.

Visual Studio Package Load Analyzer   1.0
A utility that analyzes package load failures in Visual Studio.

SQL Prompt 3.8
For more information about SQL Prompt, see the Red Gate website at
http://www.red-gate.com
For customer support, call 1-866-733-4283.
Copyright © 2006–2008 Red Gate Software Ltd

Answer 3

Sounds like SQL is normalizing the statements within the function.  What is between BEGIN and END?

Thanks,

---

Barclay Hill Program Manager VSTS: DB Team (DataDude, DBPro, Database Edition) Please mark the responses as answer if it resolves your question. http://blogs.msdn.com/bahill

Answer 4

In GDR, we only retain the comments and formatting in the body of programmability objects, the format of the signature is changed.  This is improved in VS 2010.