Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Code Block corrupts my SQL

Jerry Chappell February 20, 2019

What's up with the <Code> block feature? If I paste my SQL code into a description field, like this....

 

CREATE PROC [dbo].[TestMostRecent]
(
@location varchar(50),
@tsn varchar(10),
@records int = 1
)
AS
BEGIN
RETURN 0
END

 

And then specify that it's SQL, and click Save.

When I come back into it, and copy it to my clipboard, it comes out fine (apparently), but it must include some bad characters because it no longer parses in SQL Server Management Studio saying there are errors...

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '‌'.

2 answers

0 votes
Jerry Chappell February 25, 2019

This issue is my first one, since starting to pay for Jira. Does anyone have an estimate on how long it takes for Atlassian to support me?

0 votes
Jerry Chappell February 20, 2019

Here's a bit more information -- it works fine if I specify that it's SQL when I first put in the code. But if I put Java (or don't put any language), and later change it to SQL, then the text is corrupted and there's no way to ever get it back to runnable. I'm worried that I've already lost a lot of SQL scripts that I assumed were being saved... re-typing them is going to be brutal.

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events