网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
在SQL Server中，nchar数据类型与nvarchar数据类型的区别是，前者是固定长度的，后者是可变长度的。
参考答案
更多 “在SQL Server中，nchar数据类型与nvarchar数据类型的区别是，前者是固定长度的，后者是可变长度的。” 相关考题
考题
设有职工表（职工号，姓名，地址1，地址2），其中，职工号为主码。现要求地址1和地址2组合起来不能有重复值。在SQL Server 2008环境中有下列创建该表的语句：1．CREATE TABLE职工表（职工号int PRIMARY KEY，姓名nchar（10），地址1 nvarchar（20），地址2 nvarchar（20），UNIQUE（地址1，地址2））Ⅱ：CREATE TABLE职工表（职工号int PRIMARY KEY，姓名nchar（10），地址1nvarchar（20）．地址2 nvarchar（20）UNIQUE（地址1，地址2））Ⅲ．CREATE TABLE职工表（职工号int PRIMARY KEY．姓名nchar（10），地址1 nvarchar（20）UNIQUE，地址2 nvarchar（20）UNIQUE）IV．CREATE TABLE职工表（1职工号int PRIMARY KEY。姓名nchar（10），地址1 nvarchar（20）UNIQUE（地址1，地址2），地址2 nvarchar（20））上述语句能正确实现此约束的是（ ）。A.仅Ⅰ和ⅢB.仅Ⅱ和ⅣC.仅Ⅰ、Ⅱ和ⅣD.都正确
考题
sql server 2005中的nvarchar(MAX)和xml有什么区别
通过：Connection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Columns,newobject[]{null,null,tableName,null});得到的两种数据类型的属性完全一致，有其它方法区分吗？
考题
设有表M，将其中的Type列的数据类型改为NCHAR（4）。下列能实现该功能的语句是（）。AALTER TABLE M ADD COLUMN Type NCHAR（4）BALTER TABLE M ALTER COLUMN Type NCHAR（4）CALTER TABLE M DROP COLUMN Type NCHAR（4）DALTER TABLE M ALTER Type NCHAR（4）
考题
在SQL Server中，修改表中列定义的正确的SQL语句是（）。A、ALTER TABLE 表名 ALTER COLUMN 列名 数据类型B、ALTER TABLE 表名 ALTER 列名 数据类型C、ALTER TABLE MODIFY COLUMN 列名 数据类型D、ALTER TABLE 表名 ADD 列名 数据类型
考题
SQL Server提供的Nchar、Nvarchar、Ntext等几种双字节数据类型实际上是一种（）。A、Unicode数据类型B、ASCII数据类型C、时间戳数据类型D、数值型类型
考题
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）A、A primary XML index should be created on the XML column.B、Statistics should be created on the nvarchar columns.C、A view should be created， and only the four columns that the query utilizes are contained by a view.D、A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.
考题
单选题SQL Server提供的Nchar、Nvarchar、Ntext等几种双字节数据类型实际上是一种（）。A
Unicode数据类型B
ASCII数据类型C
时间戳数据类型D
数值型类型
考题
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）A
A primary XML index should be created on the XML column.B
Statistics should be created on the nvarchar columns.C
A view should be created， and only the four columns that the query utilizes are contained by a view.D
A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.
考题
单选题货币数据类型在SQL SERVER2008中用（）表示A
intB
datetimeC
moneyD
tinyint
热门标签
最新试卷
