随笔分类 -  SQL

Sql 存储过程 @strSQl 子句的应用
摘要：SELECT * FROM dbo.YHZH --删除外键ALTER TABLE [dbo].[JHFKDMX1] drop FK_YHZH_JHFKDMX1 ALTER TABLE [dbo].[XHSKDMX1] drop FK_YHZH_XHSKDMX1 ALTER TABLE [db... 阅读全文

posted @ 2015-01-19 11:44 @冰糖 阅读(733) 评论(0) 推荐(0)

存储过程插入100 条数据
摘要：create proc ppas declare @n intset @n=1while @n<=100begininsert into student values('11341101320'+LTRIM(@n),'Jack'+ltrim(@n),'男',22,'上海','18272986984... 阅读全文

posted @ 2014-12-29 16:31 @冰糖 阅读(555) 评论(0) 推荐(0)

SQL 查询 之 union ,case ,group
摘要：union alluse myDBSELECT '大于20' as scope,count(*) as 人数FROM student where age>=60union all SELECT '小于20' as scope ,count(*) as 人数FROM student where ag... 阅读全文

posted @ 2014-12-17 16:47 @冰糖 阅读(301) 评论(0) 推荐(0)

SQL 基础1
摘要：1 use myDB; 2 insert into student values('1134110116','Tom','男',22,'上海','18272986984','上海'); 3 insert into student values('1134110117','Tom1','男',... 阅读全文

posted @ 2014-12-11 20:09 @冰糖 阅读(241) 评论(0) 推荐(0)

导航