Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.41K
Hello all, i have SQL 2005 installed. i have written a table-valued function getdepartments() which is as below: [code] CREATE FUNCTION getdepartments() RETURNS @departments TABLE( DNAME VARCHAR(25), DEPTID VARCHAR(10), DBONUS DECIMAL(7,2)) AS BEGIN INSERT @departments SELECT * FROM DEPARTMENT; RETURN END [/code] i need to invoke this statement from java … |