Identities are not unique.  I can insert the value "1000", as...

So, if I created a test table right now, and made an identity column, added 10 rows to it, then rebooted the server, and added another row, you're saying...

...is that actually a thing? restarting SQL Server increments identity fields by 1000? I've never seen that and it doesn't sound like a thing?  Maybe I'm not understanding the...

• This reply was modified 3 years, 9 months ago by Michael L John.

Hi

Doing some testing on a server that has 2 node AG setup. Secondary is set to Read-Intent-only. We are using the AG listener name to connect the application.

If there...

You've been around long enough to know this.  In my signature is a link that...

What is the cause of the failure?  Are you attempting to prevent the failure, and handle it properly?  That may require a lot of work.

If you use "go to step...

Yes- its homework (important one)

pgadmin is the software i use,

this is what i try so far-

SELECT users.users_id, users.first_name, users.last_name, users.gender, deposit.time_stamp, SUM(deposit.amount) AS TotalAmount FROM users

INNER JOIN deposit

ON users.user_id...

Ah, it's asking you to do a LEFT JOIN and then deal with the NULL values to arrive at the value of zero (0) for anyone who doesn't...

"...It is my opinion that the first syntax is best avoided, as I think it is not absolutely clear what the target is..."

How is "update dbo.tablename" unclear ?

I think...

Been given a new server running Win 2019 & SQL 2019 unable to run bat jobs with SQL Agent

So to try & simplify & understand what is happening have...

I see SQL as a query language, used to store and retrieve data. However, there are now many versions of new words with different features. Now I am using...

Why would...

Why does this seem to apply to so many things these days?  It's not just learning a programming language.

Thanksgiving morning, I received a Teams message from an offshore resource asking...

What's PGADMIN?

Is this homework?

What have you tried?   Can you show us what you have attempted?

Can you take a look at this article, which describes how to post a question so...

• This reply was modified 3 years, 10 months ago by Michael L John.

So I will ask...