You create a view based on the following statement:
You grant the Select permission to User1.
You need to change the view so that it displays only the records that were processed in the month prior to the current month. You need to ensure that after the
changes, the view functions correctly for User1.
Which Transact-SQL statement should you use?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
mark, build in functions