Execute Table Creation Using UI in SAP HANA Studio

John SAP
Updated on 22-Jun-2020 09:30:13

223 Views

To execute the table creation, click on the green arrow mark on the top right corner. You will get a confirmation as below that a column table has been created in Schema AA_HANA11 with name DEMO_TABLE −Statement 'create column table "AA_HANA11"."DEMO_TABLE"( "CUST ID" INTEGER null, "CUST NAME" VARCHAR (10) null)' successfully executed Affected Rows:0 in 5 ms 884 µs.

Different Table Store Types in SAP HANA Studio

John SAP
Updated on 22-Jun-2020 09:29:40

245 Views

Following table type available in SAP HANA Studio −RowColumnTable Type − this can be changed later as per requirement

String Template Class in C#

Ankith Reddy
Updated on 22-Jun-2020 09:29:37

472 Views

StringTemplate class is used to parse the format string, so that it is compatible with String.Format. The StringTemplate class comes under the NString library that has extension methods. These methods makes string manipulations easy to use like.IsNullOrEmpty() IsNullOrWhiteSpace() Join() Truncate() Left() Right() Capitalize()StringTemplate.Format is better than String.Format since it is more readable and less prone to errors.The order of the values can be easily formatted. The values are formatted in a way similar to String.Format, but with named placeholders instead of numbered placeholders.The following is a sample −string str = StringTemplate.Format("{ExamName} will held on {ExamDate:D}", new { p.ExamName, p.ExamDate }); ... Read More

What is Abstraction in C#

Samual Sam
Updated on 22-Jun-2020 09:29:18

2K+ Views

Abstraction and encapsulation are related features in object-oriented programming. Abstraction allows making relevant information visible and encapsulation enables a programmer to implement the desired level of abstraction.Abstraction can be achieved using abstract classes in C#. C# allows you to create abstract classes that are used to provide a partial class implementation of an interface. Implementation is completed when a derived class inherits from it. Abstract classes contain abstract methods, which are implemented by the derived class. The derived classes have more specialized functionality.The following are some of the key points −You cannot create an instance of an abstract classYou cannot ... Read More

Create a Table Using SAP HANA Studio UI Option

John SAP
Updated on 22-Jun-2020 09:28:46

469 Views

You can also create a table in the HANA database using GUI option in the HANA studio. To create a new table, you need to select Schema right-click → New Table and in the right pane, you can define the table.In table creation wizard, you need to enter TABLE NAME and Scheme in which you want to create this table and Table Type- Row or Column Store or Table Type.To add columns to the table, you need to click on “+” sign and a new column is added. You have to define an SQL data type, dimension and Key in ... Read More

CopyOnWriteArrayList Version in Chash

Arjun Thakur
Updated on 22-Jun-2020 09:27:52

264 Views

Java has CopyOnWriteArrayList, but C# does not have it. For that, the SynchronizedCollection Class in C#, should be preferred.The SyncronizedCollection has a thread-safe collection containing objects of a type. Here is the syntax.public class SynchronizedCollection : IList, ICollection, IEnumerable, IEnumerable, IList, ICollectionAbove, T is the type of object.The following are the properties of the SyncronizedCollection class in C# −Sr.No.Property Name & Description1CountCounts the number of elements in the thread-safe collection.2Item[Int32]Gets an element from the thread-safe collection with a specified index.3ItemsGets the list of elements contained in the thread-safe collection.4SyncRootGets the object used to synchronize access to the thread-safe collection.Read More

Style Only Child p Elements with CSS

George John
Updated on 22-Jun-2020 09:27:41

185 Views

Use the CSS :only-child selector to style every element that is the only child of its parent.ExampleYou can try to run the following code to implement the :only-child selectorLive Demo                    p:only-child {             background: orange;          }                     Heading                This is a paragraph.                      This is a paragraph.          This is a paragraph.          This is a paragraph.           Output

Understanding Logistic Regression in C#

karthikeya Boyini
Updated on 22-Jun-2020 09:27:23

421 Views

The Logistic regression is a linear model used for binomial regression. It is used in medical science and to predict a customer’s tendency to purchase a product. It makes use of predictor variables for this purpose.Logistic Regression allows easier analysis of results in the form of odds ratios and statistical hypothesis testing.A generalized linear model has taken input for a non-linear link function. The linear model has the following form −z = c1x1 + c2x2 + … cnxn + i = ct x + iHere,c is the coefficient vector, i is the intercept value x is the observation vector

Creating Column Table in SAP HANA Database

John SAP
Updated on 22-Jun-2020 09:27:22

3K+ Views

To create a Column store table, you need to enter “Column” keyword in Create table command.Create column Table Test_ColumnTB1 (    Cust_ID INTEGER,    Cust_NAME VARCHAR(10),    PRIMARY KEY (Cust_ID) );

Make Code Reusable in C#

Chandu yadav
Updated on 22-Jun-2020 09:27:05

2K+ Views

To make code reusable in C#, use Interfaces. Interfaces define properties, methods, and events, which are the members of the interface. Interfaces contain only the declaration of the members. It is the responsibility of the deriving class to define the members. It often helps in providing a standard structure that the deriving classes would follow.For example, Shape Interface −public interface IShape {    void display(); }Above we have declared an Interface Shape. You can notice that it begins with a capital “I”. It is a common convention that interfaces names begin with “I”.We have not added an access specifier above ... Read More

Advertisements