开发者

SQL Server Express 2005 Ambiguous column name

开发者 https://www.devze.com 2022-12-08 06:39 出处:网络
I am using SQL Server 2005 Express. While I am executed the query I am getting wrong values select City, City2

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

精彩评论

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