Database Connection Example: [crayon-6766e807eb458897296163/] SQL: Required − SQL query to create or delete a MySQL database Data Type: Properly defining the fields in a table is important to the overall optimization of your database. You should use only the type and size of field you really need to use. For example, do not define a
Read morejust we need to fire a query [crayon-6766e807eb75b182360877/]
Read moreJoin is the most easiest thing that could ever happen to a table, may it be a horizontal or a vertical join. Though the word vertical is not common in terms of joins but it is a common type of join that is applied in day to day SQL queries. A horizontal
Read moreIn 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
Read moreSQL - Structured Query Language is further categorized on the basis of various commands and functionality types done by a particular set of keywords and the overall impact on a particular set of database objects. They are as follows:DDL - Data Definition LanguageDML - Data Manipulation LanguageDCL - Data Control
Read moreWhy Front-end application testers should also know the basic Database testing in order to better test the applications:-What is Database TestingIn Database testing we validate:-Exactly the same data that is in database is retrieved by web or desktop application (front-end applications).The data which is inserted/modified from front-end application the same
Read morewe can implement left outer join in LINQ as wellsuppose i have 2 tables 1. product 2. order. In the order we have foreign key named as productId reference to product tableNow we want to achieve left or left outer joinvar q=(from pd in dataContext.Products join od
Read moreIf you want to apply order by on column which contains data likes numbers, string..etc Then here is the solution [crayon-6766e807eb8f3814009051/] Input:- a ba ab 1 as 2 Output:- 1 2 a ab as ba :)
Read more