Skip to content

Instantly share code, notes, and snippets.

@jcdickinson

jcdickinson/tvf.sql Secret

Created January 16, 2019 23:44
Show Gist options
  • Save jcdickinson/61a38dedb84b35251da301b128535ceb to your computer and use it in GitHub Desktop.
Save jcdickinson/61a38dedb84b35251da301b128535ceb to your computer and use it in GitHub Desktop.
Download ZIP
Inlined TVF
Raw
tvf.sql
CREATE FUNCTION [fnConstant]()
RETURNS TABLE WITH SCHEMABINDING AS RETURN SELECT 2 AS [Constant];
GO
SELECT *, [Constant] FROM [Blob]
CROSS APPLY [dbo].[fnConstant]()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment