摘要：登录mysql mysql -u root -p 或 mysql use mysql; update user set authentication_string=PASSWORD("密码") where user='root'; update user set plugin="mysql_nati 阅读全文

摘要：/* 计算年龄函数*/CREATE FUNCTION DBO.GETAGE( @BIRTHDAY DATETIME, @NOWDAY DATETIME)RETURNS INTASBEGINDECLARE @AGE INT, @YEAR INT, @MONTH INT, @DAY INTSET @AGE = 0SET @YEAR = 0SET @MONTH = 0SET @DAY = 0SET @YEAR = DATEPART(YEAR,@NOWDAY) - DATEPART(YEAR, @BIRTHDAY)SET @MONTH = DATEPART(MONTH,@NOWDAY) - D... 阅读全文