开发者

Weird behaviour of Management Studio

开发者 https://www.devze.com 2023-02-16 12:20 出处:网络
My sql managment studio is behaving weird with thi sql script. Bug in the Sql File . SqlScript. Steps to reproduce:

My sql managment studio is behaving weird with thi sql script.

Bug in the Sql File .

SqlScript.

Steps to reproduce:

Here is the sql file. Open it in Sql Management studio 2008. Comment the li开发者_如何学Pythonne between the identity insert on and off. cut it and paste it in new query window. Try to do more than once... it shows some weird behaviours


As I posted in the comments to your closed question the problem is that the string in the SQL Script when looked at in a Hex Viewer is

0001000000000000006800FA004D00B2
0019002D00CF006800400078011920B3
00780192010E00FE00E4001D00C3004D
006400AD0069007100

The 0000 character is the NULL character. This marks the end of a string in C and explains the odd behaviour you are seeing. You should probably change the datatype of the password field to binary/varbinary.

0

精彩评论

暂无评论...
验证码 换一张
取 消