What does the TAB keyword do in SQL Server? -


i used code internet model of queries stored procedure. uses keyword tab , have no idea does. can explain me?

here code:

select * #dailyreport     (select a.customer,b.cust_name, opendt, txdate [date], salesamt      daily left outer join customer b on a.customer =b.customer      txdate between @begin , @end)  tab  select * #dailytx     (select customer, txdate [date], salestx daily      txdate between @begin , @end)  tab 

this not keyword, alias. user left out keyword (which legal sql , allowed)

select * #dailytx   (select customer, txdate [date], salestx daily     txdate between @begin , @end) tab 

sql server requires sub-queries aliased writter picked first 3 letters of table guess. tmp might have been clearer. variable name.


Comments