c# SqlConnection 执行复杂的sql语句出错

[jack2684]

c#执行如下语句，出错。无论用nonqueryexcute还是readerexcute都不行

string strSql = @"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 ";

---------------------------------
error:关键字 'select' 附近有语法错误。 关键字 'select' 附近有语法错误。 关键字 'then' 附近有语法错误。 'end' 附近有语法错误。

[jack2684]

上面有点乱，改一下

string strSql = @"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 ";

[EnForGrass]

[Quote=引用 1 楼 jack2684 的回复:]

上面有点乱，改一下
C# code

string strSql = @"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 sele……
[/Quote]
你最好把它写成存储过程来执行

[Csharp_琪]

这个应该就是sql语句的错误了，你在sqlserver里面先执行下试试

[rekym]

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";

//改成这样 　不要 then end 这个语法错误,LZ试下

[EnForGrass]

[Quote=引用 1 楼 jack2684 的回复:]

上面有点乱，改一下
C# code

string strSql = @"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 sele……
[/Quote]
在sql版回答了
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

[dalmeeme]

[Quote=引用 2 楼 chinajiyong 的回复:]
引用 1 楼 jack2684 的回复:

上面有点乱，改一下
C# code

string strSql = @"declare @type char
declare @id bigint
set @id = select max(Sid) from Stream
set @type = select StreamType from Stream where Sid=@id
……
[/Quote]
同意，改成存储过程执行比较好。

[色拉油]

断点调试，看看你生成的SQL语句是什么，拿到数据库里执行，看看到底哪里出错了[Quote=引用 4 楼 rekym 的回复:]

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";

//改成这样 　不要 then……
[/Quote]