Author: ERP Consultors

Use printf() in C Language

Use printf() in C Language: (1) printf() is used for printing output value.  (2) Sample C language code and its output, as shown: #include <stdio.h>#include <conio.h>int main(){printf(“My First C Programme”);getch();return 0;} (3) After that go to the “Build” menu and select the “Build” option for publishing the code as shown. (4) After building the code, press …

C Language Syntax

C Language Syntax: (1) C Language is designed by “Dennis Ritchie”. (2) C Language is a procedural programming language. (3) C Language is designed to be compiled to provide low access to memory. (4) For learning the C language, first install the editor and compiler. For this, refer to the blog “Install Code Blocks for C …

Use of SUBSTRING Function in SQL

Use of SUBSTRING Function in SQL: (1) “SUBSTRING” function is used to extract characters from the string with defined length and position. (2) Let’s take an example to extract the first two characters from Vendor Name as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) …

Use of REVERSE Function in SQL

Use of REVERSE Function in SQL: (1) “REVERSE” function is used for reversing the string. (2) Let’s take an example of reversing the Vendor Name as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) After that new query editor opens as shown. (5) After doing …

Use of REPLACE Function in SQL

Use of REPLACE Function in SQL: (1) “REPLACE” function is used to replace characters within the string. (2) Let’s take an example to replace ‘A’ with ‘T’ in Vendor Name as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) After that new query editor opens …