Biology Forums - Study Force

Science-Related Homework Help Computer Studies Topic started by: Danli on Oct 20, 2016



Title: What would be the effect of the following DELETE statement?DELETE FROM SessionWHERE SessionDate < ...
Post by: Danli on Oct 20, 2016
What would be the effect of the following DELETE statement?
DELETE FROM Session
WHERE SessionDate < GETDATE( )
A) It would remove all the rows from session
B) It would remove all the rows from session where the Sessiondate was less than the current date
C) It would get rid of the table session
D) A and C


Title: Re: What would be the effect of the following DELETE statement?DELETE FROM SessionWHERE SessionDate ...
Post by: Venturia on Oct 20, 2016
Content hidden


Title: Re: What would be the effect of the following DELETE statement?DELETE FROM SessionWHERE SessionDate &lt; ...
Post by: Danli on Nov 24, 2016
Just what I needed, delivered at the right time too