DOT NET developer blog: SQL Stored function Return table

Scenario:

Return table from SQL function

Solution:

  
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13 CREATE FUNCTION [schema].FnGetUserId()
RETURNS @Users TABLE (
  UserID                      INT,
  [Name]                      VARCHAR(50))
AS
  BEGIN
          INSERT INTO @Users VALUES (1, 'Ram')
	  INSERT INTO @Users VALUES (2, 'Shyam')

      RETURN
  END

GO

DOT NET developer blog

SQL Stored function Return table

Scenario:

Solution:

1 2 3 4 5 6 7 8 9 10 11 12 13
CREATE FUNCTION [schema].FnGetUserId() RETURNS @Users TABLE ( UserID INT, [Name] VARCHAR(50)) AS BEGIN INSERT INTO @Users VALUES (1, 'Ram') INSERT INTO @Users VALUES (2, 'Shyam') RETURN END GO

No comments:

Post a Comment

Move Github Sub Repository back to main repo

SQL Stored function Return table

Scenario:

Solution:

1 2 3 4 5 6 7 8 9 10 11 12 13CREATE FUNCTION [schema].FnGetUserId() RETURNS @Users TABLE ( UserID INT, [Name] VARCHAR(50)) AS BEGIN INSERT INTO @Users VALUES (1, 'Ram') INSERT INTO @Users VALUES (2, 'Shyam') RETURN END GO

No comments:

Post a Comment

Move Github Sub Repository back to main repo

1 2 3 4 5 6 7 8 9 10 11 12 13
CREATE FUNCTION [schema].FnGetUserId() RETURNS @Users TABLE ( UserID INT, [Name] VARCHAR(50)) AS BEGIN INSERT INTO @Users VALUES (1, 'Ram') INSERT INTO @Users VALUES (2, 'Shyam') RETURN END GO