ABAYTHON

Delete, Truncate and Drop Table in SQL

Let us understand the difference between delete truncate and drop table: Delete Truncate and Drop Table: Characteristics Delete Truncate Drop Command Type DML(Data Manipulation Language) DDL(Data Definition Language) DDL(Data Definition Language) Rollback transaction Can be rolled back Cannot be rolled back Cannot be rolled back Permanent delete Since it is DML does not remove records …

Delete, Truncate and Drop Table in SQL Read More »

Stop saying the phrase „meiner Meinung nach“ / Alternativen zu „meiner Meinung nach“

As you start learning German and preparing for language test, we would have all come across this phrase “meiner Meinung nach” which means  ‘in my opinion’ in English. In each level of German test for example B1, B2 or C1 levels there will be speaking section and in that discussion teil we will always have …

Stop saying the phrase „meiner Meinung nach“ / Alternativen zu „meiner Meinung nach“ Read More »

What are the different query option in ODATA-URL

The OData URL can be modified to represent the corresponding results. It provides various Filter options $Filter: It is like the WHERE condition. The below URL in the browser returns the products with the price less than 100. https://services.OData.org/v3/OData/OData.svc/Products?$filter=Price lt 100     $Select: It is used to display only the respective columns of the table. https://services.OData.org/v3/OData/OData.svc/Products?$select=ID,Categories …

What are the different query option in ODATA-URL Read More »