Skip to main content

Posts

Showing posts from 2018

How To Create a Full Text Indexed View or Schema Binded View

How To Create a Full Text Indexed View or Schema Binded View To create a schema binded view or full text index on a view, we simply have to write a select statement as we do while creating any normal view fetching data from one or more tables. The only thing different we do here is creating a this view with schema binding. Once we created a schema-bound view, we can add clustered or non-clustered indexes to this view. Check below self explanatory example below that creates a full text index to get family details from Father and Son tables.

OOPS In C# | Abstract Classes, Abstract Method, Abstract Properties

abstract (C# Reference) The  abstract  modifier indicates that the thing being modified has a missing or incomplete implementation. The abstract modifier can be used with classes, methods, properties, indexers, and events. Use the  abstract  modifier in a class declaration to indicate that a class is intended only to be a base class of other classes. Members marked as abstract, or included in an abstract class, must be implemented by classes that derive from the abstract class. Example In this example, the class  Square  must provide an implementation of  Area  because it derives from  ShapesClass : C# Copy abstract class ShapesClass { abstract public int Area ( ) ; } class Square : ShapesClass { int side = 0 ; public Square ( int n ) { side = n; } // Area method is required to avoid // a compile-time error. public override int Area ( ) { return side * side; } static void Main ( ) {