题目内容

You work in a Organization which is named Wiikigo Corp. The Organization uses SQL Server 2008. You are the administrator of the Organization database. Now you are in charge of a SQL Server 2008 instance. Look at the following query: SELECT s.*, i.* FROM SensitiveTbl AS s INNER JOIN InsensitiveTbl AS iON i. OrganizationName = s.OrganizationName You use the above query to join two tables on a column named OrganizationName. The following error is returned when you execute the query. "Msg 468, Level 16, State 9, Line 17 Cannot resolve the collation conflict between 'SQL_Latin1_General_CP1_CS_AS' and 'SQL_Latin1_General_CP1_CI_AS' in the equal to operation." The ON clause of the query has to be modified so that it can perform a case-sensitive joinsuccessfully. What should you do? ()

A. ON LOWER(i.OrganizationName) = LOWER(s.OrganizationName)
B. ON UPPER(i.OrganizationName) = UPPER(s.OrganizationName)
C. ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CS_AS
D. ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CI_AS&e

查看答案
更多问题

下述零件不属于气门传动组的是()。

A. 凸轮轴
B. 气门
C. 液力挺柱

关于婴儿正常尿量的描述正确的是()。

A. 年纪越小,按体表面积计算尿量越少
B. 尿量多少与周围气温高低无关
C. 人工喂养的排尿量多于母乳喂养
D. 母乳喂养的排尿量多于人工喂养

能输出频率信号的空气流量传感器肯定是()。

A. 叶片式
B. 热线式
C. 卡门旋涡式

关闭可燃气体或可然液体的阀门时采用()灭火。

A. 隔离法
B. 窒息法
C. 抑制法

答案查题题库