摘要: 1.INSERT INTO SELECT语句语句形式为:Insert into Table2(field1,field2,...) select value1,value2,... from Table1 要求目标表Table2必须存在,由于目标表Table2已经存在,所以我们除了插入源表Table1的字段外,还可以插入常量。示例如下: 2.SELECT INTO FROM语句语句形式为:SELECT vale1, value2 into Table2 from Table1 要求目标表Table2不存在,因为在插入时会自动创建表Table2,并将Table1中指定字段数据复制到Table2. 阅读全文
posted @ 2012-12-24 17:54 翠儿 阅读(191) 评论(0) 推荐(0) 编辑
摘要: public class AppConstant中 #region 公告分类状态 public static Hashtable StatusHash = new Hashtable { {"0","全部"}, {"1","公司行规"},{"2","职场秘籍"},{"3","生活小提示"},{"4","电视剧场"},{"5","家庭影院"},{"6 阅读全文
posted @ 2012-12-24 10:54 翠儿 阅读(346) 评论(0) 推荐(0) 编辑
摘要: <script type="text/javascript">function getSelectedUsers() { var sltUser = ""; var arrSelect = document.getElementsByName("myCheckBox"); for (i = 0; i < arrSelect.length; i++) { if (arrSelect[i].checked) { sltUser += arrSelect[i].value + ","; i[0]+=1; 阅读全文
posted @ 2012-12-24 10:30 翠儿 阅读(117) 评论(0) 推荐(0) 编辑
摘要: <script type="text/javascript"> function init(){ var lgn = document.getElementById("txtName"); lgn.focus(); }select * from tblUser where userName='' or userName='@userName' userName like '%'+@userName+‘%’ 阅读全文
posted @ 2012-12-24 10:01 翠儿 阅读(82) 评论(0) 推荐(0) 编辑