sql add months to date

SQL Lunar transformation function (display Chinese format, add run month display) Create a lunar date functionIf object_id (' Fn_getlunar ') is not nullDrop function Fn_getlunarGoCreate function Dbo.fn_getlunar (@solarday datetime)Returns nvarchar (30)AsBeginDECLARE @soldata intDECLARE @offset intDECLARE @ilunar intDECLARE @i intDECLARE @j intDECLARE @ydays intD

Tags: des io ar using strong on data ad EFFirst, Increase: there are 4 ways1. Insert a single line of data using insert:Syntax: Insert [into] Example: INSERT into strdents (name, gender, date of birth) values (' Happy friends ', ' Male ', ' 1980/6/15 ')Note: into can be omitted; Column name values are separated by commas; column values are quoted as single quotes; If you save token, all columns are inserted sequentially 2. Use the Insert SELECT statem

SQL provides two methods for adding new rows to a database relational table, which are single-line INSERT statements and multiple-line INSERT statements. The following is a brief introduction to the functionality and usage of both of these statements. (1) Single-line INSERT statement A single-line INSERT statement is used to add a row of new data to a relational table. The use format is as follows: INSER