distal-attribute
distal-attribute
distal-attribute
distal-attribute

Function Table not available in MSSQL

renunganpagi posted 1 year ago in General
Function scalar detected, but Function table not detected
Pleaseeeee.....
;)

GBU
ansgar posted 1 year ago
What?
fmarangoni posted 3 months ago
I cannot see Table-valued functions in HeidiSQL for MSSQL. Is there a way to do this that I am missing?
ansgar posted 3 months ago
What is a "table-valued" function? And where in HeidiSQL exactly do you expect these to see?
fmarangoni posted 3 months ago
Table- valued funcion is a SQL function that is created by the user with a simple SQL statement that returns a SQL select result set. It should appear in the tree on the left along with tables, views, stored procedures.

jfalch posted 3 months ago
please give an example.
aalbonico posted 3 months ago
I have the same problem.
fmarangoni posted 3 months ago
create FUNCTION dbo.test()
RETURNS table
AS
RETURN
SELECT 1 AS RESULT
jfalch posted 3 months ago
what is the version of sql server you are using ? (select @@version)
fmarangoni posted 3 months ago
Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (X64)
Feb 25 2011 13:56:11
Copyright (c) 1988-2008 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)

Please login to leave a reply, or register at first.