April 7, 2008 at 9:10 am
If you :), which is colon-closed paren, it gets converted.
You can : ), which might work better. Or ; )
April 7, 2008 at 9:33 am
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.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply