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
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.
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,
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
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