DOT NET developer blog: May 2021

DECLARE @users TABLE
  (
     UserID    INT,
     [Name]    VARCHAR(100),
     [Role]    VARCHAR(100),
     [Company] VARCHAR(100)
  )

INSERT INTO @users
SELECT u.UserID,
       u.[Name],
       A.B.value('(config/@Role)[1]', 'VARCHAR(100)')    AS [Role],
       A.B.value('(config/@Company)[1]', 'VARCHAR(100)') AS Company
FROM   [User] u
       CROSS APPLY u.details.nodes('/details/detail/department') AS A(B)
WHERE  u.active = 1
       AND A.B.value('(@type)[1]', 'VARCHAR(100)') = 'Internal'
       AND A.B.value('(details/detail/@InOffice)[1]', 'VARCHAR(100)') IS NULL

Scenario:

GIT Hub basics

Solution:

Clone

Navigate to local folder
git clone https://github.com/UserName/Test-Git-Project.git / git@github.com:UserName/Test-Git-Project.git
Open GIT Bash
Navigate to the above folder
Create Document - > touch MyTestdocument.txt
git add MyTestdocument.txt - staged
git status
git commit -m "First commit" //git commit [use -am "message" to add and commit at once]
git push origin
notepad MyTestdocument.txt
git status
git add MyTestdocument.txt -- staged
git status
git commit -m "Second commit"
git log
to exit log type q or z
git add -A [ to add all files at once]

Create Repository/ Organization/ Owners [Admin]/ Collaborators

New Repository

Repository Name
public/private
add readme/gitignore [Csharp]

Organization

Account settings
https://github.com/settings/organizations
Create new organization [name/email]
Create New Repository under Organization

Collaborators

Go to Repository -> settings -> Manage Access
https://github.com/[Organization]/[Repository]/settings/access
Organization -> teams -> new team [what permissions to give on organization]
https://github.com/orgs/Organization/teams

Multiple users on one machine

git config --list
git config credential.username ''
git config --local user.name ""
git config --local user.email "@example.com"
git config --list

DOT NET developer blog

Sql Server - XML conditional checks

Scenario:

Solution:

GIT Hub basics

Scenario:

Solution:

Move Github Sub Repository back to main repo