วีดีโอ

Hey @LibyaMicro, much appreciated.

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.

Much appreciated!

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!

Wat do you mean?

Great observation! Using schemas can indeed help manage permissions and improve data access. It's a smart way to enhance organization within our databases.

Thanks

Thanks @JulianRiverplate14, appreciate the feedback.

thanks. did you get this app working on your box?

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.

Question: How do you convert a RowVersion value to a Big Integer?

@@SoftwareNuggets You would use cast function

Question: Does the Timestamp datatype have anything to do with the Date/Time?

@@SoftwareNuggets No, it has absolutely nothing to do with Date/Time

Question: why would these data types be used?

Question: So the Bit datatype has two states: what are they?

@@SoftwareNuggets 0; false and 1; true

Question: What is the largest number you can put into a SmallInt datatype?

@@SoftwareNuggets 32,767, the range is from -32,768 to 32767

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

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

How much space and why?

@@SoftwareNuggets 2 bytes per character because it stores data in Unicode

@blixstaa you got it

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

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)

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

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

One of the best, much appreciated.

much appreciated!

Thanks. Did you watch the subtract hex video?

Glad to hear this video was useful. Wish you much success.

hey @mahdiali4299 - thanks. I have another video about geography: th-cam.com/video/W8siqbvhEj4/w-d-xo.html - maybe helpful. --scott

Newtonsoft json must be installed. That’s what I meant. Sorry for the confusion.

Much appreciated. Thanks for taking the time to leave a comment.

hey @sulw4236, I agree with you, 'mov' is straightforward, and easier to use. I could have used either syntax. I'm a c programmer, so thinking in pointers: "The mov instruction duplicates the value by copying it into the target register, whereas the lea instruction uses the original address of the value, placing that address into the target register." //mov int rdi; int format_1 = 34; rdi = format_1; //lea int format_1 = 34; int *rdi; rdi = &format_1; hope this helps!

CREATE TABLE xml_table ( xml_data XML ); INSERT INTO xml_table (xml_data) VALUES ( '<toll_data_list> <toll_data> <toll_id>1</toll_id> <vehicle_license_plate state_plate="FL" expiration_date="2024-06">ABC123</vehicle_license_plate> <toll_booth_id>101</toll_booth_id> <toll_amount currency_type="USD" payment_rendered="DEVICE" device_serial="123-4567-89034">5.75</toll_amount> </toll_data> <!-- Add other <toll_data> entries here --> <toll_data> <toll_id>10</toll_id> <vehicle_license_plate state_plate="FL" expiration_date="2024-12">YZA567</vehicle_license_plate> <toll_booth_id>110</toll_booth_id> <toll_amount currency_type="USD" payment_rendered="Cash">5.00</toll_amount> </toll_data> </toll_data_list>' ); from command line psql -U postgres -d postgres -c "COPY (SELECT xml_data FROM xml_table) TO STDOUT WITH (FORMAT text)" > output.xml

@@SoftwareNuggets Thank you so much for your answer!!

Thank you. I have one other video that might be useful: ADD two (Decimal, Hexadecimal, Octal, Binary) using the CARRY Technique. th-cam.com/video/Vd49yfa6DuE/w-d-xo.html

In PostgreSQL, working with INTERVAL is usually fast, but how well it performs can depend on how you use it in your queries and data setup.

Hey Luan, Thank you for letting me know the video was useful to you! I'm always excited to hear when content resonates with viewers. Do you have any requests for other videos?

Thanks for asking. I am interested Traits and Closures in Rust.

Hey @LekkyDev, glad to hear this video was useful. Thanks for letting me be a small part of your programming journey.

Very happy to read your comment. Thanks!

@@SoftwareNuggetswelcome! I was wondering if you could help me out with a college project of mine, i m in my last semester and really stuck in an issue. Im willing to pay if you finish the job! 😄

#Sanketjoice. Thanks for reaching out. I am willing to help you with your college project. I am not available for work for hire. If you'd like for me to help, please explain the problem you need help solving. send to my email address: softwareNugget65@gmail.com

Hey @LekkyDev, I will have a video out tonight, however, I could just upload the source to this problem to my github account earlier if you'd like. Please let me know. If no response, I'll just publish video ASAP.

@@SoftwareNuggets That would be great if you could upload the source but videos are always better because you get to see the build up as well. I really struggle to find any tutorial about plpgsql with nodejs. Thanks for reaching back and looking forward to the source and the video.

@LekkyDev, I will upload the video at 7pm tonight. Look forward to hearing comments from you.

@@SoftwareNuggets Wow thanks in advance. Its past 9pm already central euro time. Still waiting.

I reschedule for 6pm.

Thanks

NO. uniqueIdentifier does not have such a function. However, CREATE TABLE UParent ( ParentID UNIQUEIDENTIFIER PRIMARY KEY, ParentName VARCHAR(100) ); -- Create the child table CREATE TABLE UChild ( ChildID UNIQUEIDENTIFIER PRIMARY KEY, ChildName VARCHAR(100), ParentID UNIQUEIDENTIFIER, FOREIGN KEY (ParentID) REFERENCES UParent(ParentID) ); DECLARE @ParentID UNIQUEIDENTIFIER = NEWID(); -- Insert into UParent INSERT INTO UParent (ParentID, ParentName) VALUES (@ParentID, 'Parent Name'); -- Insert multiple children for this parent INSERT INTO UChild (ChildID, ChildName, ParentID) VALUES (NEWID(), 'Child 1', @ParentID), (NEWID(), 'Child 2', @ParentID), (NEWID(), 'Child 3', @ParentID); -- Optionally, you can select the inserted data to verify SELECT * FROM UParent WHERE ParentID = @ParentID; SELECT * FROM UChild WHERE ParentID = @ParentID;

Thanks Mr Harrison, appreciate the "love"

Much appreciated

Appreciate the message