Differences between Char and Varchar Datatypes | MSSQL Training

** For Online Training Registration: goo.gl/r6kJbB ? Call: [phone]
💡 Visit Our Website for Classroom Training:
nareshit.in/sq...
💡 For Online Training:
nareshit.com/c...
#sqlserver #server #programming #course #Tutorials #Training #Videos
--------------------------
💡 About NareshIT:
"Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations
--------------------------
💡 Our Online Training Features:
🎈 Training with Real-Time Experts
🎈 Industry Specific Scenario’s
🎈 Flexible Timings
🎈 Soft Copy of Material
🎈 Share Videos of each and every session.
--------------------------
💡 Please write back to us at
📧 [e-mail]/ 📧 [e-mail] or Call us at the USA: ☎[phone] or India: ☎ [phone]
--------------------------
💡 Check The Below Links
► For Course Reg: goo.gl/r6kJbB
► Subscribe to Our Channel: goo.gl/q9ozyG
► Circle us on G+: plus.google.co...
► Like us on Facebook: / nareshit
► Follow us on Twitter: / nareshitek
► Follow us on Linkedin: goo.gl/CRBZ5F
► Follow us on Instagram: goo.gl/3UXYK3

[@NareshIT]

Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

[@lyricsking9433]

Very clear. God bless you abundantly.

[@bouggyhobbes9542]

Man you deserve tumbs up. God bless you

[@poojajagdish7063]

Thumbs*

[@454udaykumar]

The best tutorial i have ever watched.Thank you

[@sasiprashadh8251]

Thank you sir. Your teaching method is very clear . God bless you

[@srikanthbabu419]

Detail explanation is extremely good... Thanks :)

[@DheerajKumar-kx4jz]

wow, sir, you explained very well...Thanks

[@khushboo043]

You really explained very well......thanku sir

[@TECHWITHKAMALRAJ]

Wow Best Explaination ever❤
It helped me a lot Thankyou सुधाकर sir

[@mohanmurali7975]

good explanation and doubts were cleared thankyou sir

[@godschampion7569]

You are a great teacher. I just subscribed. I look forward to many tutorials from you

[@SK-tp3qd]

Very good explanation. Thank you very much!

[@monishan1943]

Tq sir I understand needly without any doubt... Tq soo much sir

[@eugenemagloire9456]

best video i ever see on datatype thanks sir

[@programmeseekho2795]

Thank You Sir
Very helpful Video..Very Nice Sir

[@Chidu-Goudru]

Thank you so much for detail information🌹🌹

[@mohdmuzammil3059]

Explained beautifully sir

[@Devendra22312]

hello sir, simple and very easy to understand videos. I have one question pls how many bytes in 1 KB 1000 bytes OR 1024 if 1000 then how and why. pls reply ASAP.

[@GarvitBabbar]

1024

[@singhbishal3544]

24 is foe processing

[@anilkumarkasba9758]

Well Explained sir, thanks much

[@divyabaskar9913]

Thank you so much I understood correctly

[@prabhan.v9681]

Thanks sir , Have doubt with this session, varchar is dynamic data type. Then why should we use size

[@kokilakoki193]

Good explanation sir 👍

[@satyabratanayak7815]

Super Sir , the way of teaching is really nice .

[@guneykarabulut1853]

you are able to explain it very well! thank you for that
however your accent gives me a hard time understanding it quickly

[@mrunalini1705]

excellent explanation!

[@mahadevmule6241]

Nice sir I am easily understood

[@feyisagetachew3415]

wow tutorials i watch ever time keep it up

[@catchili7703]

English is not the best BUT love the explanation! Especially the example, gave me an Ah-Huh! moment. Very good.!

[@subburayapu3725]

Sir please upload triggers and normalizations

[@pavitragadad4795]

Sir plz do explain on cte and recursive cte concepts

[@sanjanasomika5953]

Thank you sir 🙏

[@joelmonje8684]

Great f-ing video! Well explained

[@vidyasagar5212]

Wonderful class

[@aakankshagupta7899]

Awesome 👍🏻

[@rebecagarcia1071]

Thank you so much

[@ramalkatharukshi7817]

Well explained 🔥

[@vijayaramakrishna1792]

Super I understand 👍

[@saminenisathvikchowdary9830]

Worth watching 👏

[@adil47ful]

Very Very WELL explained!!Aweeesome!!

[@yesukumarcalvary6894]

Hi sir, with examples tho chepthe enka ardham aiethadhi sir ,stuff with XML path kuda cheppandi sir....

[@yesukumarcalvary6894]

Practical gaa

[@christal9968]

thanks sir

[@bornofdata]

Awesome!!!

[@pankajkharade6936]

superb

[@achneil]

i like to know one thing is just like you have mentioned, Varchar with Variable Data Type which has maximum character of 2GB but what bout Char? is it umlimited?

[@kingnick6260]

This is wonderful! So then, why does CHAR even exist?

[@sinisuresh6858]

usefull

[@chandrakanthb570]

Sir please tell me the difference between SQL and Mysql

[@ravitejayadlapalli1213]

both are same but syntax are different

[@cococnk388]

SQL is a database query language. It differs from one database system to other ....nevertheless the language is quite similar on these different DBS.
Mysql is a is a relational database system

[@ankitatripathi9743]

NIce sir

[@Karanja_The_Data_Scientist]

2024 and we are still watching.. thanks

[@rohitraut3302]

then what is difference between varchar() and varchar2()

[@kondaulava7101]

sir you should not upload the DCL commands .so please upload the DCL commands notes and explanation video

[@RocketShip-sy3lm]

VARRRCARRR!

[@ramidaoud4323]

Why do we use char if it is wasting memory?

[@tarashrynevych1733]

CHAR is a bit faster because all the rows are of the same length. Also, generally, VARCHAR uses one or two more bytes of storage (for length or termination) in addition to the actual data. Bottom line is CHAR can be faster and more space efficient for data of relatively the same length

[@dnyaneshmahipal7612]

Varchar it will accept up to 2000 character it's not up to 2gb

[@raghavendraraj776]

😎👍🏽

[@GarvitBabbar]

Sir Hindi mai smhjhaiye na pls

[@GarvitBabbar]

Fishad lanegth

[@RanjithKumar-vv7db]

Nice dress sir😂😂😂

[@devendergusain8974]

thanx

[@sreenivasulureddy9799]

The best tutorial i have ever watched.Thank you

[@rirupa4930]

Thank you sir