Tuesday, October 3, 2017

Get View design in SQL

EXEC sp_helptext 'dbo.databasename.ViewName';

No comments:

Post a Comment

Search hierarchy for a match (TableALLGroup) X++

  Table1 ppt;  select firstonly ppt  order ItemCode, ItemRelation, AccountCode, AccountRelation where      (ppt.ItemCode == TableGroupAll::T...