chevron_left

Recent posts tagged sql

0 0 1 min.
There are so many different data types in SQL Server that could be used to store the same type of data. For example, for storing numbers we have Integer, smallInt, bigInt, etc. All of these types are used to store the same type of data and we sometim...
posted Oct 1 Hafsa_Rao 390 points
0 0 1 min.
Common Table Expressions Common Table Expressions also are referred to as CTEs. This characteristic turned into delivered with SQL Server 2005. The CTE is favored to apply as an opportunity to a Subquery/View. Sub-queries A sub-question is a qu...
posted Sep 22 videepsinghal 324 points
6 0 2 min.
Date class is found in both java.util package and java.sql package. Though the name of the class is the identical for both packages, their utilities are different. Date class of java.util package is needed while records is needed in a java utility to...
posted Sep 22 videepsinghal 324 points
4 0 1 min.
Problem: -------- I want to retrieve all the names from a database that ends with ‘a’. I do not know how to do that. Solution: --------- You can do this by using LIKE operator. SQL provides various ways to retrieve specific data. It provides -...
posted Sep 22 john_dev 45 points
4 0 1 min.
Problem: -------- Hello Kodlogs, I recently started learning programming and I am a little curious about how large enterprise applications are made. I came to know that SQL is used to handle data for large applications. I want to know more about it...
posted Sep 22 john_dev 45 points
0 0 1 min.
If you are upgrading from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012, select the second option. In this example, nothing was previously installed. Therefore, select the first option. We recommend that you choose the firs...
posted Sep 22 videepsinghal 324 points
0 0 1 min.
If you are upgrading from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012, select the second option. In this example, nothing was previously installed. Therefore, select the first option. We recommend that you choose the firs...
posted Sep 22 videepsinghal 324 points
0 0 1 min.
This command is used to rename a column to a new column. It is also used to change the table name to the new table. Let's see how we can use this command in different databases. However, to understand all of the examples, first look at the following...
posted Sep 20 videepsinghal 324 points
6 2 5 min.
1. Whenever installing a new program on Windows 10, you should always make sure you document yourself on whether it is compatible with your OS or not. 2. Sometimes, due to software issues, you will be prompted with an error message stating that the O...
posted Sep 17 SharadMagar450 320 points
15 0 1 min.
The structured query language is almost the same for MySQL, SQL Server, or other database management systems. Most of the commands are the same and used for the same purpose. In this post, we are going to see the **difference between the truncate and...
posted Sep 13 Hafsa_Rao 390 points
16 0 2 min.
This article is going to be very informative for those wanting to learn SQL joins. We will discuss in details what kinds of SQL joins exist and will explain each type with an example and ven diagrams. Let's start. First we need to define the followi...
posted Sep 6 ahsanhanif99 202 points
16 0 2 min.
TRUNCATE, DELETE and DROP commands are used to delete or remove data and tables from a database. Although their function is the same, all of these commands are used for different purposes. In this article, we are going to see the difference between T...
posted Sep 4 Hafsa_Rao 390 points
13 1 8 min.
Stоred  рrосedures  exeсute  fаster  thаn  аn  equivаlent  sql  sсriрt  beсаuse  stоred  рrосedures  аre  whаt?Hi,  in  this  роst  we  will  leаrn  W...
posted Sep 4 sakshi 955 points
13 2 2 min.
Write  а  query  tо  disрlаy  the  smаllest  integer  vаlue  nоt  less  thаn  1.23.  give  аn  аliаs  аs  int_vаlue.СEIL()  funсtiоnMySQL  СEIL()  ret...
posted Sep 4 sakshi 955 points
22 0 4 min.
Сreаte  View  fасulty  аs  seleсt  id,  nаme,  deрt  nаme  frоm  instruсtоr;  find  the  errоr  in  this  query  .СREАTING  VIEWSWe  саn  сreаte ...
posted Aug 26 sakshi 955 points
3 0 2 min.
If you have never assigned a root password to MySQL, the server does not need a password to connect as root. However, this is not safe. For instructions on how to assign a password, see Section 2.10.4, “Initial MySQL Account Security”. If...
posted Aug 22 videepsinghal 324 points
6 0 2 min.
Whenever you use Java applications to interact with databases, you will often have to convert java.sql.Date into java.util.Date when you use java.sql.Date. In Java, java.sql.Date is used in JDBC, which is the Java API for database connections, but on...
posted Aug 20 videepsinghal 324 points
3 0 1 min.
While experimenting with mysql on raspberry pi I often come across some steps, so I decided to write a post on how to establish a remote connection in mysql on raspberry pi. This article is about how to log into mysql on raspberry pi from Windows PC....
posted Aug 20 videepsinghal 324 points
0 0 2 min.
In this article we focus on types security breaches that can occur when not filter user input correctly.Filtering can be a considered a good thing in terms of security and can be considered bad since some data can not be inserted into database such a...
posted Aug 16 joshua134 105 points
0 0 1 min.
I would strongly recommend you to use MySQL as you are quite familiar with most relational databases. The official MySQL documentation refers to the INFORMATION_SCHEMA metadata as tables, unlike most other databases that refer to this information as ...
posted Aug 14 videepsinghal 324 points