Sqlserver
lucy_liu2014
成长不止,善良依旧
展开
-
NULL FIRST
----CREATE TABLE TEST DROP TABLE test; create table test (id int,name char(10),score char(10)) ----INSERT INTO TEST INSERT INTO test VALUES (1,'LILY',90); INSERT INTO test VALUES (2,'LUCY',91); IN...原创 2017-10-13 22:06:18 · 320 阅读 · 0 评论 -
查询主管及所有员工
DECLARE @ParentID int =2, @Level int = 3 ;WITH CTE AS ( SELECT 0 LEVEL, T.EMPLOYEE,T.SUPERVISOR FROM STAFF T WHERE T.EMPLOYEE =@ParentID UNION ALL SELECT B.LEVEL+1,A.EMPLOYEE,A.SUPERVISOR ...原创 2017-10-13 22:05:04 · 456 阅读 · 0 评论 -
排名函数
drop table t; create table t (stuid varchar(10), classname varchar(50), score int); insert into t values ('A0001','cn',60); insert into t values ('...原创 2017-10-13 22:03:46 · 234 阅读 · 0 评论 -
sqlserver 序列
DROP TABLE #T CREATE TABLE #T (K1 SMALLDATETIME, C1 INT) INSERT #T (K1,C1) VALUES('19990901',28) INSERT #T (K1,C1) VALUES('19991001',25) INSERT #T (K1,C1) VALUES('19991101',13) INSERT #T (K1,C1) V...原创 2017-10-13 22:02:43 · 1073 阅读 · 0 评论