Can I please get an example of the correct syntax to complete the follow:
Input Parameter(s): @NBID char(7)
Call Alerts_GetFeedSubscriptions (Stored Procedure which will be used for the loop, I am think this should be in a temp table? I could be wrong...)
loop through records to see if LastNotifiedDate < LastModifiedDate
If LastNotifiedDate < LastModifiedDate then
Update user last notified date to now
Else return false
The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.