Advertisement
Guest User

Untitled

a guest
Oct 30th, 2014
170
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. CREATE PROCEDURE [DbbEntriesSchema].[GetAllDbbEntries]
  2. AS
  3. SELECT
  4. [dbb].[Date] AS [Date],
  5. [dbb].[DbbEntryId] AS Id,
  6. [dbb].[Foreman] AS Foreman,
  7. [dbb].[GBOId] AS Gbo,
  8. [dbb].[RuleId] AS [Rule],
  9. [dbb].[MaxMile] AS [AtMaxMile]
  10. ....
  11. ....
  12. FROM [DbbEntriesSchema].[DbbEntries] dbb
  13. RETURN 0
  14.  
  15. Tu te rapelle les crochets c'est par convention et aussi pour escape les
  16. reserve keywords de SQL genre Rule et Date c'est un reserve keyword
  17.  
  18. Ce qui suit le mot AS ...c'est le nom que la colonne du resultat va avoir.
  19. Donc le nom de la propriete c#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement