Hogan

New York, NY

Age: 50

25+ years...
ASM, C, C++, C#, VB, ASP.NET, TSQL +many more


The postings on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.


Programmer, Architect, Team Lead, Director, CTO
MS Comp. Sci @ NYU '95
hoganlong at us.ibm.com // hoganlong at gmail.com


oh, and #SOreadytohelp, but you can see that just looking below.

1h
answered What's the difference of SELECT and SELECT IN in sql?
8h
comment T-Sql stored procedure interpretation
Seems 100% clear (if that percentage is over 10%)
10h
comment Reason for error using select statement containing aggregate functions?
@nsledeski - yw, good luck learning the mysteries of sql
2d
comment Deleting a non-unique procedure on DB2
isn't the problem that he has two with the same name -- you have to drop it object id.
Apr
28
comment Find string with most frequency of a character in List of strings using LINQ C#
@octavioccl - because you are using Aggregate instead of orderby or max
Apr
28
comment Find string with most frequency of a character in List of strings using LINQ C#
why the extra loop why not just `int max = vectors[0].Count(x => x == '1').max(x => x)
Apr
28
comment Synchronization of tables from DB2 to SQL
I'd say you have to buckle down and read some documentation on SSIS. There is nothing about SSIS that stops you from implementing this functionality.
Apr
28
comment Synchronization of tables from DB2 to SQL
What is this code -- a stored procedure? I see the BEGIN and the END but no context. Also what is up with the TOTAL LACK of indentation?
Apr
28
revised Error on MySQL trigger execution
added 2 characters in body
Apr
28
answered Error on MySQL trigger execution
Apr
27
comment What are the parentheses doing in this SQL Statement in the FROM CLAUSE (TSQL)
Was this from a code generator? That would explain useless parentheses
Apr
27
comment What are the parentheses doing in this SQL Statement in the FROM CLAUSE (TSQL)
or another way to put it is -- These parentheses are doing the default, if they were moved then that might cause a change.
Apr
27
comment How do I take a certain word from user input and make it a string?
Don't take stuff from users! -- That's impolite!
Apr
27
answered error on a simple Stored Procedure in SQL Management Studio
Apr
27
revised error on a simple Stored Procedure in SQL Management Studio
added 74 characters in body
Apr
27
comment Does using Windows Authentication with Kerberos encrypt messages to and from SQL Server?
yes secure is modifying established not session. Later on that page they list the types of protocols used. It is very possible to set up those protocols to be insecure. However, it is hard to have Kerberos be insecure (but possible if you use microsoft extensions to turn off certain features.) But if you don't specifically set ignore flags in your setup Kerberos is very strong.
Apr
27
comment Does using Windows Authentication with Kerberos encrypt messages to and from SQL Server?
Kerberos is just the authentication protocol -- so it depends on what protocol you are using to communicate with the server.
Apr
27
reviewed Approve suggested edit on How to Create column constraint in sql which has unique field values but can store any number of null field
Apr
27
comment Two right joins
wow-- inner join on TABLEB -- bold move.
Apr
27
comment Two right joins
table a does not have id 2 and 5 so that will be missing in the result.
1 2 3 4 5