Home > Database

SQL Commands

SQL Commands: The standard SQL commands to interact with relational databases are CREATE, SELECT, INSERT, UPDATE, DELETE and DROP DDL - Data Definition Language: CREATE: Creates a new table, a view of a table, or other object in the database ALTER: Modifies an existing database object, such as a table DROP: Deletes an entire table,

This Article is TAGGED in , , . Read more

MS SQL connection using JDBC in Selenium

To connect MS SQL database using jdbc driver in java, we need to download jdbc driver for MS SQL server. Refer below link to download MS SQL jdbc driver file.  Add external Jar file to project: Right click on project, Go to properties → Java Build Path → Click on Library tab  Add external

This Article is TAGGED in , . Read more

Performance Test for Cursors in Stored Procedures

In this article, we will test the performance of the cursors with the help of the client statistics that shows the different statistics like Network statistics, Time statistics, Query Profile Statistics. Step#1: First reset client statistics by click on Query >> Reset client Statistics. This will clear the client statistics Step#2: Click

This Article is TAGGED in , . Read more

SQL NULL Value – Simplified

In SQL, NULL approximately represents an unknown value.An arithmetic operation involving a NULL returns NULL. For example, NULL minus NULL yields NULL, not zero and NULL plus NULL is NULL as well.A boolean comparison between two values involving a NULL returns neither true nor false, but unknown in SQL's three-valued

This Article is TAGGED in , , , , , , . Read more

Database CUBE – simplified

Complicated stuff first -- Cube is a method of storing data in a multidimensional form, generally for reporting purposes. In cubes, data (measures) are categorized by dimensions. Cubes are often pre-summarized across dimensions to drastically improve query time over relational databases.Simple stuff -- Cube is a data storage mechanism beyond

This Article is TAGGED in , , , , , , , . Read more