USE [DataPRO] GO /****** Object: UserDefinedFunction [dbo].[foo_GetTotalGroupChannelSettingsCount] Script Date: 1/25/2019 2:36:13 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[foo_GetTotalGroupChannelSettingsCount] ( @ChannelId BIGINT ) RETURNS INT AS BEGIN RETURN (SELECT COUNT(*) FROM [DataPro].[dbo].[GroupChannelSettings] WHERE ChannelId = @ChannelId) END GO