11 2017 档案

java get post请求
摘要：package java.API; import java.io.BufferedReader; import java.io.IOException; import java.io.InputStreamReader; import java.io.OutputStreamWriter; import java.io.PrintWriter; import java.net.URL; imp... 阅读全文

posted @ 2017-11-18 11:11 取个名字之麻烦 阅读(321) 评论(0) 推荐(0)

SQL 行转列 列转行
摘要：列转换行 IF OBJECT_ID('tb') IS NOT NULL DROP TABLE tb go CREATE TABLE tb(姓名 VARCHAR(10),语文 INT,数学 INT,物理 INT) INSERT INTO tb VALUES('张三',74,83,93) INSERT INTO tb VALUES('李四',74,84,94) go SELECT * F... 阅读全文

posted @ 2017-11-18 11:05 取个名字之麻烦 阅读(2598) 评论(0) 推荐(0)

SQL随机数
摘要：随机正负50 select (select cast(ceiling(rand(checksum(newid()))*50) as int)+cast(ceiling(rand(checksum(newid()))*50) as int)*-1) as Direction 阅读全文

posted @ 2017-11-15 19:45 取个名字之麻烦 阅读(298) 评论(0) 推荐(0)