- 454
- 635 806
Software Nuggets
United States
Приєднався 23 гру 2020
Welcome to Software Nuggets! With over 30 years in the tech industry, I’m here to simplify complex programming and software development concepts, helping you build practical skills wherever you are on your journey. My background in coding, project management, and team leadership gives me a broad view of what it takes to succeed in tech.
As the sole presenter, I’m committed to providing content that’s informative and relevant to real-world situations. Here, you’ll find tutorials, design insights, and examples that go beyond theory. My goal is to teach through clear explanations and relatable examples, guiding you through the "how" and "why" of coding.
Software Nuggets is a space for all levels of developers to learn and connect. Whether you’re just starting or refining your expertise, my aim is to make complex topics approachable and enjoyable. Thanks for visiting-let’s dive into software development together!
github.com/softwareNuggets
Email: softwareNugget65@gmail.com
As the sole presenter, I’m committed to providing content that’s informative and relevant to real-world situations. Here, you’ll find tutorials, design insights, and examples that go beyond theory. My goal is to teach through clear explanations and relatable examples, guiding you through the "how" and "why" of coding.
Software Nuggets is a space for all levels of developers to learn and connect. Whether you’re just starting or refining your expertise, my aim is to make complex topics approachable and enjoyable. Thanks for visiting-let’s dive into software development together!
github.com/softwareNuggets
Email: softwareNugget65@gmail.com
PostgreSQL Script for Generating 1M Random Transaction Data
Other video title that didn't make the cut
1) PostgreSQL Script: Generating Fake Data for Transactions
2) PostgreSQL Script for Inserting Random Transaction Logs
3) PostgreSQL Script for Inserting 1 Million Transaction Records
4) PostgreSQL Script to Simulate Transactions for Testing
5) Building Random Transaction Data with PostgreSQL Script
1) PostgreSQL Script: Generating Fake Data for Transactions
2) PostgreSQL Script for Inserting Random Transaction Logs
3) PostgreSQL Script for Inserting 1 Million Transaction Records
4) PostgreSQL Script to Simulate Transactions for Testing
5) Building Random Transaction Data with PostgreSQL Script
Переглядів: 159
Відео
Find large folders & disk hogs with Excel VBA using FileSystemObject (FSO)
Переглядів 4116 годин тому
This Excel VBA tutorial shows how to use FileSystemObject (FSO) to find large files and disk hogs on your computer. The code demonstrates how to retrieve folder names and their corresponding sizes, and display them in an Excel worksheet. By leveraging VBA and the FileSystemObject, you can quickly gather folder sizes, identify large folders, and manage disk space more efficiently. Learn how to a...
Master PostgreSQL Window Functions: Learn RANK vs. DENSE_RANK with Simple Examples!
Переглядів 43Місяць тому
SQL window ranking functions PostgreSQL RANK PostgreSQL DENSE_RANK How to use PostgreSQL PARTITION BY How to use OVER clause PostgreSQL data ranking Each example straight forward and easy to understand. #softwarenuggets @softwareNuggets
Master the New JSON_TABLE Function in PostgreSQL 17, JSON to table.
Переглядів 236Місяць тому
PostgreSQL JSON to table PostgreSQL json_table function Working with JSON data in PostgreSQL JSONB tutorial PostgreSQL PostgreSQL JSON column to table PostgreSQL query JSON efficiently timestamp 0:00 intro software nuggets 0:03 introduce json_table function 0:17 download source from github 0:37 create table to store json 0:55 insert JSON into table 1:29 select * from table (see the json) 1:52 u...
PostgreSQL 17: New MERGE SQL Command for Combined INSERT, UPDATE, and DELETE Operations
Переглядів 140Місяць тому
Master PostgreSQL: Insert, Update, and Delete in One Command! MERGE SQL Command Postgresql MERGE SQL Command for Combined INSERT, UPDATE, and DELETE Learn how to efficiently manage your database with this powerful PostgreSQL technique. In this video, we'll show you how to perform insert, update, and delete operations all at once using a single SQL command. PostgreSQL 17 feature: MERGE command I...
HackerRank: Harry potter and wands, Ollivander's Inventory - SQL Server.
Переглядів 1062 місяці тому
Users will learn how to write a complex SQL query using Common Table Expressions (CTEs) to solve a problem involving filtering and sorting data from multiple tables. They'll understand how to use JOIN operations, aggregate functions, and ORDER BY clauses to extract specific information based on given criteria. Master the use of Common Table Expressions in SQL queries Understand how to join mult...
Rust: Learn Rust Traits with Practical Code Example
Переглядів 262 місяці тому
Learn Rust Traits with Practical Code Example We begin by creating a Shape trait, defining the area and display functions, which represent the core functionality of various shapes. Using Rust trait objects, we demonstrate how to implement the Shape trait for a Rectangle struct, encapsulating properties like width and height. What Rust traits are and how to define them How to use dynamic dispatc...
Learn Python TkInter: Build a World Flags Guessing Game Application step-by-step.
Переглядів 1612 місяці тому
Learn Python TkInter: Build a World Flags Guessing Game Application, step-by-step Embark on an exciting journey to learn Python and master TkInter, one of the most popular GUI frameworks for Python. In this comprehensive, step-by-step tutorial, you'll build an engaging World Flags Guessing Game Application from scratch. This project-based learning experience is perfect for beginners and interme...
ASM Language (L10), How to DEBUG an assembly language program using GDB
Переглядів 1963 місяці тому
How to DEBUG an assembly language program using GDB How to use the file .gdbInit How to write a command and save in .gdbInit How to use break points in gdb for debugging How to use the START command to begin running the debugger How to change the value of a register ⏱️ Timestamps: 00:00 Hey Team Intro 00:03 Quote by Edsger Dijkstra 00:24 Script to Assemble/Compile source code 00:55 4 ways to st...
Assembly x86-64 Tutorial: Swapping Array Elements in Intel Syntax on Ubuntu Linux (Lesson 9)
Переглядів 1123 місяці тому
Learn how to swap two elements in an array using x86-64 Assembly language with Intel syntax on Ubuntu Linux. This comprehensive tutorial (Lesson 9) covers: Calling external C functions (printf) Subroutine implementation and calling Stack management Accessing elements in a 64-bit array Using NASM assembler and GCC compiler how to find offset address in assembly language what is offset in assembl...
Rust HashMap Tutorial: Essential Techniques for Efficient Data Management
Переглядів 714 місяці тому
Master Rust HashMaps with this comprehensive tutorial from #SoftwareNuggets. Ideal for beginners and intermediate Rust programmers looking to enhance their data management skills. Create and initialize HashMaps Manage capacity and length Perform insert, get, and remove operations Implement custom traits Use pattern matching with HashMaps Optimize HashMap performance Table of Contents 00:00 Hey ...
Node.js PostgreSQL Tutorial: Calling Functions & Database Operations
Переглядів 2524 місяці тому
Node.js PostgreSQL Tutorial: Calling Functions & Database Operations Learn how to integrate Node.js with PostgreSQL using the pg package. Discover essential tips for establishing connections, executing SQL operations, and calling PostgreSQL functions from your Node.js applications. Perfect for programmers diving into database-driven web development!" Master essential Node.js database operations...
Master Number Base Addition: Decimal, Hexadecimal, Octal, Binary Using Carry Technique
Переглядів 864 місяці тому
Learn the universal carry technique for adding numbers in multiple bases with this comprehensive tutorial by #SoftwareNuggets. Perfect for computer science students, programmers, and math enthusiasts How to Subtract Binary ua-cam.com/video/KGXYzU1neVo/v-deo.html How to Subtract Hexadecimal ua-cam.com/video/X3Nozo41Rgg/v-deo.html How to Add Hexadecimal ua-cam.com/video/rF8eKBQNXDc/v-deo.html How...
HackerRank: Solution for Symmetric Pairs problem for SQL Server.
Переглядів 4455 місяців тому
HackerRank: Solution for Symmetric Pairs problem for SQL Server.
Command Line Calculator - A Calculator that converts Infix to Postfix using C# .Net 8
Переглядів 805 місяців тому
Command Line Calculator - A Calculator that converts Infix to Postfix using C# .Net 8
How-To Convert Infix to Postfix Notation. Learn with Three Examples
Переглядів 3295 місяців тому
How-To Convert Infix to Postfix Notation. Learn with Three Examples
Create A Tkinter Listbox In Python: Learn To Build A Reusable Component
Переглядів 6036 місяців тому
Create A Tkinter Listbox In Python: Learn To Build A Reusable Component
HackerRank: Solution for Interviews, a problem for SQL Server.
Переглядів 1346 місяців тому
HackerRank: Solution for Interviews, a problem for SQL Server.
PostgreSQL: Write a Dynamic Function using ALTER TABLE with JSON parameter!
Переглядів 1566 місяців тому
PostgreSQL: Write a Dynamic Function using ALTER TABLE with JSON parameter!
Learn Python,Tkinter and MongoDB to build a Movie Search App with Posters!
Переглядів 2477 місяців тому
Learn Python,Tkinter and MongoDB to build a Movie Search App with Posters!
Calling Extern Printf() In Assembly Code: Code up a Small app to learn the steps!
Переглядів 4547 місяців тому
Calling Extern Printf() In Assembly Code: Code up a Small app to learn the steps!
ASM Language: How to Sum the Digits from 8-bit Byte Array - Intel-Syntax Lesson 7. Assembly.
Переглядів 1047 місяців тому
ASM Language: How to Sum the Digits from 8-bit Byte Array - Intel-Syntax Lesson 7. Assembly.
HackerRank: How to Master SQL Joins and Grouping for Advanced Data Analysis. 🚀
Переглядів 768 місяців тому
HackerRank: How to Master SQL Joins and Grouping for Advanced Data Analysis. 🚀
PostgreSQL: How to write a Function to validate an Email Address using Regex.
Переглядів 2298 місяців тому
PostgreSQL: How to write a Function to validate an Email Address using Regex.
ASM Language: How to get input (sys_read) from the user in Assembly. Lesson 6. Intel-Syntax.
Переглядів 2508 місяців тому
ASM Language: How to get input (sys_read) from the user in Assembly. Lesson 6. Intel-Syntax.
HackerRank: How to Loop over Binary Tree Nodes in SQL Server.
Переглядів 1079 місяців тому
HackerRank: How to Loop over Binary Tree Nodes in SQL Server.
ASM Language: Learn the JUMP assembly language instructions. Lesson 5. Intel-Syntax.
Переглядів 3889 місяців тому
ASM Language: Learn the JUMP assembly language instructions. Lesson 5. Intel-Syntax.
PostgresSQL : How to Parse XML with Attributes. Insert into a Table.
Переглядів 4669 місяців тому
PostgresSQL : How to Parse XML with Attributes. Insert into a Table.
XML Parsing in PostgreSQL: Utilizing XPath for Variable Extraction for Table Insertion.
Переглядів 1,2 тис.9 місяців тому
XML Parsing in PostgreSQL: Utilizing XPath for Variable Extraction for Table Insertion.
Lesson 4 - Calculate area of rectangle in Assembly Language. Area = Width * Length. Using IMUL
Переглядів 3859 місяців тому
Lesson 4 - Calculate area of rectangle in Assembly Language. Area = Width * Length. Using IMUL
视频内容非常精彩!我有一点困惑:有人给我转usdt,我有恢复短语。{pride}-{pole}-{obtain}-{together}-{second}-{when}-{future}-{mask}-{review}-{nature}-{potato}-{bulb} 我该如何提取它们呢?
You wrote: The video content is very exciting! I'm a little confused: someone transferred me USDT and I have the recovery phrase. {pride}-{pole}-{obtain}-{together}-{second}-{when}-{future}-{mask}-{review}-{nature}-{potato}-{bulb} What should I do What about extracting them? Hey @SybylCampbell, are you asking me a crypto currency question, or, how to parse this: {pride}-{pole}-{obtain}-{together}-{second}-{when}-{future}-{mask}-{review}-{nature}-{potato}-{bulb}
How to transfer the some data or all data from datagridview1 to datagridview2 in the same form with C# ? How to edit the data in datagridview1 or datagridview2 in any column and row and add the new row and remove the row too ?
// Method 1: Transfer All Rows private void TransferAllRows() { // Clear destination DataGridView first dataGridView2.Rows.Clear(); // Copy all rows from dataGridView1 to dataGridView2 foreach (DataGridViewRow row in dataGridView1.Rows) { if (!row.IsNewRow) // Exclude the new row template { dataGridView2.Rows.Add(row.Cells.Cast<DataGridViewCell>() .Select(cell => cell.Value).ToArray()); } } } // Method 2: Transfer Selected Rows private void TransferSelectedRows() { foreach (DataGridViewRow row in dataGridView1.SelectedRows) { if (!row.IsNewRow) { dataGridView2.Rows.Add(row.Cells.Cast<DataGridViewCell>() .Select(cell => cell.Value).ToArray()); } } } // Method 3: Transfer Specific Rows by Condition private void TransferFilteredRows() { var rowsToTransfer = dataGridView1.Rows .Cast<DataGridViewRow>() .Where(row => SomeCondition(row)) // Define your condition .ToList(); foreach (var row in rowsToTransfer) { dataGridView2.Rows.Add(row.Cells.Cast<DataGridViewCell>() .Select(cell => cell.Value).ToArray()); } } Editing a Cell: Find the exact row and column you want to change Use dataGridView1.Rows[rowIndex].Cells[columnIndex].Value = newValue Replace rowIndex and columnIndex with actual numbers Replace newValue with the text or data you want to put in that cell Adding a New Row: Use dataGridView1.Rows.Add() method Put the values for each column in order Can add values directly or create a new row first, then add values Deleting a Row: Two main ways to delete: a) Delete by row number: dataGridView1.Rows.RemoveAt(rowIndex) b) Delete selected row: dataGridView1.Rows.Remove(dataGridView1.SelectedRows[0]) Always check if rows exist before trying to delete Tips: rowIndex starts at 0 (first row is 0, second is 1) Use dataGridView1.Rows.Count to know how many rows exist Hope this helps
Please send this code
--Here is the create table command and insert data github.com/softwareNuggets/VBA_for_Excel_resources/blob/main/sales_data.sql --Here is vba code for this video github.com/softwareNuggets/VBA_for_Excel_resources/blob/main/how_to_fetch_data_with_vba.bas
Great video sir.
Much appreciated.
many thanks
Hope this video was helpful. Thanks for leaving a comment.
thanks for the video man !
I hope this video was useful. thanks for leaving a comment @ahmadjerjees428
Good video.
Thanks. Hope it was helpful.
how is a 10 minute video 8 minutes too long...
Hey @seangillespie4601, I agree! The video has been trimmed to remove unnecessary segments.
Thanks!
Hey @nickeax, much appreciated. It means a lot to me that you took the time to support my content with a super thanks.
@@SoftwareNuggets thanks for the great content! Cheers
Hi, I'm first year of high school we learn in french but actually this is the only video that i understood from ,thank you so much 💓
Hey @shayma_0e! That's awesome that you're learning hexadecimal in your first year of high school! 😊 I'm really glad this video helped you out. If you're interested, I have another video that shows how to subtract hexadecimal numbers: ua-cam.com/video/X3Nozo41Rgg/v-deo.html Keep up the great work - you're doing amazing! 👍
you briefly reference the function Build_PostgreSQL_ConnectionString, the most important part, but you fail to explain what it does. Another minute of video would have been helpful.
Function Build_PostgreSQL_ConnectionString() as String dim connStr as String 'set up connection string connStr = "DSN=dvdRentalDSN;" Build_PostgreSQL_ConnectionString = connStr End Function Above, you can see DSN=dvdRentalDSN I'm using Windows 10/11 To create a Data Source Name (DSN) in Windows 10, which allows applications to connect to a database using the Open Database Connectivity (ODBC) standard, you can follow these steps: 1. Open ODBC Data Source Administrator Press Win + R to open the Run dialog. Type odbcad32 and press Enter. This opens the ODBC Data Source Administrator dialog. On 64-bit Windows, you'll see two versions: ODBC Data Source (64-bit) for 64-bit applications ODBC Data Source (32-bit) for 32-bit applications Choose the correct version based on your application's architecture. 2. Add a New DSN Go to either the User DSN (for individual user accounts) or System DSN (for all users) tab, depending on your requirements. Click Add... to create a new DSN. 3. Select a Driver In the list, choose the appropriate ODBC driver for the database you're connecting to (e.g., SQL Server, MySQL, Oracle). Click Finish. 4. Configure the Data Source A configuration dialog for the selected driver will appear. Fill in the necessary details: Data Source Name: Give your DSN a unique, descriptive name. Description: Optionally, add a description for the DSN. Server Name or Network Address: Specify the database server's name or IP address. Database Name: Enter the database name (if required by the driver). Authentication: Provide credentials, like username and password, if necessary. 5. Test the Connection (Optional) Most ODBC configuration dialogs have a Test Connection button. Click it to confirm that the DSN configuration is correct. 6. Save the DSN Once configured, click OK to save the DSN. After you create the DSN, we will use this connection to connect to PostgreSQL. Hope this helps Scott
Please let me know if you were able to create the DSN, use the DSN, connect to The PostgreSQL database.
Wow. They've made JSON harder to work with.. Good job, guys!!
Progress is made by taking small steps.
I was looking for this kind of video.. Thank you. Explanation was very nice. It cleared my concept.
Glad to hear this video was useful, in the video, command line calculator, I actually use this algorithm. It worth checking out.
Thanks so much sir!! I was so confused when our prof tackled about this you just made it so easy <3
Hey @Phyreuben1, glad to hear this video was useful. I appreciate you leaving a message. Wish you much success.
Can I use the pivot table to summarize data from multiple columns at the same time, or do I need to do each column one by one?
Using a PIVOT table, just think, ROWS to COLUMNS. Create me an example, and share with me, how to use a PIVOT command.
Really helpful video on CASE expression. When using "Case", does it matter if I place it in the select or where clause? If so, how do I know which clause to put it in?
The CASE statement, can be used in the SELECT clause, the WHERE clause, the Order by clause, the GROUP BY clause, the HAVING Clause, and can also be used in JOIN conditions. As you can see, the CASE statement is very versatile. It's indispensable. This is one statement in SQL you must master! I recommend you write a SQL Expression, and try and use the CASE statement in all the elements I listed above. You'll need to practice this statement to become the master.
Can you explain when its better to use having instead of just adding conditions in the where clause?
a) the HAVING clause is primarily used with GROUP BY to perform a "WHERE filter" on the results of an aggregate function. b) HAVING does act similarly to WHERE, but on grouped data rather than individual rows. c) Aggregate functions such as MIN, MAX, SUM, AVG, and COUNT are used to perform calculations across multiple rows, effectively collapsing them into a single result. When data has been aggregated in this manner, typically in conjunction with a GROUP BY clause, the HAVING clause becomes an invaluable tool for filtering these aggregated results based on specific conditions.
Thank you for this breakdown of the select statement. When using select top 10, how could I retrieve the bottom 10 rows in a table?
Change the direction of the data with order by field, top 10 will be those rows. Try this, let me know
@@SoftwareNuggets Thank you!
And how to parse XML when you don't know the number and names of tags? That is, create a unique function XML -> Table. I try first XML -> JSON and only then to TABLE via temporary tables, but there is a performance problem due to recursion and duplicate column error
Why won’t you know the tag names? You are just going to load random data into your database?
@@SoftwareNuggets Because these are different xml state reference books and there are many of them and they all have different contents, and each such xml reference book needs to be saved as a separate table in the database
@stark1909 is it possible you send me several different files to: softwareNugget65@gmail.com
thank you very much for this!
Much appreciated for the comment!
Why do i have error: self.button1 = tk.Button(self.root, text="Button 1", width=40, command=lambda: self.check_answer(0)) ^^^^^^^^^^^^^^^^^^^^ line 313, in check_answer if 0 <= self.correct_answer < self.num_answers: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ TypeError: '<=' not supported between instances of 'int' and 'NoneType' please, help me
Hey @bleedingrx1079, what version of Python are you using? I am using 3.11.5 Check out my github account for a new version of this program. Look for the file called: flagsV2.py Here is a link to that file: github.com/softwareNuggets/Python_Shorts/blob/main/LearnCountryFlags/flagsV2.py Please let me know if this fixes your issue. Scott
@@SoftwareNuggets Yessirr it works, turns out that was my fault(stupid), anyways, thanks for help!
@bleedingrx1079, Fixing errors builds your problem-solving muscles. Embrace these struggles - they're opportunities to grow. The expertise you're gaining now will serve you throughout your entire career. So, you got the app to work on your computer?
@@SoftwareNuggets I'm sorry for late answering. I completely agree with u, without errors we couldn't gain any experience. And of course it works! Thanks for your worries
@bleedingrx1079 so you got the app working? Did you add any features?
thanks for this, good luck to me for the exam!
Hey @BrecioCharlesFrancis , Here is a short video to solve this Adding Hex problem. 9C84 25AC ------------- Please try and do by yourself, then use the video to get correct answer. ua-cam.com/users/shorts15aMoWsRl80 Good luck with your exam. Please let me know how you did!
Thanks from Africa
Hey @LibyaMicro, much appreciated.
Excellent in Firebird databases there are also computed column that can fetch the value of a field from another table. such as bringing the department name from another table with the value of the field ID in the current table
I need to check out firebird. Thanks for the introduction!!
@@SoftwareNuggets However, this can only be done in PostgreSQL by calling a function. CREATE TABLE product ( product_id UUID price FLOAT available_location VARCHAR GENERATED ALWAYS AS fetch_product_location(product_id) )
@LibyaMicro that’s a great example. Thanks for the update.
Amazing lecture. Thanks Software Nuggets!
Much appreciated!
I love the calm, deliberate, clear way you speak and illustrate the answers. Can you come teach at my school?
Thanks for the message. Appreciate you taking the time to reach out. Are you a CS student?
@@SoftwareNuggets I'm a Biomedical Tech student. We are following an Electronic Engineering Tech program which include Digital Logic I. The notes our instructor has given us does not explain how to add/subtract Hex numbers, but it is on the assignment he handed out.
@AdamWatkins-m3c, congratulations on pursuing Biomedical Technology! It's great to see you taking initiative to find additional resources for understanding hexadecimal addition and subtraction. Your instructor will likely be impressed by your proactive approach to learning. If you have any specific questions about hex operations or need further clarification, feel free to ask. Good luck with your studies!
stop speaking like that
Wat do you mean?
For the prefix, you might want to consider using schemas. But glad you are thinking in a helpful fashion either way.
Great observation! Using schemas can indeed help manage permissions and improve data access. It's a smart way to enhance organization within our databases.
Learn all the flags! great video, great learning app!
Thanks
Amazing video!
Thanks @JulianRiverplate14, appreciate the feedback.
good video!
thanks. did you get this app working on your box?
I know how to use computed columns now, thank you.
Question: why would you need a computed column?
@@SoftwareNuggetsYou would need a computed column to automatically calculate values from other columns with a formula so you wouldn’t have to do it by hand.
I understand this, I liked your scenario, it helped understand this much better.
Question: How do you convert a RowVersion value to a Big Integer?
@@SoftwareNuggets You would use cast function
I understand that these are both the same now, thank you.
What one word could you say, so that I know you know why these datatypes are used?
This was pretty informative thank you for this
Question: Does the Timestamp datatype have anything to do with the Date/Time?
@@SoftwareNuggets No, it has absolutely nothing to do with Date/Time
Thank you for this, I understand TimeStamp and now I also know cast statement
when you select a timestamp value, what format is that shown in?
I understand the difference between the two, thank you.
Question: why would these data types be used?
Thank you, I understand this.
why would you use an UniqueIdentifier? How are they different from an Identity column?
Thank you for this, I know how to use BIT data type now.
Question: So the Bit datatype has two states: what are they?
@@SoftwareNuggets 0; false and 1; true
Very informational, I can differentiate all of the date and time data types.
How would you convert a DateTime2 into a SmallDateTime?
Thank you, I understand SMALLINT data type
Question: What is the largest number you can put into a SmallInt datatype?
@@SoftwareNuggets 32,767, the range is from -32,768 to 32767
I know how to efficiently use data type TINYINT now, thank you.
can you use identity(240,10) on a TINYINT datatype? Do you get an error if the identity value > max number allowed? what is the max number I can put into a TINYINT ?
@@SoftwareNuggets Yes you do receive an error if the identity value > max number, and you can use identity (240,10) for only 2 values before you receive an error so it isn’t ideal. The max number that can be used in TinyInt is 255
Thank you for teaching me how to reseed an identity column
What is the purpose and common use case of CHECKIDENT?
Thank you for showing how to use IDENTITY on a int data type
Is this a legit command: counting backwards? create table t33 ( x int identity(10000,-10) not null, y varchar(10) ); insert into t33 values('aaa'); select * from t33;
@@SoftwareNuggets yes this is a legit command
I know how to use data type INT, thank you for this video.
Great. Here are two questions: 1) what is the largest number you can assign an integer? 2) what happens when you add two int that exceed the datatype limit?
I understand how much space a NVARCHAR consumes
How much space and why?
@@SoftwareNuggets 2 bytes per character because it stores data in Unicode
@blixstaa you got it
thank you, i can see the comparison between varchar and nvarchar now
without executing this code: declare @c as nvarchar(10); set @c = 'blixstaa' select DATALENGTH(@c) what will the DATALENGTH(@c) equal? declare @c as nchar(10); set @c = 'blixstaa' select DATALENGTH(@c) what will the DATALENGTH(@c) equal?
@@SoftwareNuggets for nvarchar, it will equal 16 and for nchar it will equal 20
I understand VARCHAR vs CHAR now and how to use ASCII
Question: what is the output of the following: (execute all four rows in one execution) declare @c as char(3); select @c ='A'; select len(@c) select DATALENGTH(@c) what will len(@c) print out? what will DATALENGTH(@c) print out?
@@SoftwareNuggets len(@c) will print 1 and datalength(@c) will print 3
@@blixstaa why does DATALENGTH(@c) print 3?
@@SoftwareNuggets because @c is declared as char(3)
Thank you for describing CHAR
Question: can you put a unicode character like '₡' into a char(2) column?
Question: what does the ascii function return?
@@SoftwareNuggets No you cannot, you must use nchar
@@SoftwareNuggets the ascii value of the first character in a string
@@blixstaa an integer value between 0-255
Could you plz put the source program link? 😊
Hey @sa3a388, you can find the source to this video on my GitHub Account: github.com/softwareNuggets/VBA_for_Excel_resources/blob/main/ElapsedTime.bas