Select stuff("abcdef",2,3,"ghijk") go
结果:aghijk
stuff的功能:删除指定长度的字符串并在指定的起始点插入另一组字符
STUFF ( character_expression , start , length , character_expression )
character_expression :操作的字符,
start:删除和插入的起始点,
length:删除的长度,
character_expression :要插入的字符
SELECT DATEADD(month, 2, OrderDate) FROM MyOrders
通过向指定日期添加间隔,返回新的 datetime 值。
语法
DATEADD (datepart ,number,date )
SELECT OrderID, DATEDIFF (d, OrderDate, ShippedDate) AS "Shipping Time in Days" FROM Orders WHERE CustomerID = 'VINET' 返回跨越两个指定日期的日期和时间边界的数目。 语法 DATEDIFF ( datepart , startdate , enddate )