NodeJs,AngularJs,Sql Server,WebApi

SSH ket set up Using GitBash  1. git config --list 2. git config --global user.name "John Doe" 3. git config --global user.email johndoe@example.com 4. ssh-keygen -t ed25519 -C "your_email@example.com" 5. clip < ~/.ssh/id_ed25519.pub 6. enterpassword for ubantu --  the private key identities to the authentication agent like so: ssh-add Then you can  ssh  into your server. in addition, you can see the list of fingerprints of all identities currently added by: ssh-add -l after that set SSH key git lab-> profile ->setting ->> ssh key-key-> paste key Now open git bash and clone the repository and enter password The complete guide to SSH keys in GitLab - Spectral (spectralops.io) Clone a branch git clone -b <branchname> <remote-repo-url> Git global setup git config --global user.name "G Gurmangat" git config --global user.email "" Create a new repository git clone git@gitlab. cd rihms touch README.md gi

Transaction and Exception handling do $$   declare  id numeric := 0; begin Query1 ;   Query2;    id:=1;   exception           when others then                 raise notice 'ERROR % %' ,sqlstate, id;       rollBACK; COMMIT; end; $$  language 'plpgsql'; Use JSON Data as parameter  and get using table "Role" table has two columns ---  -- FUNCTION: public."Get_JSON_TO_TABLE"(json) --select * from "Get_JSON_TO_TABLE"('{"RoleName":"Test","Description":"test desc"}') -- DROP FUNCTION public."Get_JSON_TO_TABLE"(json); /* select * from "Get_JSON_TO_TABLE"('{"RoleName":"Test","Description":"test desc"}') */ CREATE OR REPLACE FUNCTION public."Get_JSON_TO_TABLE"( jsondata json)     RETURNS Table("RoleNam" character varying,"Descripti" character varying)     LANGUAGE 'plpgsql'     AS $BODY$      

React js Host ON IIS-- https://dev.to/sumitkharche/how-to-deploy-react-application-on-iis-server-1ied 1. Installed IIS Node -https://github.com/azure/iisnode/wiki/iisnode-releases https://github.com/tjanczuk/iisnode/releases iisnode-core-v0.2.21-x64 https://sourceforge.net/projects/iisnode.mirror/ 2. Install URL Rewrite --https://www.iis.net/downloads/microsoft/url-rewrite 3. Install Application Request Routing extension. https://www.iis.net/downloads/microsoft/application-request-routing 4, add web.config https://stackoverflow.com/questions/36351431/iisnode-on-windows-7-iis-7-5-throwing-500-19-error https://harveywilliams.net/blog/installing-iisnode For More information:https://dev.to/petereysermans/hosting-a-node-js-application-on-windows-with-iis-as-reverse-proxy-397b