开发者

SQL Server Express 2005 Ambiguous column name

I am using SQL Server 2005 Express.

While I am executed the query I am getting wrong values

 select City, City2
    from
        sample.dbo.NameAddress 
    where
        FirstName like 'rama%' 
        and LastName like 'suresh%'

Getting same values for the both columns but actually they are different in DB,

When I see entire table it is show开发者_C百科ing exact values.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