Techie Vineet
Techie Vineet
  • 295
  • 93 036
Constants | Microsoft SQL Server | Transact-SQL | Data Science | Techie Vineet
Constants | Microsoft SQL Server | Transact-SQL | Data Science | Techie Vineet
In this video we discussed about SQL Server constants including below:
Character String Constants
Unicode Strings Constants
Binary Constants
Boolean Constants
Date-Time Constants
Integer Constants
Decimal Constants
Floating Point Constants
Money Constants
Money Constants
We have also discussed on how you can specify and represent the positive and negative numbers in SQL Server.
T-SQL Bootcamp - 200 Days of Group Coaching
Google Forms Link : forms.gle/TMock1ZDd9kyFpaC6
Course Fee : Rs. 40000/-
My Channel Page : www.youtube.com/@MasterDataSciencewithVineet
SQL Server Database Design Playlist : ua-cam.com/play/PL20ogj9nfKTnzB6Kh3QEvmXqSjEwenupj.html
Business Continuity Playlist : ua-cam.com/play/PL20ogj9nfKTkL5c8aDSx_-E2PETnDGEYJ.html
SQL Server Indexing Playlist : ua-cam.com/play/PL20ogj9nfKTmCcvbEvKZJifIJyDC7uB_K.html&si=82lPqcseWyAPIoBG
SQL Server Performance Tuning Playlist : ua-cam.com/play/PL20ogj9nfKTmOyaU8T6BlfN3Bctnl_V3_.html&si=qsJVr431eEhLokZn
SQL Server Integration Services Playlist : ua-cam.com/play/PL20ogj9nfKTle1MWxnzy40TZqKGlio__p.html
SQL Server Tables Playlist : ua-cam.com/play/PL20ogj9nfKTnOe1J7UCTXDE3xgtRInw7c.html
My TopMate.io Page : topmate.io/vermavine
SQL Server Coaching - 1 Session (60 Minutes) - INR 1500
topmate.io/vermavine/1151888
SQL Server Coaching - 30 Sessions (60 minutes per session) - INR 30000
topmate.io/vermavine/1151907
Guidance on where and how to start with SQL Server - ( 45 mins session) - INR 500
topmate.io/vermavine/1146496
Question related to SQL Server - INR 500 per question
topmate.io/vermavine/629301/pay
Make us your partner in your learning. Discuss/Teach us your learnings in Technology - INR 400 (60 minutes session)
topmate.io/vermavine/1147634
#sqlserver #sqlforbeginners #sqlab #database #databasesystems #sql #sqltips #databaseconcepts #databases #databaseprogramming #databasedevelopment #databaseadmin #ssis #ssms #indexing #backupdata #sqlinterviewquestions #sqltraining
#sqltutorial #sqltutorials #sqltutorialforbeginners #sqlcourse #sqlcommands #sqlquery #sqlqueries #backup #data #databackup #datacommunity #datacamp #datadrivensuccess #dataengineering #dataengineer #dataengineers #dataengineeringessentials #sqlpractice #mediaset #sqldb #sqlite #sqltraining #sqlbasics #sqlfullcourse #sqlfunctions #sqlfundamentals #sqlfordatascience #sqljoins #sqllearning #sqlmastery #sqlmap #sqlperformance #sqlprogramming #sqlplus #sqlpractice #sqlqueries #sqlquery #sqlquiz #sqlqueryinterviewquestionsandanswers #sqlserver #sqlschool #sqlservermanagementstudio #sqlservertutorial #sqlskills #sqlsyntax #sqlserver2017 #sqlserverdba #sqlserver2022 #sqlserver2019
Переглядів: 17

Відео

