SQL Server - SA Account

SQL Server - SA Account

What Default 'SA' SQL Admin user Password

https://learn.microsoft.com/en-us/answers/questions/602203/what-default-39sa39-sql-admin-user-password.html

Boolean Data Type

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/logical-operators-transact-sql?view=sql-server-ver16

Difference between Left Join and Inner Join

Use a LEFT JOIN operation to create a left outer join. Left outer joins include all of the records from the first (left) of two tables, even if there are no matching values for records in the second (right) table.

You can use an INNER JOIN operation in any FROM clause. This is the most common type of join. Inner joins combine records from two tables whenever there are matching values in a field common to both tables.

https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/left-join-right-join-operations-microsoft-access-sql

https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/inner-join-operation-microsoft-access-sql

Additionally,

Duplicate Table

We can create duplicate table without records with the help of below SQL syntax

select * into Duplicatetable1 from originaltable where 1=0

We can create duplicate table with records with the help of below SQL syntax

select * into Duplicatetable2 from originaltable where 1=1

Kill session An ultimate activity

While killing a session we need to understand if SPID belong to DBA related activity otherwise we can inform application team.

Best Regards

Amit Vaid