数据库函数实例的小例子 有助于初学者更好的理解存储过程的操作

(55720085) 16:54:36
declare @userid varchar(128)
set @userid = '01|02|03|04|05'

select userid from users where '|'+@userid+'|'  like '%|'+userid+'|%'
³ÂѧǬ(55720085) 16:55:36
declare @RoleID char(12)
declare @prex char(8)
declare @index int
declare @tableName varchar(32)
declare @keyfield varchar(32)

declare @sql nvarchar(256)
select  @prex = convert(char(8),dateadd(day,1, getdate()),112),
@tableName='[Role]',
@keyfield = 'roleid',
@index =0,
@sql = 'select @index = isnull(max(cast(right('+@keyfield+',4) as int)),0) from '+@tableName+N' where left('+@keyfield+',8) = @prex'
--@sql = N'select @index = max(cast(right(roleid,4) as int)) from [role] where left(roleid,8) = ''20090217'''

exec sp_executesql @sql,N'@index int output,@prex char(8)',@index output,@prex

select @index,@keyfield,@tableName,@prex

select  max(cast(right(roleid,4) as int)) from [role] where  left(roleid,8) = @prex