SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Code Snippets CR/LF

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Code Snippets CR/LF
Author Message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Code Snippets CR/LF Reply with quote
5.1.10 Pro
SSMS 2008

Code:
$PROMPT(proc_name,Enter new procedure name)$
IF OBJECT_ID('$proc_name$') IS null
   Exec ('Create procedure $proc_name$ AS')
GO

/***********************************************************
* Procedure description:
* Date:   $DATE$
* Author: $OSUSER$
*
* Changes
* Date      Modified By         Comments
************************************************************
*
************************************************************/


Alter PROCEDURE $proc_name$
(
   |
)
AS
BEGIN
   SET NOCOUNT ON
   
   
   
   RETURN 0
END

Outputs everything as a single line, and not even all the text. Seems to truncate after 152 characters.
Tue Sep 07, 2010 4:37 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Sorry, I'm unable to reproduce this one too. I copied your text from the web page.

Did you copy the snippet text from some text editor or entered it directly into the snippet text edit box?
Thu Sep 09, 2010 6:31 am View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
I worked around by copying the text from the snippet editor into the SQL editor window, then copying back. Copying into notepad showed similar issues. There seemed to be a difference in the encoding or handling of CR/LF between version or how the settings were transferred between versions.
Thu Sep 09, 2010 9:00 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Here is the issue tracking number #SA 11313. This issue has been fixed and the fix should be released in the next public build.
Wed Sep 15, 2010 11:04 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.