随笔分类 -  数据库

摘要:delimiter &&create PROCEDURE findProjectDetailsByProjectId(in p_userId int)BEGIN DECLARE done INT DEFAULT 0; DECLARE d_projectId int; DECLARE projectL 阅读全文
posted @ 2017-05-04 10:58 君哥~ 阅读(139) 评论(0) 推荐(0)
摘要:create PROCEDURE total_mySaleDuty as BEGIN DECLARE @a int,@error int DECLARE @b int,@errorb int DECLARE @c_dutyId int; DECLARE @c_dutyName VARCHAR(100); DECLARE @c_proxyCount int; ... 阅读全文
posted @ 2017-05-04 10:57 君哥~ 阅读(183) 评论(0) 推荐(0)
摘要:Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AMSelect CONVERT(varchar(100), GETDATE(), 1): 05/16/06Select CONVERT(varchar(100), GETDATE 阅读全文
posted @ 2017-05-04 10:56 君哥~ 阅读(141) 评论(0) 推荐(0)