Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Cross and outer apply
CREATE FUNCTION fn_SomeFunction ( @param int ) RETURNS TABLE AS RETURN ( select 1 as 'func_ID' union select 5 as 'func_ID' ) GO select * from pilots select * from Pilots pilots cross apply [dbo].fn_SomeFunction(pilots.id) ids select * from Pilots pilots outer apply [dbo].fn_SomeFunction(pilots.id) ids
run
|
edit
|
history
|
help
0
table creation
IOU2
Movies
row number
ss sqlpractice2014
Generate xml
tableA
SQL Sequence
Rextester.java
Cinema latinoamericano