Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE [DbbEntriesSchema].[GetAllDbbEntries]
- AS
- SELECT
- [dbb].[Date] AS [Date],
- [dbb].[DbbEntryId] AS Id,
- [dbb].[Foreman] AS Foreman,
- [dbb].[GBOId] AS Gbo,
- [dbb].[RuleId] AS [Rule],
- [dbb].[MaxMile] AS [AtMaxMile]
- ....
- ....
- FROM [DbbEntriesSchema].[DbbEntries] dbb
- RETURN 0
- Tu te rapelle les crochets c'est par convention et aussi pour escape les
- reserve keywords de SQL genre Rule et Date c'est un reserve keyword
- Ce qui suit le mot AS ...c'est le nom que la colonne du resultat va avoir.
- Donc le nom de la propriete c#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement