Interview questions 2022 angular

 

If Record Exists, Update Else Insert

MERGE
INTO    table2 t2
USING   table1 t1
ON      t2.email = t1.email
WHEN MATCHED THEN
UPDATE
SET     t2.col1 = t1.col1,
        t2.col2 = t1.col2
WHEN NOT MATCHED THEN
INSERT  (col1, col2)
VALUES  (t1.col1, t1.col2)

JSON_QUERY (Transact-SQL)

https://www.google.com/search?q=communicatingdata+in+angular&rlz=1C1RXQR_enIN1016IN1016&oq=communicatingdata+in++angular&aqs=chrome..69i57j0i546l2j0i30i546.21656j0j7&sourceid=chrome&ie=UTF-8

How Components Communicate With Each Other In Angular

https://www.google.com/search?rlz=1C1RXQR_enIN1016IN1016&sxsrf=ALiCzsaMQQtDQWVTu16g8FhyLGFO2KBDJA:1666160359941&q=communicating+data+in+angular&spell=1&sa=X&ved=2ahUKEwjclJKD0-v6AhXwSmwGHatdDfIQkeECKAB6BAgFEAE

https://www.thirdrocktechkno.com/blog/how-angular-components-communicate/

https://www.dotnettricks.com/learn/angular/top-20-angular-interview-questions-and-answers

https://www.thirdrocktechkno.com/blog/how-angular-components-communicate/

https://www.sqlshack.com/understanding-the-sql-merge-statement/

https://www.google.com/search?q=check+if+record+exists+in+temp+table+update+else+insert+sql+server&rlz=1C1RXQR_enIN1016IN1016&oq=check+if+record+exists+in+temp+table+update+else+insert+sql+server&aqs=chrome.0.69i59.10573j0j7&sourceid=chrome&ie=UTF-8

https://www.google.com/search?q=how+to+read+json+output+from+sql+server&rlz=1C1RXQR_enIN1016IN1016&sxsrf=ALiCzsZk2vN_38ZOMDL0an4CNUzES5CNiA%3A1666162997803&ei=NaFPY4HSMO_gseMPnM68WA&ved=0ahUKEwjBwPzs3Ov6AhVvcGwGHRwnDwsQ4dUDCA8&uact=5&oq=how+to+read+json+output+from+sql+server&gs_lcp=Cgdnd3Mtd2l6EAMyBQgAEKIEMgcIABAeEKIEMgUIABCiBDIFCAAQogQyBwgAEB4QogQ6CggAEEcQ1gQQsAM6CgghEMMEEAoQoAFKBAhNGAFKBAhBGABKBAhGGABQ5gpYsB1gmSloAnABeACAAdUCiAG0CJIBBzAuMy4xLjGYAQCgAQHIAQjAAQE&sclient=gws-wiz

https://www.google.com/search?q=outer+apply+in+sql&rlz=1C1RXQR_enIN1016IN1016&oq=outer+ap&aqs=chrome.0.0i20i263i512j0i512l9.4755j0j7&sourceid=chrome&ie=UTF-8

https://www.google.com/search?q=coalesce+in+sql&rlz=1C1RXQR_enIN1016IN1016&oq=collase&aqs=chrome.2.69i57j0i10i131i433i512l2j0i10i512l6j0i10i433i512.5622j0j7&sourceid=chrome&ie=UTF-8

https://www.google.com/search?q=check+if+record+exists+in+temp+table+update+else+insert+sql+server&rlz=1C1RXQR_enIN1016IN1016&sxsrf=ALiCzsb5J4ANp-dMWmBK1g31YUioHii-Gw%3A1666162689925&ei=AaBPY-2AOMa7seMPz6S10Ak&ved=0ahUKEwithZXa2-v6AhXGXWwGHU9SDZoQ4dUDCA8&uact=5&oq=check+if+record+exists+in+temp+table+update+else+insert+sql+server&gs_lcp=Cgdnd3Mtd2l6EAM6CggAEEcQ1gQQsAM6BwgjELACECc6BQgAEIYDOgQIIxAnOgUIABCiBDoHCAAQHhCiBDoECCEQCkoECE0YAUoECEEYAEoECEYYAFCXJliAemDegQFoAXABeACAAe4BiAHwGZIBBjAuMjAuMZgBAKABAcgBCMABAQ&sclient=gws-wiz

https://www.google.com/search?q=register+filter+in+web+api&rlz=1C1RXQR_enIN1016IN1016&oq=register+filter&aqs=chrome.1.69i57j0i20i263i512j0i512l8.12903j0j7&sourceid=chrome&ie=UTF-8

https://www.google.com/search?q=get+type+of+input+c%23&rlz=1C1RXQR_enIN1016IN1016&oq=get+type+of+input+c%23&aqs=chrome..69i57j33i22i29i30l4.11392j0j7&sourceid=chrome&ie=UTF-8

