34,587
社区成员
发帖
与我相关
我的任务
分享
insert into Tbale
(字段名)
select 字段名 from Table where 条件 我无法插入生成的ID编号
DECLARE @SPRSID nvarchar(30)
SET @SPRSID=dbo.f_Next('A_B')
DECLARE @SPRSID nvarchar(30),@a nvarchar(30),@b nvarchar(30),@sql nvarchar(300),@num int ,@i int
set @sql='select top 1 BID from [A_B] where AID=@a and SPRSID not in (select top'+cast(@num as varchar) +SPRSID from A_B order by SPRSID asc) order by SPRSID asc
set @b=exec @sql
declare @sql nvarchar(4000),@b int
set @sql=N'...'
exec sp_executesql @sql,N'@b int output',@b output
请给出表结构,测试数据,具体算法和结果,谢谢。
declare @sql nvarchar(4000),@b int
set @sql=N'...'
exec sp_executesql @sql,N'@b int output',@b output
declare @num int,@sql nvarchar(3000),@CourseID nvarchar(30),@a float(30),@CoursePeriod nvarchar(8),@SubjectID nvarchar(30)
set @num=1
set @SubjectID='S09030004'
set @sql='select top 1 CoursePeriod from OLTR_StudySubjectRCourse
where SubjectID='''+@SubjectID+''' and SSRCoID not in (select top '+cast(@num as varchar)+' SSRCoID from OLTR_StudySubjectRCourse order by SSRCoID asc)
order by SSRCoID asc'
exec sp_executesql @sql,@CoursePeriod output
declare @num int,@sql nvarchar(3000),@CourseID nvarchar(30),@a float(30),@CoursePeriod nvarchar(8),@SubjectID nvarchar(30)
set @num=1
set @SubjectID='S09030004'
set @sql=N'select CourseID from OLTR_StudySubjectRCourse where SubjectID='''+@SubjectID+''''
exec sp_executesql @sql
exec exec (@sql)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~``sql
select top 1 CourseID from OLTR_StudySubjectRCourse
where SubjectID='S09030004'
and SSRCoID not in (select top 0 SSRCoID from OLTR_StudySubjectRCourse order by SSRCoID asc)
order by SSRCoID asc
declare @num int,@sql nvarchar(3000),@CourseID nvarchar(30),@a float(30),@CoursePeriod nvarchar(8),@SubjectID nvarchar(30)
set @num=1
set @SubjectID='S09030004'
set @sql='select top 1 CoursePeriod from OLTR_StudySubjectRCourse
where SubjectID='+@SubjectID+' and SSRCoID not in (select top '+cast(@num as varchar)+' SSRCoID from OLTR_StudySubjectRCourse order by SSRCoID asc)
order by SSRCoID asc'
exec sp_executesql @sql,@CoursePeriod output
有自动增长的列先这样.
set identity_insert 表名 on
...插入语句.
set identity_insert 表名 off