摘要:
1.字符串截取、字符串转数字 --Server、8.30 select SUBSTRING('SqlServer_2008',4,6) as DB, CONVERT(float,SUBSTRING('8.30~9.00',1,len('8.30~9.00')- CHARINDEX('~',REVER 阅读全文
摘要:
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 阅读全文