摘要:
using System; using System.Collections.Generic; using System.ComponentModel; using System.Diagnostics; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace 阅读全文
摘要:
1.字符串截取方法 --5SELECT INSTR('8.30~9.00', '~') FROM dual; --8.30SELECT SUBSTR ('8.30~9.00', 0, INSTR ('8.30~9.00', '~',1,1)-1) AS time FROM dual;--18.30S 阅读全文
摘要:
select Name '姓名',Age '年龄',(select LessonName + ',' from Lesson where StudentId=s1.Id FOR XML PATH('')) '课程名称' from Student s1 创建触发器(插入)create trigger 阅读全文