管理工作室的怪异行为 [英] Weird behaviour of Management Studio

问题描述

我的 sql 管理工作室在使用这个 sql 脚本时表现得很奇怪.

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

Sql 文件中的错误.

Bug in the Sql File .

SqlScript.

重现步骤:

这里是sql文件.在 Sql Management studio 2008 中打开它.注释身份插入和关闭之间的行.剪切它并将其粘贴到新的查询窗口中.尝试做不止一次......它表现出一些奇怪的行为

Here is the sql file. Open it in Sql Management studio 2008. Comment the line 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

推荐答案

正如我在对您关闭的问题的评论中所发表的那样，问题是在十六进制查看器中查看时 SQL 脚本中的字符串是

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

0000 字符是 NULL 字符.这标志着 C 中字符串的结束，并解释了您所看到的奇怪行为.您可能应该将密码字段的数据类型更改为 binary/varbinary.

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.

这篇关于管理工作室的怪异行为的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！