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 go create function dbo.GetFullSprocName (@sprocId int) returns varchar(255) as begin declare @FullSprocName as varchar(255) set …
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. In mine code the generic dictionary has the advantage of being more testable, so …
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, here is a script task that alters the import file, before the flat file source …
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 = (select top 4 * from sys.tables FOR XML PATH(”)) print convert(varchar(8000), @Data_as_xml) Result:
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 e.g. session, request timeouts etc. In this post I will only address the web.config …
