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

Function Table not available in MSSQL

renunganpagi posted 2 years ago in General
Function scalar detected, but Function table not detected
Pleaseeeee.....
wink

GBU
ansgar posted 2 years ago
What?
fmarangoni posted 12 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 12 months ago
What is a "table-valued" function? And where in HeidiSQL exactly do you expect these to see?
fmarangoni posted 12 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 12 months ago
please give an example.
aalbonico posted 12 months ago
I have the same problem.
fmarangoni posted 12 months ago
create FUNCTION dbo.test()
RETURNS table
AS
RETURN
SELECT 1 AS RESULT
jfalch posted 12 months ago
what is the version of sql server you are using ? (select @@version)
fmarangoni posted 12 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.