News for hackers. Stuff that matters.
Re:Literate SQL by zamalek on Sunday June 25, 2017 @11:45AM (#14630531)
With SQL Server you can create TVFs (table-valued functions). So long as they are 'inline' (lacking BEGIN and END) they will be inlined into any query that uses them. If your SQL fu is up to scratch they are extremely powerful - e.g. CROSS APPLYing them is one of the best ways I've seen to do reusable row-level filtering.
Re:Literate SQL by Semaphor on Monday June 26, 2017 @01:12PM (#14638439)
Would you happen to have a link that goes into further detail?