Windows 10: Can I add data to a table in sql if it is open elsewhere?

I added data to a table in express SQL and it said 1 column affected but when I opened the table back up the data was not there. If someone is using the data in the table while I was updating it will that stop it from updating?

:)

 

[SQL] How to retrieve data from two tables?

If you're using Access you dont have to write any SQl yourself in many cases. Just make a query, add two tables and select fields for both. If you wish to make a query via VBA you can always use this method to create the query itself, or at least a sample. Besides, union is a SQL operator as well *Smile

 

SQL: Importing/Loadin in SQL DB using Excel

Hi All,

Not sure if this is the right place to post this.

I have an excel workbook with two sheets.

I want to continuously load data from this workbook in SQL DB.

I was successful in importing it once using SQL server import export tool.

The tool automatically created the tables and columns based on Excel's sheet and column names.

Now the data in my excel is updated (for the same columns).

My excel will have new data everyday.

How I can make sure that the new data is added in the DB , but I do not want to drop the old data?

Appreciate your suggestions.

Note: I am a novice in SQl server and just learnt about the above tool using different blogs and videos.

Thanks,

Aditya

 

[SQL] How to retrieve data from two tables?

I have two same tables but using for each for different purpose..

How do I get this data as one table? I don't remember exactly but there is some like a union query... any one knows?

Edit: Nothing to do with Joins.. just want to show merged data