Data Types | Microsoft SQL Server | Transact-SQL | Data Science | Techie Vineet
Переглядів 23День тому
Data Types | Microsoft SQL Server | Transact-SQL | Data Science | Techie Vineet In this video, we have discussed about Data Types that SQL Server Supports under the following Data Categories: Exact Numerics: tinyint, smallint, int, bigint, bit, decimal, numeric, money, smallmoney. Approximate Numerics: float, real. Date and Time: date, time, datetime2, datetimeoffset, datetime, smalldatetime. C...
String and Binary Data Types - Part 4 | Microsoft SQL Server | NCHAR and NVARCHAR | Transact-SQL
Переглядів 30День тому
String and Binary Data Types - Part 4 | Microsoft SQL Server | NCHAR and NVARCHAR | Transact-SQL In this video we have discussed about string and binary data types including nachar, nvarchar, text, ntext, image. We have also talked about syntax and usage of these data types. T-SQL Bootcamp - 200 Days of Group Coaching Google Forms Link : forms.gle/TMock1ZDd9kyFpaC6 Course Fee : Rs. 40000/- My C...
String and Binary Data Types - Part 3 | Microsoft SQL Server | char, varchar | Transact-SQL
Переглядів 3514 днів тому
String and Binary Data Types - Part 3 | Microsoft SQL Server | char, varchar | Transact-SQL This video discusses about various conversion scenarios with character data. We have also demonstrated these conversions using the following DEMOS: DEMO 1: Show the default value of n when used in variable declaration. DEMO 2: Show the default value of n when varchar is used with CAST and CONVERT. DEMO 3...
String and Binary Data Types - Part 2 | Microsoft SQL Server | Char and varchar | Transact-SQL
Переглядів 2314 днів тому
String and Binary Data Types - Part 2 | Microsoft SQL Server | Char and varchar | Transact-SQL In this video we have discussed about Char and varchar Data Types, their syntax and usage. We elaborated on parameters n and max for these data types. We have also shown you a DEMO on how to check the collation of a database. T-SQL Bootcamp - 200 Days of Group Coaching Google Forms Link : forms.gle/TM...
String and Binary Data - Part 1 | Microsoft SQL Server | Binary, Varbinary | Transact-SQL
Переглядів 2414 днів тому
String and Binary Data - Part 1 | Microsoft SQL Server | Binary, Varbinary | Transact-SQL In this video we have discussed about String and Binary Data types including Binary and Varbinary data types. We have shown you the syntax and usage. Finally, we talked about Conversion of binary and varbinary data and have taken you through the DEMO where truncation happens when storing large integer data...
Numeric Data Types - Part 3 | Microsoft SQL Server | Money and SmallMoney Data Types | Techie Vineet
Переглядів 5021 день тому
Numeric Data Types - Part 3 | Microsoft SQL Server | Money and SmallMoney Data Types | Techie Vineet In this video, we have discussed about Money and SmallMoney Data types in SQL Server. Then we further discussed on conversion of money data using below DEMO: DEMO : Convert money data types smallmoney and money values to varchar and decimal T-SQL Bootcamp - 200 Days of Group Coaching Google Form...
Numeric Data Types - Part 2 | Microsoft SQL Server | Float, Real, int, bigint, smallint, tinyint
Переглядів 6021 день тому
Numeric Data Types - Part 2 | SQL Server | Float, Real, int, bigint, smallint, tinyint In this video we have discussed about Float and Real Data Types, Conversion of Float and Real Data, int, bigint, smallint, tinyint Data Types, conversion and parameterization, conversion of Integer Data. We have also covered the following DEMO: DEMO : Create a table using the bigint, int, smallint and tinyint...
Numeric Data Types - Part 1 | Microsoft SQL Server | Bit, Decimal and Numeric Data Types
Переглядів 13528 днів тому
Numeric Data Types - Part 1 | Microsoft SQL Server | Bit, Decimal and Numeric Data Types In this video we have discusses about various numeric data types including Bit, Decimal and Numeric Data Types. We have also talked about Precision and Scale related to Decimal and Numeric Data Types. We have also covered the following DEMO: DEMO : Creating a table using the decimal and numeric data types T...
Date and Time Data Types - Part 5 | Microsoft SQL Server | Transact SQL | Data Science
Переглядів 48Місяць тому
Date and Time Data Types - Part 5 | Microsoft SQL Server | Transact SQL | Data Science In this video we have discussed about the time data type and covered the following DEMOS related to it: DEMO: Converting time(n) Data Type to Other Date and Time Types DEMO: Comparison of date and time data types DEMO: Inserting Valid Time String Literals into time(7) column. DEMO: Inserting Time String Liter...
Date and Time Data Types - Part 4 | Microsoft SQL Server | Transact SQL | Data Science
Переглядів 51Місяць тому
Date and Time Data Types - Part 4 | Microsoft SQL Server | Transact SQL | Data Science This video discusses about date and time data types. We have stated with the following DEMO: DEMO : Convert datetimeoffset data type to other date and time types Afterwards we talked about converting string literals to datetimeoffset data type. Then we touched upon smalldatetime data type followed by below de...
Date and Time Data Types - Part 3 | Microsoft SQL Server | Transact-SQL | Data Science
Переглядів 1032 місяці тому
Date and Time Data Types - Part 3 | Microsoft SQL Server | Transact-SQL | Data Science In this video, we have demonstrated below: DEMO : Casting various datetime string literals into various date and time datatype formats DEMO : Discussion on Time Zone conversion Syntax (AT TIME ZONE syntax) DEMO : Convert to datetimeoffset data type We also discussed about Time Zone Offsets briefly. T-SQL Boot...
Setting Package Properties | SSIS Training | Microsoft SQL Server | Data Science | Techie Vineet
Переглядів 442 місяці тому
Setting Package Properties | SSIS Training | Microsoft SQL Server | Data Science | Techie Vineet In this video, we have discusses about the various categories of properties for Packages in SSIS. These categories include: Checkpoints, Execution, Forced Execution, Identification, Miscellaneous, Security, Transaction, Version. T-SQL Bootcamp - 200 Days of Group Coaching Google Forms Link : forms.g...
How to create Packages | SQL Server | Integration Services | Data Science | Techie Vineet
Переглядів 1053 місяці тому
How to create Packages | SQL Server | Integration Services | Data Science | Techie Vineet In this video, we have discussed and demonstrated on how you can create packages in SQL Server Data Tools. We have also covered the following DEMOS: DEMO 1: Create a Package in SQL Server Data Tools using the Package Template. DEMO 2: How to choose the target version of a project and its packages. DEMO 3: ...
Integration Services ETL Project Tutorial - Pt 12 | Microsoft SQL Server | SSIS | Data Science
Переглядів 1234 місяці тому
Integration Services ETL Project Tutorial | Microsoft SQL Server | SSIS | Data Science In this video, we have demonstrated how you can create a deployment bundle in SSIS and how to install the packages inside SQL Server using this Deployment Bundle. T-SQL Bootcamp - 200 Days of Group Coaching Google Forms Link : forms.gle/TMock1ZDd9kyFpaC6 Course Fee : Rs. 40000/- My Channel Page : www.youtube....
Integration Services ETL Project - Pt 11 | Microsoft SQL Server | SSIS | Data Science
Переглядів 824 місяці тому
Integration Services ETL Project - Pt 11 | Microsoft SQL Server | SSIS | Data Science
Integration Services ETL Project Tutorial - Pt 10 | Microsoft SQL Server | SSIS | Data Science
Переглядів 2384 місяці тому
Integration Services ETL Project Tutorial - Pt 10 | Microsoft SQL Server | SSIS | Data Science
Mirrored Backup Media Sets | Microsoft SQL Server | Business Continuity | Backup and Restore
Переглядів 805 місяців тому
Mirrored Backup Media Sets | Microsoft SQL Server | Business Continuity | Backup and Restore
Temporal Tables - Part 4 | Microsoft SQL Server | Database Design | Data Science | Techie Vineet
Переглядів 505 місяців тому
Temporal Tables - Part 4 | Microsoft SQL Server | Database Design | Data Science | Techie Vineet
T-SQL Bootcamp | Microsoft SQL Server | Learning and Development | Data Science | Techie Vineet
Переглядів 1245 місяців тому
T-SQL Bootcamp | Microsoft SQL Server | Learning and Development | Data Science | Techie Vineet
Creating New Media Sets | Microsoft SQL Server | Business Continuity | Data Science
Переглядів 375 місяців тому
Creating New Media Sets | Microsoft SQL Server | Business Continuity | Data Science
Backup Sets | Microsoft SQL Server | Business Continuity | Backup and Restore | Data Science
Переглядів 375 місяців тому
Backup Sets | Microsoft SQL Server | Business Continuity | Backup and Restore | Data Science
Media Sets and Media Families | Microsoft SQL Server | Backup and Restore | Data Science
Переглядів 355 місяців тому
Media Sets and Media Families | Microsoft SQL Server | Backup and Restore | Data Science
Backup Devices - Part 2 | Microsoft SQL Server | Data Science | Business Continuity
Переглядів 315 місяців тому
Backup Devices - Part 2 | Microsoft SQL Server | Data Science | Business Continuity
Backup Devices - Part 1 | Microsoft SQL Server | Business Continuity Data Science
Переглядів 545 місяців тому
Backup Devices - Part 1 | Microsoft SQL Server | Business Continuity Data Science
Recovery Models (Theory) | Microsoft SQL Server | Business Continuity | Data Science
Переглядів 575 місяців тому
Recovery Models (Theory) | Microsoft SQL Server | Business Continuity | Data Science
Temporal Tables - Part 3 | Microsoft SQL Server | Database Design Data Science | Techie Vineet
Переглядів 625 місяців тому
Temporal Tables - Part 3 | Microsoft SQL Server | Database Design Data Science | Techie Vineet
Encrypted Backups | Microsoft SQL Server | Business Continuity | Data Science | Techie Vineet
Переглядів 725 місяців тому
Encrypted Backups | Microsoft SQL Server | Business Continuity | Data Science | Techie Vineet
Backup Compression (Theory) | Microsoft SQL Server | Business Continuity | Techie VIneet
Переглядів 466 місяців тому
Backup Compression (Theory) | Microsoft SQL Server | Business Continuity | Techie VIneet
Temporal Tables - Part 2 | Microsoft SQL Server | Database Design Data Science | Techie Vineet
Переглядів 466 місяців тому
Temporal Tables - Part 2 | Microsoft SQL Server | Database Design Data Science | Techie Vineet