22,209
社区成员
发帖
与我相关
我的任务
分享help!!!
declare @end_time char(11)
declare @number int
set @sql='select min(id) from'+' Submit'+@end_time
exec(@sql)
我怎样帮查询的结果放在@number 中
declare @number int
set @sql='select min(id) from'+' Submit'+@end_time
exec(@sql)
我怎样帮查询的结果放在@number 中
...全文
请发表友善的回复…
发表回复
xiaofeng007 2003-10-16
- 打赏
- 举报
快救救我啦，怎么没有人告诉我
xiaofeng007 2003-10-16
- 打赏
- 举报
过程需要参数 '@statement' 为 'ntext/nchar/nvarchar' 类型。
xiaofeng007 2003-10-16
- 打赏
- 举报
'@number' 附近有语法错误。
是怎么一回事？
是怎么一回事？
friendliu 2003-10-16
- 打赏
- 举报
declare @end_time char(11)
declare @number int
set @sql='select @number=min(id) from'+' Submit'+@end_time
exec sp_executesql @sql,N'@number int number output','@number,output'
select @number
go
declare @number int
set @sql='select @number=min(id) from'+' Submit'+@end_time
exec sp_executesql @sql,N'@number int number output','@number,output'
select @number
go
LoveSQL 2003-10-16
- 打赏
- 举报
declare @end_time char(11)
declare @sql nvarchar(4000)
declare @number int
set @sql='select @number =min(id) from'+' Submit'+@end_time
exec sp_executesql @sql,N'@number int output','@number output'
select @number
declare @sql nvarchar(4000)
declare @number int
set @sql='select @number =min(id) from'+' Submit'+@end_time
exec sp_executesql @sql,N'@number int output','@number output'
select @number
LoveSQL 2003-10-16
- 打赏
- 举报
declare @end_time char(11)
declare @number int
set @sql='select @number =min(id) from'+' Submit'+@end_time
exec sp_executesql @sql,N'@number int output,'@number output'
select @number
declare @number int
set @sql='select @number =min(id) from'+' Submit'+@end_time
exec sp_executesql @sql,N'@number int output,'@number output'
select @number
