A third party vendor has a table with a field name of "desc" in it. Since "desc" is a reserved term in SQL Server 2005 how does one query Table.Desc ?
when you try it with table.desc it errors since it turned blue being a reserved word.
Jeff
I did this and it would not create the column. I have tried:
table.[desc]
[table].[desc]
Neither of which worked.
Jeff
I just ran this code in sql 2005:
create
table #tmp( [desc] varchar(10))insert
into #tmp values( 'one')select
#tmp.[desc] from #tmpIs your table actually named "Table"?
Even if your table is called “table” you should be able to query it.
For example,
create table [table]([desc] char(10))
go
insert into [table] values ('test')
go
select [desc] from [table]
go
When you said it did not work, what was the error message? What is the version of SQL Server are you using?
Consult this Books Online topic http://msdn2.microsoft.com/en-US/library/ms176027(SQL.90).aspx for more information.
HTH,
Boris.
There wasn't an error, it just didn't show the desc column in the resultset grid.
ALTER
PROCEDURE [dbo].[SUR_GiftsDetail]@StartDate
DateTime,@EndDate
DateTimeAS
BEGIN
SET NOCOUNT ON; SELECTItemID
,Quantity
,TourID
,TourNumber
,MasterID
,Description
MasterCatID
,CategoryID
,CategoryDescription
,Arrival
,Depart
,BookingID
,it_arrival_date
FROM (SELECTBooking
.bk_id AS BookingID,i
.it_arrival_date AS Arrival,i
.it_arrival_date,i
.it_id AS TourNumber,i
.it_arrival_date + i.it_nights AS Depart,pt
.fk_itemid AS ItemID,pt
.Qty AS Quantity,pt
.fk_tourid AS TourID,pm
.ItemID AS MasterID,pm
.[desc] AS Description,pm
.fk_categoryID AS MasterCatID,pc
.categoryID AS CategoryID,pc
.[Desc] AS CategoryDescription FROMBooking
LEFT JOIN ITINERARY i ON Booking.bk_id = i.fk_bk_id LEFT JOIN pi_transactions pt ON pt.fk_tourid = Booking.bk_id LEFT JOIN pi_master pm ON pm.itemid = pt.fk_itemid LEFT JOIN pi_category pc ON pc.categoryid = pm.fk_categoryid LEFT JOIN pi_transactions ptt ON ptt.fk_itemid = pm.itemid WHEREi
.it_arrival_date BETWEEN @StartDate AND @EndDate AND i.fk_et_entity_type LIKE 'Hotel') AS derivedTour WHEREit_arrival_date
BETWEEN @StartDate AND @EndDate ORDER BYTourID
END
All the columns show except for the two desc fields.
SQL Server 2005
Jeff
