Can "SET ANSI_WARNINGS OFF" be set on user level? - Database版 - 未名存档

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Database版 - Can "SET ANSI_WARNINGS OFF" be set on user level?

相关主题
● 请教怎么关闭MYSQL的debug信息	● 谁有电子版的SQL Server2005书，能否共享一下
● Re: Is there any easy way to truncate the LDF file of SQL SERVER?	● 请推荐一本自学SQL的书吧
● Oracle求助，thanks!!!	● sql server 面试题（6）
● Import data from excel into sql server 2000	● which sys sp (sql server) show all user sp and functions?
● Truncation error import csv file to SQL table	● 发包子，每周一题
● help: SQL Server数据同步复制	● SQL 2008 Create Index vs Rebuild Index (Alter Index)
● stupid stupid sql server-- what should I do?	● question about MS SQL mirroring...
● 问Jackrun, Beijing等大侠performance问题	● 如何寫此 SQL 查詢?

相关话题的讨论汇总
话题: set话题: ansi话题: off话题: warnings话题: user

进入Database版参与讨论

1

(共1页)

m**k 发帖数: 4039	1 发现一个有趣的问题, 同样一个stored proc, 用我的user name run是好的, 用我们的一个general account run就会出现"String or binary data would be truncated." error 我知道用set ansi_warning off的办法可以suppress这个warning. 那么这个是因为我的user account by default就设了这个么? 如果是的话, 在哪里可以设这个? 多谢了先.
j*****n 发帖数: 1781	2 you can put it into your SP. from BOL: SET ANSI_WARNINGS OFF Requires membership in the public role.

1

(共1页)

进入Database版参与讨论

相关主题
● 如何寫此 SQL 查詢?	● Truncation error import csv file to SQL table
● Tempdb full	● help: SQL Server数据同步复制
● varchar (80) 比 varchar(800)的优势？	● stupid stupid sql server-- what should I do?
● 也問 Common Table Expression 问题	● 问Jackrun, Beijing等大侠performance问题
● 请教怎么关闭MYSQL的debug信息	● 谁有电子版的SQL Server2005书，能否共享一下
● Re: Is there any easy way to truncate the LDF file of SQL SERVER?	● 请推荐一本自学SQL的书吧
● Oracle求助，thanks!!!	● sql server 面试题（6）
● Import data from excel into sql server 2000	● which sys sp (sql server) show all user sp and functions?

相关话题的讨论汇总
话题: set话题: ansi话题: off话题: warnings话题: user

未名新帖统计// 7月16日

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

* 这里只显示发帖超过25的版面，努力灌水吧:-)