|
|
-
|
|
In this post, I am going to explain about default keyword in c#. Introduction: As per MSDN default keyword in C# used to assign the default value of the type. In some situation its comes very handy where we don’t want to create object and direct...
|
|
-
|
|
Throughout my career as a Business Intelligence Consultant, I have met and interacted with a lot of DBAs. One thing (among many others) I particularly admire about them is that they have their own list of SQL scripts that they carry with them from job t...
|
|
-
|
|
When you run the following codeselect name from sys.objects
having 1=1
you get the following error Msg 8120, Level 16, State 1, Line 2
Column 'sys.objects.name' is invalid in the select list because it is not contained in either an aggregate function or...
|
|
-
|
|
In this post, I am going to explain how we can convert an generic list to simple int array with Help of Linq. Recently, I was working on an application and there I needed an Int array of for list of ids in generic list. I tried various methods and then ...
|
|
-
|
|
Using Temporary tables in SSIS...
|
|
-
|
|
A few days back, I spoke about the manual failover of mirroring and also explained one issue and workaround too. Continuing with the same failover, I want to express one more issue here. This issue is not very critical but it somehow to create an issue ...
|
|
-
|
|
Microsoft SQL Server 2008 introduced the DATE and TIME data-types. TIME could be added to DATETIME in SQL 2008, but can longer be done so in SQL Server 2012. In this post, we look at the Msg #402, and associated workaround....
|
|
-
|
|
After installation of visual studio, I tried to open asp.net MVC4 project but I was getting below exception: "Error: this template attempted to load component assembly 'NuGet.VisualStudio.Interop, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b...
|
|
-
|
|
Functions:gocreate function dbo.utf16_to_utf8 (@s varbinary(8000),@endian bit) returns varchar(8000) -- @endian 0-little 1-big null-BOMbegin if @s is null return null if @endian is null and not (convert(char(4),@s,2) = 'FEFF' or convert(char(4),@s...
|
|
-
|
|
Previous posts on this series
Exploring SSIS - Understanding the basics Exploring SSIS - Execute SQL task with simple parameter Exploring SSIS - Export to csv file
I have started a series on Exploring SSIS where I will explain various features available...
|
|