SAP ABAP Problems & Solution

UPDATE & Delete Statement Update Statement:  UPDATE statement is used to modify the existing records in a table.with We need to use Where Clause with Update statement to update the selected row,otherwise all the rows would be affected. The Update Statement look like : UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition];     If anyone forget to use Where Clause then the total row will be updated. So use Where clause with Update statement.   Delete Statement: The Delete Statement use to delete the existing record in a table.We need to use Where Clause with Delete Statement,Otherwise all the rows would be affected. The Statement look like: DELETE FROM table_name WHERE condition ;

After Creating Table successfully we need to insert value in the existing table.So,I am showing you how to insert value in a row. The INSERT INTO Statement is used for insert value in a table as a row wise. There are two basic syntax.I am giving both of them. INSERT INTO TABLE_NAME (column1, column2, column3,...columnN) VALUES (value1, value2, value3,...valueN); and the other one is : INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);   If we create a table for Customers then the query looks like:       INSERT INTO Customers(Cust_Id, Cust_Name, Cust_Addr,Cust_Phone) VALUES (1001, Harish, Park Street,+9178999999);   Similarly we can use the other one.Here we just put the value directly. never break the sequence , otherwise you 'll get wrong values.

Create a new table: The CREATE TABLE Statement is used for creating a new table.Where define the table name and also define its column name with each columns Data types. The statement looks like :   CREATE TABLE table_name (     column1 datatype,     column2 datatype,     column3 datatype,    .... nth column datatype,  PRIMARY KEY( one or more columns )  ); The column parameters specify the names of the columns of the table. The datatype parameter specifies the type of data the column can hold (e.g. varchar, integer, date, etc.).

We need to know about Self Join meaning ,then we can understand its purpose.I am giving a short meaning : Joining a table with it's self is known as self Join. We can define Self join as like :  Inner Self Join Outer Self Join (Left,Wright & Full Join) Cross Self Join Inner Self Join : Select A. Column_Name1, B.Column_Name1 from Table_name A Inner Join Table_name B On A.Primary_Table = B. Primary_Table  Outer Self Join: Select A. Column_Name1, B.Column_Name1 from Table_name A Left Join Table_name B On A.Primary_Table = B. Primary_Table Cross Self Join: Select A. Column_Name1, B.Column_Name1 from Table_name A Cross Join Table_name B

Hello Everyone !!! Hope you are doing well in your programming life.Today I am discussing a short query.This is really so easy but not come in time.I am describing the scenario first,then give solution. Suppose you have a table with having some  data field,you need to sum a column value.in normal case we use : select sum(column_name) from table name where column_name ='condition'  We can use the upper query when the data type is int.If we need to sum varchar data type then the mention query is not working.At that time we need to convert it float type.That time we are able to get the desired result.I am adding a screen short and also the query. The query is look like: Select sum(convert(float,column_name)) from table name where column_name='condition'

  SQL Joining: Joins in SQL are used to query (retrieve) data from 2 or more related tables. In general tables are related to each other using foreign key constraints. In SQL there are different types of JOINS: 1. CROSS JOIN 2. INNER JOIN 3. OUTER JOIN Outer Joins are again divided into 3 types: 1. Left Join or Left Outer Join 2. Right Join or Right Outer Join 3. Full Join or Full Outer Join General Formula for Joins SELECT       ColumnList FROM            LeftTableName JOIN_TYPE   RightTableName ON                  JoinCondition CROSS JOIN: CROSS JOIN, produces the Cartesian product of the 2 tables involved in the join. Cross Join shouldn't have ON clause. CROSS JOIN Query: SELECT ColumnName1, ColumnName2, ColumnName3,ColumnName4 FROM tableName CROSS JOIN tableName2(joining...

Unique key constraint: We use UNIQUE constraint to enforce uniqueness of a column i.e the column shouldn't allow any duplicate values. We can add a Unique constraint thru the designer or using a query. To add a unique constraint using SQL server management studio designer: 1. Right-click on the table and select Design 2. Right-click on the column, and select Indexes/Keys... 3. Click Add 4. For Columns, select the column name you want to be unique. 5. For Type, choose Unique Key. 6. Click Close, Save the table. To create the unique key using a query: Alter Table Table_Name Add Constraint Constraint_Name Unique (Column_Name) Both primary key and unique key are used to enforce, the uniqueness of a column. So, when do you choose one over the other? A table can have, only one primary key. If you want to enforce uniqueness on 2 or more columns, then we use unique key constraint. What is the difference between Primary key constraint and Unique key constraint? ...

Group By: In SQL Server we have got lot of aggregate functions. Likes: 1. Count() 2. Sum() 3. avg() 4. Min() 5. Max() Group by clause is used to group a selected set of rows into a set of summary rows by the values of one or more columns or expressions. It is always  used in conjunction with one or more aggregate functions. Syntax look likes : SELECT COUNT (Column name), column name1 FROM table name GROUP BY column name1; Filtering Groups:   WHERE clause is used to filter rows before aggregation, where as HAVING clause is used to filter groups after aggregations. The following 2 queries  produce the same result. Filtering rows using WHERE clause, before aggregations take place: Select Column name, SUM (column name) from table name Where column name = condition group by column name (By which we want to filter our result) Filtering groups using HAVING clause, after all aggregations take place: Select Column name, SUM (column name) from t...

Where Operator Usage : In my last post I was talking about Where clause and its operators.Now I am going to describe its usage with Where clauses. There are different types of usage operators with our requirement. I will give all the operators usage process with some example. It is used with SELECT,INSERT,UPDATE & DELETE statement. I am giving it serially. Equal (=) :This operator is used when we comparing any value or characters with our required field. Like : SELECT * FROM table name WHERE column name= value. Where clause with AND : It is used when we have multiple condition.Just like:       SELECT column - names   FROM table - name    WHERE condition1 AND condition2            For Update : UPDATE table - name SET column - name = value WHERE condition1 AND  condition2.   Where clause with OR : It is used when any one value is acceptable, like: SELECT col...

Today I am talking about another Select Statement.That is Select DISTINCT Statement. The   SELECT DISTINCT statement is used to return only distinct (different) values. Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values. The  SELECT DISTINCT statement is used to return only distinct (different) values. The statement look like : SELECT DISTINCT column1 , column2, column3,..... FROM table_name ;  Select statement likely : SELECT column1 , column2, column3,..... FROM table_name ;  For example I am showing you both of two queries. Hope it will help you to clear the concept. Difference between Select and Select DISTINCT : By using Select statement we get all the value if have any duplicate values in a table. On the other hand Select DISTINCT statement gives only single values.It's remove duplicate values. Query's are like:  SELECT Column name FRO...

Hello Everyone !!! I am trying to help you for sharing some programming problem.Programming is a part of life.Sometimes its changed.Like life is valueless without programming.So,don't be upset. Don't be hopeless.There are lots of hope.If you can take it as a part of your life. I am talking too much.Now come to the point. if I asked anybody say something about programming language,I sure most of them give me a vast description about specific language.How many programming language we have,I am just mentioning some of these: C,C++,C#,Java,Python,Ruby,PHP,JavaScript,Perl,CSS and so and. I am trying to give some idea about a few of these. Today I am describing SQL query language. SQL is a standard language for storing, manipulating and retrieving data in databases. What is SQL? SQL stands for Structured Query Language. SQL lets you access and manipulate databases. SQL is an ANSI (American National Standards Institute) standard. What Can SQL do? SQL can execute querie...