星空网 > 软件开发 > 操作系统

SQLSERVER基础语句(一)

1、插入一行数据:
INSERT INTO 表名(列名)VALUES(对应的值);
2、一次性插入多条数据
先建表:
INSERT INTO 新建表名(列表)SELECT 原始表列名 FROM 原始表;
执行时创建表:
SELECT 表名.列名 INTO 新建表名 FROM 原始表;
新建标识列:
SELECT Grade.GradeldName,IDENTITY(int,1,1)as GradeId into AddressList5 From Grade;
更新一行数据:
UPDATE Grade SET GradeldName='123' WHERE GradeldName='oop';
更新全部数据:
UPDATE Grade SET GradeldName='123';
删除数据:
DELETE FROM Grade WHERE GradeId = '1';
DELETE FROM Grade WHERE GradeId='2';
删除表(不建议使用,数据无法恢复):
TRUNCATE TABLE 表名;
TRUNCATE TABLE AddressList;

查询语句:
SELECT GradeId FROM AddressList1 WHERE GradeldName='123' ;
查询除了‘123’的所有数据:
SELECT GradeldName FROM AddressList1 WHERE GradeldName<>'123';

合并列:
SELECT NAME=GradeldName+'.'+GradeId FROM AddressList5;

查询空值:
SELECT NAME FROM TABLE WHERE EMAIL IS NULL;
SELECT GradeId FROM AddressList1 WHERE GradeldName IS NULL;

查询并添加一行常量默认值学校名称:
SELECT GRADENAME='123','OBTK' AS SCHOOLNAME;
SELECT GradeldName = 'OOP','T153' AS SCHOOLNAME;

排序:
查多少行的排序:
例:查ID小于3的;
SELECT GradeldName AS '年级'  FROM AddressList1 WHERE GradeId<3 ORDER BY GradeId ;;
1、按照列排序
SELECT GradeldName AS '年级' FROM AddressList1  ORDER BY GradeId ;
SELECT GradeldName  AS '年级' ,'T153' AS '学校名称' FROM AddressList1 ORDER BY GradeldName;
2、列升序:
SELECT GradeldName AS '年级' FROM AddressList1  ORDER BY GradeId ASC ;
SELECT GradeldName  AS '年级' ,'T153' AS '学校名称' FROM AddressList1 ORDER BY GradeldName ASC;
3、列降序:
SELECT GradeldName AS '年级' FROM AddressList1  ORDER BY GradeId DESC;

SELECT GradeldName  AS '年级' ,'T153' AS '学校名称' FROM AddressList1 ORDER BY GradeldName DESC;




原标题:SQLSERVER基础语句(一)

关键词:sql

sql
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

国际美国快递到:https://www.goluckyvip.com/tag/100929.html
进度条:https://www.goluckyvip.com/tag/10093.html
到美国国际快递:https://www.goluckyvip.com/tag/100930.html
东泽国际货运:https://www.goluckyvip.com/tag/100931.html
百运网国际物流:https://www.goluckyvip.com/tag/100932.html
德易国际物流:https://www.goluckyvip.com/tag/100933.html
TikTok斥资210万美元游说美国参议院阻止法案通过 :https://www.goluckyvip.com/news/188220.html
北京飞机票查询(快速查询北京至各地机票价格和航班信息):https://www.vstour.cn/a/366178.html
相关文章
我的浏览记录
最新相关资讯
海外公司注册 | 跨境电商服务平台 | 深圳旅行社 | 东南亚物流