declare @type char
declare @id bigint
set @id = select max(Sid) from Stream
set @type = select StreamType from Stream where Sid=@id
if @type = 'a' then select Talk.Talk,UserOfUp.Latitude,UserOfUp.Longtitude from UserOfUp,Talk,Stream where UserOfUp.UserId = 1 and Stream.StreamId = Talk.TalkId and Stream.Sid = @id
end
消息 156,级别 15,状态 1,第 3 行
关键字 'select' 附近有语法错误。
消息 156,级别 15,状态 1,第 4 行
关键字 'select' 附近有语法错误。
消息 156,级别 15,状态 1,第 5 行
关键字 'then' 附近有语法错误。
消息 102,级别 15,状态 1,第 6 行
'end' 附近有语法错误。
declare @type char
declare @id bigint
set @id = (select max(Sid) from Stream)
set @type = (select StreamType from Stream where Sid=@id)
if @type = 'a' then
(select Talk.Talk,UserOfUp.Latitude,UserOfUp.Longtitude from UserOfUp,Talk,Stream where UserOfUp.UserId = 1 and Stream.StreamId = Talk.TalkId and Stream.Sid = @id)
end记得加括号
declare @type char
declare @id bigint
set @id = (select max(Sid) from Stream )
set @type = (select StreamType from Stream where Sid=@id )
if @type = 'a'
begin
select Talk.Talk,UserOfUp.Latitude,UserOfUp.Longtitude from UserOfUp,Talk,Stream where UserOfUp.UserId = 1 and Stream.StreamId = Talk.TalkId and Stream.Sid = @id
end
declare @id bigint
set @id = (select max(Sid) from Stream)
set @type = (select StreamType from Stream where Sid=@id)
if @type = 'a'
select Talk.Talk,UserOfUp.Latitude,UserOfUp.Longtitude from UserOfUp,Talk,Stream where UserOfUp.UserId = 1 and Stream.StreamId = Talk.TalkId and Stream.Sid = @iddeclare @type char
declare @id bigint
select @id = max(Sid) from Stream
select @type = StreamType from Stream where Sid=@id
if @type = 'a'
select Talk.Talk,UserOfUp.Latitude,UserOfUp.Longtitude from UserOfUp,Talk,Stream where UserOfUp.UserId = 1 and Stream.StreamId = Talk.TalkId and Stream.Sid = @id