如何改变这种类型的表 [英] How to alter this type of table

问题描述

CREATE TABLE [dbo]。[BTU_MISReport]（

[BusinessDate] [date] NULL，

[BRANCH_NAME] [nvarchar]（max）NULL，

[BR_CODE] [nvarchar]（50）NULL，

[Name_of_Valuer] [nvarchar]（150）NOT NULL，

[ADDRESS] [int ] NULL，

[LIST_OF_BR] [nvarchar]（max）NULL，

[Score_Grade] [int] NULL，

[GoldSmith_PROP_NAME] [ nvarchar]（150）NOT NULL，

[Authorized_Signatory1] [int] NULL，

[Authorization_Date1] [int] NULL，

[Authorized_Signatory2 ] [int] NULL，

[Authorization_Date2] [int] NULL，

[Authorized_Signatory3] [int] NULL，

[Authorization_Date3] [ int] NULL，

[FinalStatus] [int] NULL，

[致谢] [int] NULL，

[Date_of_HandinG] [int] NULL，

[Remarks_Anomalies] [int] NULL，

[Receiving_Date] [int] NULL，

[Intimation] [int] NULL，

[AgreementDate] [date] NULL，

[AgreementExpiryD ate] [date] NULL，

[CancelledAgreement] [int] NULL，

[AgreementCancelIntimationDate] [int] NULL，

[评论] [int] NULL，

[原因] [int] NULL，

[协议] [varchar]（17）NOT NULL，

[状态] [nvarchar]（50）NOT NULL

）ON [PRIMARY] TEXTIMAGE_ON [主要]



我尝试过什么：



我需要改变这个表，但也想改变列数据类型，例如

[ADDRESS] [int ] NULL，到[ADDRESS] [nvarchar]（Max）NULL，



请帮我解决这个问题。

解决方案

  ALTER   TABLE  MyTable 
 < span class =code-keyword> ALTER   COLUMN  ColumnName  NVARCHAR （MAX）; 

快速谷歌会发现你...... SQL ALTER TABLE语句 [ ^ ]

CREATE TABLE [dbo].[BTU_MISReport](
[BusinessDate] [date] NULL,
[BRANCH_NAME] [nvarchar](max) NULL,
[BR_CODE] [nvarchar](50) NULL,
[Name_of_Valuer] [nvarchar](150) NOT NULL,
[ADDRESS] [int] NULL,
[LIST_OF_BR] [nvarchar](max) NULL,
[Score_Grade] [int] NULL,
[GoldSmith_PROP_NAME] [nvarchar](150) NOT NULL,
[Authorized_Signatory1] [int] NULL,
[Authorization_Date1] [int] NULL,
[Authorized_Signatory2] [int] NULL,
[Authorization_Date2] [int] NULL,
[Authorized_Signatory3] [int] NULL,
[Authorization_Date3] [int] NULL,
[FinalStatus] [int] NULL,
[Acknowledgement] [int] NULL,
[Date_of_HandinG] [int] NULL,
[Remarks_Anomalies] [int] NULL,
[Receiving_Date] [int] NULL,
[Intimation] [int] NULL,
[AgreementDate] [date] NULL,
[AgreementExpiryDate] [date] NULL,
[CancelledAgreement] [int] NULL,
[AgreementCancelIntimationDate] [int] NULL,
[Comments] [int] NULL,
[Reason] [int] NULL,
[Agreement] [varchar](17) NOT NULL,
[STATUS] [nvarchar](50) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

What I have tried:

I need to alter this table but also want to alter the columns datatypes for example
[ADDRESS] [int] NULL, to [ADDRESS] [nvarchar] (Max) NULL,

Please help me out in this matter.

解决方案

ALTER TABLE MyTable
ALTER COLUMN ColumnName NVARCHAR(MAX);

A quick google would have found you that... SQL ALTER TABLE Statement[^]

这篇关于如何改变这种类型的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！