Advertisement
Guest User

Untitled

a guest
Aug 9th, 2018
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.26 KB | None | 0 0
  1. Create function [dbo].[UDF_GetFilteredPublicOffers](
  2.     @parametr int
  3. )
  4. returns @retResult table
  5. (
  6.     OfferID int,
  7.     ProjectID int,
  8.     PublishedDate datetime,
  9. )
  10. as
  11. begin
  12. insert @retResult
  13.     select
  14.         t.OfferId,
  15.         t.ProjectID,
  16.         t.PublishedDate From Offer
  17. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement