DEV Community: Tiến

SQL JOIN IN SQL

Tiến — Tue, 11 Jan 2022 14:38:04 +0000

Hi guys,
These days I work with SQL Execution plans, when I have to detailed analysis of exactly my query execution, I realize don't have a difference between the two ways to get data from two tables on the match field.
In this post, I mention INNER JOIN
#type 1

SELECT
    u.UserName
    ,w.Name
FROM dbo.Users u, dbo.Wallets w 
WHERE u.UserGuid = w.UserGuid

with
#type 2

SELECT
      u.UserName     
     ,w.Name
FROM dbo.Users u
JOIN Wallets w on u.UserGuid = w.UserGuid

If I execute the query above with the execution plan then I have the plan below:
#type 1

#type 2

Just example for this post 😁😁

So, is there no difference here?

How many ways to against spam post API??

Tiến — Tue, 10 Aug 2021 18:04:09 +0000

Vue native beginer

Tiến — Mon, 02 Aug 2021 14:33:02 +0000

Vue js

Implement guile

# Vue native cli
npm install --global vue-native-cli
# For Expo users
npm install --global expo-cli
vue-native init <projectName>
$ cd <projectName>
$ npm start
$ npm run android/ios

The composition API

Ref
Reactive
Computed Values
Watch
WatchEffect
Props
Lifecycle Hooks

reactive vs ref

- reactive() only takes objects, NOT JS primitives (String, Boolean, Number, BigInt, Symbol, null, undefined).
- ref() is calling reactive() behind the scenes.
- Since reactive() works for objects and ref() calls reactive(), objects work for both.
- BUT, ref() has a .value property for reassigning, reactive() does not have this and therefore CANNOT be reassigned.

reference reactive with ref.

Lifecycle Hooks

vue 3 lifecycle hooks

Options API	Hook inside setup
beforeCreate	Not needed*
created	Not needed*
beforeMount	onBeforeMount
mounted	onMounted
beforeUpdate	onBeforeUpdate
updated	onUpdated
beforeUnmount	onBeforeUnmount
unmounted	onUnmounted
errorCaptured	onErrorCaptured
renderTracked	onRenderTracked
renderTriggered	onRenderTriggered
activated	onActivated
deactivated