Viewing 12 posts - 1 through 12 (of 12 total)
handkot (9/1/2015)
I think the same thing
AS AliasAndAS 'Alias'also i can write
AS [Alias], or write CTEso there are only three ways: "=", "AS" and column
+1
September 2, 2015 at 5:41 am
50/50 shot between the two identicals. I chose poorly.
November 11, 2014 at 5:15 am
the ORDER BY in the OVER clause orders the records returned by the select. By adding an order by on the select, a differect set of records is returned for...
September 30, 2014 at 6:48 am
We have all been drilled that without an order by there is no guarantee of the order of the records. That being said any number from 1 to 20 could...
September 30, 2014 at 6:23 am
I'm one of the ones who did not read the title. I hate missing a question like that!
Live and learn... and learn .... and learn
Todd
January 23, 2014 at 5:59 am
Good question. Too bad I got caught up in the permissions and forgot to tick that the create worked.
October 31, 2013 at 5:28 am
Good trick question. Monday morning, brain wasn't working yet.
October 21, 2013 at 5:28 am
The correct answer is 0 since 'steppenwolf' is 11 characters long and would return an error.
September 11, 2013 at 5:39 am
The featured contents should be at the top of the letter so that a summary is immediately viewable.
The width should scale to the available display width.
Content is great as...
July 2, 2013 at 1:06 pm
technically it does return a row. Not a row from the tables but a row that is the link to the xml editor.
add 3 row to staging
(3 row(s) affected)
add 3...
June 13, 2013 at 5:34 am
As most have already said, I had to guess since the altering of a non-existent procedure results in an error. luckily I guess correctly. 🙂
December 12, 2012 at 7:23 am
Not sure if this could be the problem.
If I run this query I do not get a result:
select * from master.sys.sysprocesses
WHERE Program_Name like '%Agent%Refresher'
But if I run this query i...
July 7, 2010 at 9:04 am
Viewing 12 posts - 1 through 12 (of 12 total)