表单中对行的操作

select *from qy_baseinfo
select  qyid,qyname from qy_baseinfo
                                          /*显示 表中的2 个列*/  
                                         

select qyid,qyid+' name is:'+qyname as pp from qy_baseinfo

                                          /*比较经典的对表的灵活处理*/

select username,pwd from QY_UserInfo
union
select username,password from Qzz_UserInfo
                                         /*联合2个表的 公用2列 一起显示 出来*/

select *from menu

insert into menu values (6,'哈哈哈哈','eeeee/default.asp')
                                          /*对表里的‘行’进行的插入的操作*/

select *from menu
update menu set url='健康' where menuid='6'

                                           /*对表里的‘行’进行的修改的操作*/
select *from menu
delete from menu where menuid='6'

                                            /*对表里的‘行’进行的删除的操作*/