August 2013 – Knowledgebase

How to get the full stored procedure name (incl. schema name) within the current executing stored procedure.

29 August, 2013 Roel van Lisdonk 0 Comments 1 category

Here is a function you can use to get the full stored procedure name (incl. schema name) within the current executing stored procedure: if object_id('dbo.GetFullSprocName') is not null begin drop function dbo.GetFullSprocName end

Dictionary lookup vs switch vs if performance in C#

28 August, 2013 Roel van Lisdonk 0 Comments 1 category

Lets say you want to execute a specific logging function based on a log level. Amongst others you could use a switch- or if statements or use a generic dictionary containing the functions to call.

How to handle variable column count with the SSIS 2008 Flat File Source.

28 August, 2013 Roel van Lisdonk 3 Comments 1 category

If you want to import flat files (e.g. *.csv) that contain rows with dynamic column count, the best way is to use this codeplex component: http://ssisdfs.codeplex.com/ If you don’t want to use that component,

Printing table contents for debugging purposes in T-SQL

23 August, 2013 Roel van Lisdonk 0 Comments 1 category

Sometimes you just want to add a print statement in a stored procedure to output the contents of a table. Then you can use the "FOR XML" statement in T-SQL: declare @Data_as_xml xml set @Data_as_xml

Uploading large files with Outsystems

2 August, 2013 Roel van Lisdonk 0 Comments 1 category

If you want to upload "large" files e.g. <= 100MB, on any ASP .NET website, you must edit the web.config file. There are many settings that you might want to update, when uploading large files

Month: August 2013

How to get the full stored procedure name (incl. schema name) within the current executing stored procedure.

Dictionary lookup vs switch vs if performance in C#

How to handle variable column count with the SSIS 2008 Flat File Source.

Printing table contents for debugging purposes in T-SQL

Uploading large files with Outsystems