https://www.google.com/search?q=genec+method+c%23&rlz=1C1RXQR_enIN1016IN1016&oq=genec+method+c%23&aqs=chrome..69i57j0i13i512l7j0i13i30l2.9752j1j7&sourceid=chrome&ie=UTF-8

generic methods with example

https://www.google.com/search?q=check+if+string+is+valid+json+webabi+c%23&rlz=1C1RXQR_enIN1016IN1016&sxsrf=ALiCzsbGPwwZAkAwxiue9qOP5J0ZFZU9fQ%3A1666162262959&ei=Vp5PY-CMOsaaseMPoai-4AU&ved=0ahUKEwjgj8mO2uv6AhVGTWwGHSGUD1wQ4dUDCA8&uact=5&oq=check+if+string+is+valid+json+webabi+c%23&gs_lcp=Cgdnd3Mtd2l6EAMyBQgAEKIEMgUIABCiBDIHCAAQHhCiBDoKCAAQRxDWBBCwA0oECE0YAUoECEEYAEoECEYYAFC0BFj2RGDgSmgCcAF4AIABnwKIAY8MkgEFMC41LjOYAQCgAQHIAQjAAQE&sclient=gws-wiz

https://www.google.com/search?q=provide+action+verb+c%23&rlz=1C1RXQR_enIN1016IN1016&sxsrf=ALiCzsapZkev1U4CxHSxsDfZBcV0iFqWRw%3A1666162169916&ei=-Z1PY6bCN6mfseMP982DqA0&ved=0ahUKEwjmopri2ev6AhWpT2wGHffmANUQ4dUDCA8&uact=5&oq=provide+action+verb+c%23&gs_lcp=Cgdnd3Mtd2l6EAMyBQghEKABMgUIIRCgAToKCAAQRxDWBBCwA0oECEEYAEoECEYYAFD-AVjnGmD9IWgCcAF4AYAB4ASIAdQIkgEHMC4zLjUtMZgBAKABAcgBCMABAQ&sclient=gws-wiz

https://www.google.com/search?q=http+request+angular+header&rlz=1C1RXQR_enIN1016IN1016&oq=http+request+angular+header&aqs=chrome..69i57j0i22i30l9.10903j1j7&sourceid=chrome&ie=UTF-8

https://stackoverflow.com/questions/41133705/how-to-correctly-set-http-request-header-in-angular-2

https://www.google.com/search?q=parent+to+child+data+transfer+in+angular&rlz=1C1RXQR_enIN1016IN1016&oq=parent+to&aqs=chrome.1.69i57j0i20i263i512j0i512l8.6322j0j7&sourceid=chrome&ie=UTF-8

https://www.google.com/search?rlz=1C1RXQR_enIN1016IN1016&sxsrf=ALiCzsZ1rDo_cMXDQzP74kAbQmwgPummYw:1666161767774&q=web+organs+angular&spell=1&sa=X&ved=2ahUKEwimuLmi2Ov6AhVoTGwGHR-VAucQBSgAegQIBxAB&biw=1280&bih=569&dpr=1.5

https://www.google.com/search?rlz=1C1RXQR_enIN1016IN1016&sxsrf=ALiCzsZ2c_b9mUp2AjjVpeZ_BAGfEWoaNQ:1666161594154&q=to+navigate+from+admin+to+another+page+typescript&spell=1&sa=X&ved=2ahUKEwiB0dTP1-v6AhXNcGwGHfJfA3kQBSgAegQIBhAB&biw=1280&bih=569&dpr=1.5

https://www.google.com/search?q=initialize+reactive+form+angular&rlz=1C1RXQR_enIN1016IN1016&oq=initialize+rea&aqs=chrome.2.0i512l4j69i57j0i512l5.10054j0j7&sourceid=chrome&ie=UTF-8

https://www.google.com/search?q=subject+vs+behaviorsubject&rlz=1C1RXQR_enIN1016IN1016&oq=subject+&aqs=chrome.2.69i57j0i131i433i512j0i433j0i433i512j0i512j0i20i263i512j0i433i512j69i65.7153j0j7&sourceid=chrome&ie=UTF-8

https://www.google.com/search?q=how+to+pass+data+between+two+independent+components+in+angular&rlz=1C1RXQR_enIN1016IN1016&oq=data+between+two+independent+c&aqs=chrome.1.69i57j0i22i30l2.17941j0j7&sourceid=chrome&ie=UTF-8

https://www.google.com/search?q=%40output+in+angular&rlz=1C1RXQR_enIN1016IN1016&oq=%40output&aqs=chrome.1.69i57j0i512l6j69i65.9822j0j7&sourceid=chrome&ie=UTF-8