blacop的博客

---求平均工资SELECT AVG(sal) FROM emp;-----------大于平均工资SELECT e.ename,e.job,e.salFROM emp eWHERE e.sal>(SELECT AVG(sal) FROM emp)----------e领导编号=m雇员编号--emp雇员表，dept部门表SELECT e.ename 雇员姓名,e.job 雇员职位,

using System;using System.Collections.Generic;using System.Data.SqlClient;using System.IO;using System.Linq;using System.Text;using System.Threading.Tasks;namespace _02SQLHelperC{ class Prog

using System;using System.Collections.Generic;using System.Configuration;using System.Data;using System.Data.SqlClient;using System.Linq;using System.Text;using System.Threading.Tasks;namespace

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Configuration;using System.Data.SqlClient;namespace _04封装SQL访问方法{ public class SqlHelper {

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.IO;namespace _03导入数据{ class Program { static void Main(

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.IO;namespace _02导出数据{ class Program { static void Main(

using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace _03大项目{ public class DeskInfo { //DeskId, DeskName, DeskNamePinYin, DeskDelFlag, DeskNum

create table DeskInfo(DeskId int primary key not null identity (1,1),DeskName varchar(20) ,DeskNamePinYin varchar(20),DeskDelFlag int,DeskNum int) select DeskId,DeskName,DeskNamePinYin,DeskNum

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data

Helper