senthilmcan-sql.blogspot.com
Structured Query Language (SQL): February 2010
http://senthilmcan-sql.blogspot.com/2010_02_01_archive.html
Structured Query Language (SQL). Friday, February 26, 2010. SQL objects are schemas, data dictionaries, journals, catalogs, tables, aliases, views, indexes, constraints, triggers, sequences, stored procedures, user-defined functions, user-defined types, and SQL packages. SQL creates and maintains these objects as system objects. A brief description of these objects follows:. Journals and Journal Receivers. Catalogs Tables, Rows, and Columns. Posted by Senthilkumar Nainamalai. Links to this post. Declare ...
senthilmcan-dotnet.blogspot.com
Visual Studio Dot .Net: Overriding Vs Shadowing
http://senthilmcan-dotnet.blogspot.com/2014/12/overriding-vs-shadowing.html
Visual Studio Dot .Net. Sunday, December 28, 2014. 8220;Base Class”. 8220;Child Class”. A method cannot be overriden if:. Methods have a different return type. Methods have a different access modifier. Methods have a different parameter type or order. Methods are non virtual or static. ChildClass c = new. Console.WriteLine(c.GetMethodOwnerName() ;. If we do not use the new keyword the compiler generates the warning:. Mixing Method (Overriding and shadowing (Method Hiding). Shadowing redefines an entire m...
senthilmcan-sql.blogspot.com
Structured Query Language (SQL): October 2009
http://senthilmcan-sql.blogspot.com/2009_10_01_archive.html
Structured Query Language (SQL). Thursday, October 8, 2009. Select * from users for XML Raw. Select * from users for XML Raw, TYPE. Select * from users for XML AUTO, TYPE. Select * from users for XML AUTO, ELEMENTS. Select * from users for XML PATH. Select 1 as Tag,0 as Parent,User fname as [usr! User fname],User lname as [usr! User lname] from users for XML EXPLICIT. Select 1 as Tag,0 as Parent,User fname as [usr! ELEMENT],User lname as [usr! ELEMENT] from users for XML EXPLICIT. Links to this post.
senthilmcan-dotnet.blogspot.com
Visual Studio Dot .Net: September 2009
http://senthilmcan-dotnet.blogspot.com/2009_09_01_archive.html
Visual Studio Dot .Net. Thursday, September 10, 2009. Permitted and Not permitted class combinations. Public class AClass Z : BClass Y. Public class YClass: ZClass T. Http:/ shiman.wordpress.com/2008/07/15/c-net-generics-inheritance/. Posted by Senthilkumar Nainamalai. A sealed class is a class that does not allow inheritance. Some object model designs need to allow the creation of new instances but not inheritance, if this is the case, the class should be declared as sealed. Indicates that a class is to...
senthilmcan-dotnet.blogspot.com
Visual Studio Dot .Net: November 2014
http://senthilmcan-dotnet.blogspot.com/2014_11_01_archive.html
Visual Studio Dot .Net. Tuesday, November 18, 2014. Socket Keep Alive IOControlCode Enumeration. Using IOControl code to configue socket KeepAliveValues for line disconnection detection (because default is toooo slow). One option is to use TCP keep alive packets. You turn them on with a call to. Only annoying bit is that it takes a byte array as input, so you have to convert your data to an array of bytes to pass in. Here's an example using a 10000ms keep alive with a 1000ms retry:. RetryInterval = 1000;.
senthilmcan-sql.blogspot.com
Structured Query Language (SQL): Clustered Index and non Clustered Index
http://senthilmcan-sql.blogspot.com/2014/12/clustered-index-and-non-clustered-index.html
Structured Query Language (SQL). Sunday, December 28, 2014. Clustered Index and non Clustered Index. Posted by Senthilkumar Nainamalai. Subscribe to: Post Comments (Atom). Is there a way to loop through a table variable in. Clustered Index and non Clustered Index. How to write optimized Stored Procedures.
senthilmcan-dotnet.blogspot.com
Visual Studio Dot .Net: Difference between Array and Arraylist
http://senthilmcan-dotnet.blogspot.com/2015/01/difference-between-array-and-arraylist.html
Visual Studio Dot .Net. Friday, January 9, 2015. Difference between Array and Arraylist. Arrays are strongly typed collection of same datatype and these arrays are fixed length that cannot be changed during runtime. Generally in arrays we will store values with index basis that will start with zero. If we want to access values from arrays we need to pass index values. Generally we will declare arrays with fixed length and store values like as shown below. Strarr.Add(10); / Add integer values. Arraylist b...
senthilmcan-dotnet.blogspot.com
Visual Studio Dot .Net: February 2010
http://senthilmcan-dotnet.blogspot.com/2010_02_01_archive.html
Visual Studio Dot .Net. Thursday, February 11, 2010. Use an alias for a namespace or class. Use the using directive to create an alias for a long namespace or class. You can then use it anywhere you normally would have used that class or namespace. The using alias has a scope within the namespace you declare it in. Using act = System.Runtime.Remoting.Activation;. Using list = System.Collections.ArrayList;. List l = new list(); / Creates an ArrayList. Posted by Senthilkumar Nainamalai. If you don't specif...
senthilmcan-sql.blogspot.com
Structured Query Language (SQL): Is there a way to loop through a table variable in without using a cursor?
http://senthilmcan-sql.blogspot.com/2014/12/is-there-way-to-loop-through-table.html
Structured Query Language (SQL). Sunday, December 28, 2014. Is there a way to loop through a table variable in without using a cursor? Http:/ searchsqlserver.techtarget.com/tip/Avoid-cursors-in-SQL-Server-with-these-methods-to-loop-over-records. Posted by Senthilkumar Nainamalai. Subscribe to: Post Comments (Atom). Is there a way to loop through a table variable in. Clustered Index and non Clustered Index. How to write optimized Stored Procedures.
senthilmcan-dotnet.blogspot.com
Visual Studio Dot .Net: December 2014
http://senthilmcan-dotnet.blogspot.com/2014_12_01_archive.html
Visual Studio Dot .Net. Monday, December 29, 2014. Posted by Senthilkumar Nainamalai. Http handler, http modules. Posted by Senthilkumar Nainamalai. Sunday, December 28, 2014. Error-The best overloaded method match for '.Calculate(double, int)' has some invalid arguments. Error-Argument 2: cannot convert from 'double' to 'float'. Calculate(2.5, 2.5);/ / Invalid. Error-The call is ambiguous between the following methods or properties: 'Calculate(int, double)' and 'Calculate(double, int)'. We can also use ...
