Question

I m试图在表格中插入一些数据,包括两件:“插图”和“在<条码>中的最大数字<>Order栏+1”。

这是我提出的问题:

INSERT INTO MyTable ([Text],[Order]) 
SELECT  MyText  , (Max([Order]) + 1) 
FROM MyTable

我的询问有什么错误?

I m 采用Microk服务器 2005 SP3。

Answer 1

你们可以检验这样的问题:

我没有错误:

create table #MyTable
(
    [Text] varchar(40),
    [Order] int NOT NULL
)
INSERT INTO #MyTable([Text],[Order]) 
SELECT  MyText  [Text], isnull(max([或der]) + 1, 0) [Order] 
FROM #MyTable

drop table #MyTable

原件:

INSERT INTO MyTable ([Text],[Order]) 
SELECT  MyText  [Text], max([Order]) + 1 [Order] 
FROM MyTable

或

INSERT INTO MyTable ([Text],[Order]) 
SELECT top 1  MyText  [Text], max([Order]) + 1 [Order] 
FROM MyTable

如我所知,在服务器中,限额无效。

Answer 2

不能将国家扫盲委员会的价值列入第1栏,表主.dbo.MyTable;一栏不允许无效。 INSERT失败。声明已终止。

This means that the Order column isn t allowed to be null, and that the Max([Order]) + 1 part of your column returns NULL.
This is because your table is empty, as you already noticed by yourself.

您可以通过在询问中以实数取代NUL,使用::

INSERT INTO MyTable ([Text],[Order]) 
SELECT  MyText  , (isnull(Max([Order]),0) + 1) 
FROM MyTable

Answer 3

Unless he has a section listed OrderBy

then he would have to add / assign all values within that Insert especially if the column does not allow for nulls sounds like fully qualifying the Insert with the dbo.MyTable.Field may make more sense. also why are you naming fields with SQL Key words...???

INSERT INTO MyTable ([Text],[Order] Values( MyTextTest ,1)

试验首先插入。

友情链接