MS SQL implementation does not retrieve all overloads of SPs

[shantstepanian]

Search GITHUB#7 in code for examples

Update 2017-11-18: A few thoughts

1. sp_helptext: Will return the value for an overloaded procedure, but this is not easily queryable

2. sql_modules or INFORMATION_SCHEMA is the preference according to SQL Server docs; however, it does not work for overloads

select object_name(object_id), definition from sys.sql_modules as m join sys.procedures as p on m.object_id = p.object_id

3. syscomments does work (similar to Sybase ASE); however, we'd need to update the AbstractDbMetadataDialect class and add a method like searchExtraRoutineInfo (akin to searchExtraViewInfo)

select obj.name name, com.number number, obj.type, com.texttype --, colid2 colid2 , colid colid, text text from dbdeploy03..syscomments com , dbdeploy03..sysobjects obj , dbdeploy03..sysusers sch where com.id = obj.id and obj.uid = sch.uid and sch.name = 'dbo' and obj.type in ('P','FN') and com.texttype = 0 order by com.id, number --, colid2 , colid

[shantstepanian]

Deprioritizing this for now as it is not critical for our deployment activity

We should also evaluate the JTDS driver to see if it helps anything here: #114