Viewing 15 posts - 91 through 105 (of 216 total)
bolyard (10/7/2011)
First timer... but it won't be my last summit. Switched to SQL full-time after 15 years of being a developer.
Same here, the part about being a developer for many...
October 7, 2011 at 2:37 pm
Won't this work as well?
AND CONVERT(DATE, P.modify_date) = @sdtInputDate
October 7, 2011 at 10:04 am
Thanks for this article. Our group is inheriting a few DBs so this is timely.
The searching on INFORMATION_ROUTINES might be a little confusing when searching for possible linked server...
October 4, 2011 at 1:52 pm
So how would you do something like:
Select * From Sales Where CustomerType = ? Order By LastUpdate Desc
without the benefit of the SSMS Tool Pack?
Ken
September 23, 2011 at 10:54 am
Here is my current list:
1 sp_who
2 sp_lock
3 sp_who2
4 sp_spaceused
5 sp_monitor
6 sp_tables
7 sp_columns
8 sp_stored_procedures
9 sp_helptext
0 select * from
Some require a highlighted parameter, others don't. Play around with them...
That last one...
September 22, 2011 at 8:01 am
Carlo Romagnano (9/22/2011)
shayk (9/22/2011)
Nice, but the SP unnecessary. You can write in the SSMS "Select TOP 50 * FROM "
I also use this "Select TOP 50 * FROM ". It...
September 22, 2011 at 7:48 am
Jeff, congratulations on the award. I know everytime I need a solution to a database programming problem my well trained programmer brain wants to construct a loop. Then I think...
September 21, 2011 at 3:30 pm
Did anyone have problems finding the party location last year? No one that I bumped into at the initial reception knew anything about it. I guess 2AB is one of...
September 21, 2011 at 8:47 am
Problem: ORA-01005: null password given; logon denied
Solution: Use an ADO.NET connection source and create and use a System DSN to the Oracle database. [/quote]
That didn't work for me. What did...
September 12, 2011 at 1:55 pm
chrisn-585491 (8/18/2011)
The US is fortunate because its sheer size means that there will always be a market capable of keeping its heartbeat going.
The US is also screwed since income inequality...
August 18, 2011 at 12:19 pm
The SQL here would be pretty easy. This sounds more like VS question.
Ken
August 18, 2011 at 10:35 am
tlockwood (8/17/2011)
Paid holidays reduced from 10 to 6.
Medical plan reduced from a ‘Cadillac’ plan to a ‘Ford’ plan.
401K...
August 17, 2011 at 2:15 pm
I briefly did the train into the NYC thing which is very popular around here in NJ. Lot's of people going to Wall St. and midtown Manhattan for excellent pay....
August 11, 2011 at 10:13 am
Oh sure thing. Thanks to everyone for their solutions.
Ken
July 21, 2011 at 10:39 am
I just read this article in full today. This is really useful! In one of Jeff's examples he uses a right join to the tally table to get a list...
July 20, 2011 at 3:11 pm
Viewing 15 posts - 91 through 105 (of 216 total)