Data Types in SQL Server

#DataTypes in #SQLServer #SQLwithManoj

CORRECTION: for storing DECIMAL you need to just count the numbers in precision and scale, like to store 100.55 you have to define like DECIMAL(5,2)

#SQLwithManoj #SQLServer #SQLDataTypes

[SQLwithManoj]

CORRECTION: for storing DECIMAL you need to just count the numbers in precision and scale, like to store 100.55 you have to define like DECIMAL(5, 2)

[seektranslation]

nice, very clear, very easy to follow, Thank you!

[k.hemanthkumar]

Sir, how to backup a table in sql, Please let me know sir any video of this.

[jeevanreddymosali]

Thankyou for the video ...Really helped me in understanding the SQL datatypes ..

[BITTERTRUTHISBITES]

Thank you... you are very good to make us understand..

[kalikali]

Thanks Manoj, this video helped me alot and i understood datatypes clearly. Thanks once again.

[bech]

I wouldent mind if you posted that notepad document :)

[ajaykadam]

Nice .. it is very clear and easy to understand

[dennism]

Hello Manoj,

The Create table was very useful, but I think I forgot to designate a place for it in the AdventureWorks2014 Table. I can make a select statement. Could you tell me, or show me the video in which you explain how to move a table? Thanks!

[nickt]

Why would these two select statements have two different results, when the value stored inside the variable is the exact same as the string?


DECLARE @x VARCHAR

SET @x = 'aRandomString'

SELECT DATALENGTH('aRandomString')

[steveoshaughnessy]

Manoj, I think you miss-stated the definition of DECIMAL. The p, precision, is the number of digits to the left plus the number of digits to the right of the decimal point. But not counting the decimal point. To hold your 100.55 would be DECIMAL(5, 2). Try it and see for yourself.

[harikrishnasuddapalli]

give some examples on spatial data type please

[Mohamed-ufjh]

Thanks
i follow this cours and the playlist
good explain

[challenger]

when i try to multiply 2 decimal value by a triger ... it gives integer result .. is there any way to solve this ?

[shobha]

Great explanation sir but the text in your notepad is blur. not able to see clearly

[TravelvLogger]

Manoj, I really liked this Video. Its amazing dear because its small, clear and crispy.
Wish many more such videos on SQL 2019 Edition as well !!!!

[upendharthammella]

Sir
How to enter subscript and superscript in sql db

[deenadd]

If you used stored procedure how beginners get the info properly

[kranthyreddy]

Hi Manoj,

As you mentioned, Tinyint is 1 byte and start from "0 to 255". where as 1 Byte = 1 character right, how come its "0 to 255"

Please let me know

[olekristianmller-hansen]

Greetings, Manjo. Thank you for the tutorial.

I am trying to create a table for user registration and login,
where I want to store passwords with MD5-hash.
I have read that MD5-hash strings are 128 bits long,
but when I try to specify bit(128) as the datatype for column "password",
I get this error-message:

#1439 - Display width out of range for column 'password' (max = 64)

PS: I am using PHPMyAdmin to administer the SQL-database.