Monday, 27 August 2012

How to give the Alias Name with space in sql Server 2008



ALTER  procedure [dbo].[Inventory_Alerts]
as
begin

select (select Itemname from TechInventory_ItemName where Id=a.Itemname)as ‘Item Name’ ,DateDiff(dd,getdate(),TentativeAlert)as ‘Remaining Days’ from TechInventory_Create as a where TentativeAlert is not null and DateDiff(dd,getdate(),TentativeAlert)=1


end

No comments:

Post a Comment