CREATE FUNCTION NextID (@tblName nvarchar(100))
RETURNS char(10)
AS
BEGIN
Declare @Temp char(10)
Select @Temp = 'Select Max(ID) from '+@tblName
return @Temp
END
RETURNS char(10)
AS
BEGIN
Declare @Temp char(10)
Select @Temp = 'Select Max(ID) from '+@tblName
return @Temp
END
解决方案 »
- 查询一个表的所有字段
- 有哪位大虾能提供T-SQL的语法树?
- 求一个sql
- 能否将sql备份文件直接转成excel
- 请教:如何还原数据库中的用户权限
- 请问怎样在MS sql中直接连接oracle然后访问oracle数据库中的某些表
- 有关"select * into backup from source where 1<>1"和自动增值
- 怎样把数据库里一个bit字段的值取为相反的值
- 求一个的sql语句,查询时间范围,并且需要分组~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
- 关于外键字段是否要加索引的问题
- 这样的问题碰到很久了,一直不知道怎么解决,哪位高手指点一下啊
- 关于大型集团信息门户网站的数据库设计,有这方面经验的请进!!!
@Temp char(10) output
AS
BEGIN
Declare @Temp char(10)
Select @Temp = 'Select Max(ID) from '+@tblName
exec @Temp
END
CREATE FUNCTION NextID (@tblName nvarchar(100))
RETURNS char(10)
AS
BEGIN
Declare @Temp char(10)
Select @Temp = EXEC('Select Max(ID) from '+@tblName)
return @Temp
END
如果你要在存储过程中运行得到结果的话
CREATE proc NextID @tblName nvarchar(100),
@Temp char(10) output
AS
BEGIN
Declare @Temp char(10)
Select @Temp = 'Select Max(ID) from '+@tblName
exec @Temp
END函数
CREATE FUNCTION NextID (@tblName nvarchar(100))
RETURNS char(10)
AS
BEGIN
Declare @Temp char(10)
Select @Temp = 'Select Max(ID) from '+@tblName
exec @Temp
return @Temp
END
RETURNS char(10)
AS
BEGIN
Declare @Temp char(10),@slqstr varchar(300)
Select @sqlstr = 'select Max(ID) as maxid into #temptable1 from '+@tblName
exec @sqlstr
select @temp = maxid from #temptable1
drop table #temptable1
return @Temp
END
Create proc NextID @tblName nvarchar(100),
@Temp char(100) output
AS
BEGIN
set @Temp = 'Select Max(ID) from '+@tblName
exec(@Temp)
ENDdeclare @result varchar(100)
exec up_NextID 'tablename',@result output
print @result
@Temp char(100) output
AS
BEGIN
set @Temp = 'Select Max(ID) from '+@tblName
exec(@Temp)
END
set @Temp = 'Select Max(ID) from '+@tblName
exec(@Temp)
END
exec(@Temp)
RETURNS char(10)
AS
BEGIN
Set @tblName='Spda'
Declare @Temp char(10),@SqlTxt VarChar(1000)
Set @SqlTxt='Select @Temp=Max(Jhj) from '+@tblName
Exec sp_executesql N@Sqltxt,N'@level tinyint',@level=35
return @temp
END