This project is read-only.

 


fn_recs_gen (Transact_SQL)

See also: 


 

This scalar UDF generates a table with the specified number of records. It has two fields: id and rand_id. 
 

Syntax

 fn_recs_gen(@recs_to_gen,@rand_flag)

 

Arguments

@recs_to_gen = BIGINT, number of records to generate;

@rand_flag = BIT, flag indicating if column rand_id will be populated with random values.

 

Return type

TABLE (id BIGINT, rand_id BIGINT)

Remarks

none

 

Permissions

Public

 

Dependencies

none

 

Examples

SELECT* FROM [Lib].[tsql].[fn_recs_gen](1000,1)

 

Other

none

 

Last edited Aug 27, 2012 at 7:57 PM by adudau, version 5

Comments

No comments yet.