Total Page Preview: 000000000337
What are the basic type of datatype in SQL in English and Hindi
Type of datatype in English
In SQL, there are several data types that can be used to define the type of data that can be stored in a table's columns. Below is a list of commonly used data types in SQL along with examples:
1-CHAR: It is used to store fixed-length character strings. The length of the string is specified in parenthesis.
Example:
2-VARCHAR: It is used to store variable-length character strings. The maximum length of the string is specified in parenthesis.
Example:
3-INT: It is used to store integer values.
Example:
4-FLOAT: It is used to store floating-point numbers with a specified precision.
Example:
5-DATE: It is used to store date values in the format YYYY-MM-DD.
Example:
6-TIME: It is used to store time values in the format HH:MI:SS.
Example:
7-DATETIME: It is used to store both date and time values.
Example:
BOOLEAN: It is used to store boolean values (True or False).
Example:
These are some of the commonly used data types in SQL. The data types may vary depending on the specific database system being used.
Type of datatype in Hindi
SQL mein kuch aam data types ke saath unke examples niche diye gaye hain:
1-CHAR: Ye fixed-length character strings ko store karne ke liye use hota hai. String ki length parenthesis mein specify ki jaati hai.
Example:
2-VARCHAR: Ye variable-length character strings ko store karne ke liye use hota hai. String ka maximum length parenthesis mein specify kiya jata hai.
Example:
3-INT: Ye integer values ko store karne ke liye use hota hai.
Example:
4-FLOAT: Ye floating-point numbers ko specified precision ke saath store karne ke liye use hota hai.
Example:
5-DATE: Ye date values ko YYYY-MM-DD format mein store karne ke liye use hota hai.
Example:
6-TIME: Ye time values ko HH:MI:SS format mein store karne ke liye use hota hai.
Example:
7-DATETIME: Ye date aur time values dono ko store karne ke liye use hota hai.
Example:
8-BOOLEAN: Ye boolean values (True ya False) ko store karne ke liye use hota hai.
Example:
Ye SQL ke kuch aam data types hain. Data types database system ke anusaar alag ho sakte hain.
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com