Closing Parenthesis

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736642 More actions · Answer 1

If you :), which is colon-closed paren, it gets converted.

You can : ), which might work better. Or ; )

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

Steve Jones - Editor (4/7/2008)
If you :), which is colon-closed paren, it gets converted.
You can : ), which might work better. Or ; )

Steve,

Here is an example of what is happening, and note I do not have a colon or semi-colon anywhere:

Create Table #tbl1

(

id int identity(1,1),

lev1 int

)

Declare @i int

While Isnull(@i, 1) <>10

Begin

Insert Into #tbl1

(

lev1

) -- this is " )", the same as the above create table, and is converted to this smiley;)

Select

@i

Set @i = IsNull(@i, 0) + 1

End

Declare @count Int

While IsNull(@count, 1) <10

Begin

Insert Into #tbl1

(lev1) -- when I do it like this it is okay

Select

@i

Select @count = scope_Identity()

If IsNull(@i, 1) % 3 = 0

Set @i = @i - 8

Else

Set @i = IsNull(@i, 1) + 5

End

This is not a huge deal as there are ways to work around it, but it can be a little annoying.

Thanks for the response.