SQL Server 30 - How to INSERT Data

~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~

🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853

[kateprincessramirez]

How to insert in parent table that is an empty reconds

[nicky]

How do I insert data into the table that contains composite primary keys??

[lenoir]

i'm glad that there are such videos to help me through my project, thank you so much! However, is it possible to add in pictures to our database? I am quite unsure how to do that..do we just type in ___.jpg for an example into our database or just leave it blank?

[eduardoduarte]

I needed this earlier and just now finding it! Thank you so much!

[robertdonnan]

Thank you. Very clearly explained and easy to listen to.

[vjglucky]

Whoa, and for the 1st time, mine flipped back to master (no apparent reason, except closed and opened again), so when looking at Subscribe tables (I had put them in Master database, but later recreated them in database called Subscribe (Caleb's db name, just copying him). So? It was updating my version in master, but sitting looking at the Subscribe table, it wasn't there. Duh.

[FarebrothaChronicle]

In your example what if I only wanted to add another row of data and just enter the contact email for now. Then at some point add the name and species at a later date. Show ME!

[reddawn]

I want to build a database to store daily trade data for a company. The design I came up with is as followed: - A table for the company names, called CompanyNames. Each name is unique. Another table called Dates, to store the dates of trade for ten years for each company. A third table called TimePrice, to store the time stamp and price of the trade for that date and to be access by that date row. And another table called TradeOpenClose, to store the open and close prices for that date and as well, should be access by the date row. I want to be able to check for a company name, if it is there, access the dates table for that company, check for a date. If it is there, access the TimePrice table or the TradeOpenClose for that date and get the data by row, or by table. My problem is that I know nothing about databases and what I am learning from the internet does not really show how to access an entire table from a row in a parent table. Can a knowledgeable someone please explain to a total idiot, how to go about this. I have gone over probably all the tutotes on the net. Help….

[part-of-juffo-wup]

These are informative courses, but INSERT without defining columns is bad practice. If later on, some columns get added, that code will crash.