Currently browsing tag

Type

Columns Without Data Type

Columns Without Data Type Introduction  “Can you make a table with CREATE TABLE statement, where there are 4 columns and 1 of   the columns  is without data type?” If we heard this above statement, we definitely think for 2 to 3 seconds. That the columns without data type? The …

Scenario based Index type selection

Scenario based Index type selection Introduction When we are thinking about index we have different options in mid to use them, such as Clustered / Non Clustered etc. It is very important to understand in which scenario what type of Index gives us the performance boost up. As we all …

TIME data type

TIME data type SQL Server 2008 introduced a new data type called TIME, which allow the TIME without DATE. Before SQL Server 2008 it is not possible. In this article I am going to explain the TIME data type by creating scenario to understand it better way. Scenario-1 [ The …

CURSOR Type

CURSOR Type Sometimes it is necessary to use the cursor, as we know that the cursor is a big performance killer and we always avoid it. But we can save some performance degradation if we know the type of cursor very well. This article illustrates the cursor type used in …

Integration with the XML Data Type

Integration with the XML Data Type With the introduction of the XML data type, we wanted to also give FOR XML the ability to generate an instance of XML directly (more precisely, it generates a single row, single column rowset where the cell contains the XML data type instance). Because of the backwards-compatibility considerations outlined …

What type of Index You Choose for Primary Key

What type of Index You Choose for Primary Key?   In one of my article, someone wants to know more about where we used the clustered index and where to non clustered index. First of all I am thanking you “Anonymous” for giving your valuable time to it. In this …

Type of Function

Type of Function When I am thinking about function, I find several article related to UDF factions in SQL server. There are so many type noted in different article that hardly to remember them.  In my point of view the, UDF function is broadly categorized at 2 types 1.    Scalar …

Which Data Type is good For Primary Key

Which Data Type is good For Primary Key The most important thing of a table is defining the primary key; it could be single column based or the composite primary key.   In my development life, I saw a lot of primary key with different type or patterns. Such as …

What is USER DEFINE Data Type and Its Implementation

What is USER DEFINE Data Type and It’s Implementation   User define data type are based on system data type of MS SQL Server. It is created when several table object use the same data in terms of data type, length and null ability. For example if we create the …

Different type of referential actions in foreign key

Different type of referential actions in foreign key Foreign key is an important part of referential integrity. But we often confuse about the foreign key referential actions and their implementations. Here is a beautiful collections that help you to clear your doubts related to it. Foreign keys are defined in …

Unmanaged to Managed Type Translation Table

Unmanaged to Managed type translation table: C/C++ C# HANDLE, LPDWORD, LPVOID, void* IntPtr LPCTSTR, LPCTSTR, LPSTR, char* String [in], StringBuilder [in, out] const char*, Wchar_t*, LPWSTR String [in], StringBuilder [in, out] DWORD, unsigned long, Ulong UInt32, [MarshalAs(UnmanagedType.U4)] bool bool LP<struct> [In] ref <struct> SIZE_T uint LPDWORD out uint LPTSTR [Out] …