Functions in SqlServer

Posts   
 
    
PAZIMLI
User
Posts: 82
Joined: 01-May-2008
# Posted on: 20-Oct-2008 10:50:43   

llblgen Pro v2.5 SqlServer 2000 Adapter C#.Net

I create function in SqlServer as stated below; but when i refresh the llblgen projects, it is not seen under Action Stored procedures or retrieval action procedures. The same function also exists on Oracle 10g and it is seen on the llblgen project under Action Stored procedures.

Create FUNCTION dbo.SYS_ZAMANI() RETURNS DATETIME AS BEGIN DECLARE @dt DATETIME SELECT @dt = dt FROM OPENQUERY ( SERVER, 'SELECT dt = GETDATE()' ) RETURN @dt END

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 20-Oct-2008 10:56:06   

These are directly called from code.

Please check Calling a database function