Personal learning note from udemy. image tag: From MDN, image tag must have start tag, must not have an end tag. Here is the reason i got from stackoverflow, but i still dont understand it. Thus, the most common way is <img src="smiley.gif" alt="Smiley face" height="42" width="42"/> And we need to add "alt" in case the picture is not displayed. … Continue reading learning image html
Here is the most common selectors for beginners(including me): descendant selector:one more example:one mistake I made before: adjacent selector: if tags ul does not immediately follow tag p:if tags ul is not tag p siblings: attribute selector:one more example: nth of type: child selectorMention: difference between child selector and descendant selector:check this example
create table : CREATE TABLE Project ( ProjectID int NOT NULL IDENTITY(1,1), ProjectName varchar(255) NOT NULL, CreatedDate datetime , Price int, FactoryName varchar(255), Status varchar(255), CustomerName varchar(255), Location varchar(255) ) Add constraints: ALTER TABLE @tablename ADD CONSTRAINT @defaultconstraint_name DEFAULT GETUTCDATE() FOR @columnname same as other constraints Insert data: Insert into project(ProjectName, Price, FactoryName, Status, CustomerName, Location) … Continue reading SQL basic command
Briefly, how to get default constraint name: -- returns name of a column's default value constraint SELECT default_constraints.name FROM sys.all_columns INNER JOIN sys.tables ON all_columns.object_id = tables.object_id INNER JOIN sys.schemas ON tables.schema_id = schemas.schema_id INNER JOIN sys.default_constraints ON all_columns.default_object_id = default_constraints.object_id WHERE schemas.name = 'dbo' AND tables.name = 'tablename' AND all_columns.name = 'columnname' This answer … Continue reading SQL default constraint problem
This week, I got a task to write swagger document, at the beginning, I thought it wasn't hard. But.... after I got stuck for a few days, now i got my first swagger working in azure. My swagger not perfect, but good enough ! I am using NodeJS as environment, main package is swagger. Notice … Continue reading write swagger in Node js locally and deploy it to Azure
This one question follows me all the time, when I config my web app and API. Note: I have a client app and a server API in Azure. In the following picture, it showed that I was in my client side web app. And I want to consent to access my API (todolist2) as a … Continue reading Delegated Permission ?!
I have one Node.js API which connected to database in Azure. Now I want to deploy it into Azure. The easiest way is : open your portal of azure. Click "New", then create "Web App". Type your app name, and create ResourceGroup if you don't have. You also can choose App service location. I suggest … Continue reading My first experience of deploying API on Azure
I am weak in this Routing path. Here is some basic note for what I have learned. I don't think it is hard to understand, so I won't explain one by one. However, the important tip is ' * ', Unless those paths what I have, if clients input other paths or routes, page will … Continue reading Routing in Express