Thursday, March 22, 2012
difference
create table #temp(id int,col1 int,col2 int)
go
select id,col1[Field1],col2[Field2] from #temp
select id,col1 as [Field1],col2 as [Field2] from #temp
go
drop table #temp
go
Is there a difference between these 2 select statements in terms of the
column names and results returned to ado.net client.?
thxAFAIK, no.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||There is no difference. The client will see "id, Filed1, Filed2".
Perayu
"skg" <skg@.yahoo.com> wrote in message
news:uECDpaDTGHA.776@.TK2MSFTNGP09.phx.gbl...
>
> create table #temp(id int,col1 int,col2 int)
> go
> select id,col1[Field1],col2[Field2] from #temp
> select id,col1 as [Field1],col2 as [Field2] from #temp
> go
> drop table #temp
> go
> Is there a difference between these 2 select statements in terms of the
> column names and results returned to ado.net client.?
> thx
>|||Thanks all !!. We have an ado.net application which is working when we use
the As and not [] in the select statement.
I will investigate further and update you if i find something
"Perayu" <yu.he@.state.mn.us.Remove4Replay> wrote in message
news:uMmP7jDTGHA.5108@.TK2MSFTNGP11.phx.gbl...
> There is no difference. The client will see "id, Filed1, Filed2".
> Perayu
> "skg" <skg@.yahoo.com> wrote in message
> news:uECDpaDTGHA.776@.TK2MSFTNGP09.phx.gbl...
>sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment