如何在sql server列中插入默认的整数值 [英] how to insert a default integer value in sql server column
本文介绍了如何在sql server列中插入默认的整数值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
CREATE TABLE [dbo]。[Add_emp](
[Sr_no] [ int ] IDENTITY ( 1 , 1 ) NOT NULL ,
[ID_no] [ nvarchar ](max) NOT NULL ,
[Name] [ nvarchar ](max) NOT NULL ,
[F_name] [ nvarchar ](max) NOT NULL ,
[名称] [ nvarchar ] (max) NOT NULL ,
[Station] [ nvarchar的跨度>](最大) NOT NULL ,
[pf_no] [ nvarchar ]( 50 ) PRIMARY KEY NOT NULL ,
[部门] [ nvarchar ](max) NOT NULL ,
[Dob] [< span class =code-keyword> nvarchar ]( 50 ) NOT NULL ,
[Date_of_appoinment] [ nvarchar ](max) NOT NULL ,
[height] [ nvarchar ]( 50 ) NOT NULL ,
[body_mark] [ nvarchar ](max) NULL ,
[地址] [ nvarchar ](max) NOT NULL ,
[Ward_section] [ nvarchar ](max) NOT NULL ,
[ image ] [ nvarchar ](max) NULL ,
[cl] [ int ] NOT NULL DEFAULT ( 8 ),
[lap ] [ int ] NOT NULL DEFAULT ( 15 ),
[Hlap] [ int ] NOT NULL DEFAULT ( 10 ),
)
我试过这个,但它给了我错误
解决方案
创建 TABLE [dbo]。[Add_emp](
[Sr_no] [ int ] IDENTITY ( 1 , 1 ) NOT NULL ,
[ID_no] [ nvarchar ](max)< span class =code-keyword> NOT NULL ,
[名称] [ nvarchar ](max) NOT NULL ,
[F_name] [ nvarchar的](max) NOT NULL ,
[指定] [ nvarchar ](max) NOT NULL ,
[ Station] [ nvarchar ](max) NOT NULL ,
[pf_no] [ nvarchar ]( 50 ) PRIMARY KEY NOT NULL ,
[部门] [ nvarchar ](max) NOT NULL ,
[Dob] [ nvarchar ]( 50 ) NOT NULL ,
[Date_of_appoinment] [nvarchar ](max) NOT NULL ,
[height] [ nvarchar ]( 50 ) NOT NULL ,
[body_mark] [ nvarchar ](max) NULL ,
[地址] [ nvarchar ](max) NOT NULL ,
[Ward_section] [ nvarchar ](max)< span class =code-keyword> NOT NULL ,
[ image ] [ nvarchar ](max) NULL ,
[cl] [ int ] NOT NULL DEFAULT ( 8 ),
[lap] [ int ] NOT NULL DEFAULT ( 15 ),
[Hlap] [ int ] NOT NULL DEFAULT ( 10 )
}
试试这段代码
ALTER TABLE [dbo]。[Add_emp] ADD CONSTRAINT [DF_Add_emp_cl] DEFAULT (( 8 ))< span class =code-keyword> FOR [cl]
GO
ALTER 表 [dbo]。[Add_emp] ADD CONSTRAINT [DF_Add_emp_lap] DEFAULT (( 15 )) FOR [一圈]
GO
ALTER TABLE [dbo]。[Add_emp] ADD CONSTRAINT [DF_Add_emp_Hlap] < span class =code-keyword> DEFAULT (( 10 )) FOR [Hlap ]
CREATE TABLE [dbo].[Add_emp](
[Sr_no] [int] IDENTITY(1,1) NOT NULL,
[ID_no] [nvarchar](max) NOT NULL,
[Name] [nvarchar](max) NOT NULL,
[F_name] [nvarchar](max) NOT NULL,
[Designation] [nvarchar](max) NOT NULL,
[Station] [nvarchar](max) NOT NULL,
[pf_no] [nvarchar](50)PRIMARY KEY NOT NULL,
[Department] [nvarchar](max) NOT NULL,
[Dob] [nvarchar](50) NOT NULL,
[Date_of_appoinment] [nvarchar](max) NOT NULL,
[height] [nvarchar](50) NOT NULL,
[body_mark] [nvarchar](max) NULL,
[Address] [nvarchar](max) NOT NULL,
[Ward_section] [nvarchar](max) NOT NULL,
[image] [nvarchar](max) NULL,
[cl] [int] NOT NULL DEFAULT(8) ,
[lap] [int] NOT NULL DEFAULT(15) ,
[Hlap] [int] NOT NULL DEFAULT(10) ,
)
i have tried this but its giving me error
解决方案
CREATE TABLE [dbo].[Add_emp]( [Sr_no] [int] IDENTITY(1,1) NOT NULL, [ID_no] [nvarchar](max) NOT NULL, [Name] [nvarchar](max) NOT NULL, [F_name] [nvarchar](max) NOT NULL, [Designation] [nvarchar](max) NOT NULL, [Station] [nvarchar](max) NOT NULL, [pf_no] [nvarchar](50)PRIMARY KEY NOT NULL, [Department] [nvarchar](max) NOT NULL, [Dob] [nvarchar](50) NOT NULL, [Date_of_appoinment] [nvarchar](max) NOT NULL, [height] [nvarchar](50) NOT NULL, [body_mark] [nvarchar](max) NULL, [Address] [nvarchar](max) NOT NULL, [Ward_section] [nvarchar](max) NOT NULL, [image] [nvarchar](max) NULL, [cl] [int] NOT NULL DEFAULT(8) , [lap] [int] NOT NULL DEFAULT(15) , [Hlap] [int] NOT NULL DEFAULT(10) }
Try this code
ALTER TABLE [dbo].[Add_emp] ADD CONSTRAINT [DF_Add_emp_cl] DEFAULT ((8)) FOR [cl] GO ALTER TABLE [dbo].[Add_emp] ADD CONSTRAINT [DF_Add_emp_lap] DEFAULT ((15)) FOR [lap] GO ALTER TABLE [dbo].[Add_emp] ADD CONSTRAINT [DF_Add_emp_Hlap] DEFAULT ((10)) FOR [Hlap]
这篇关于如何在sql server列中插入默认的整数值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文