- 博客(5)
- 资源 (125)
- 收藏
- 关注
转载 经典SQL语句大全
原帖地址 http://www.cnblogs.com/yubinfeng/archive/2010/11/02/1867386.html一、基础1、说明:创建数据库CREATE DATABASE database-name 2、说明:删除数据库drop database dbname3、说明:备份sql server--- 创建 备份数据的 deviceU
2012-05-23 15:15:30 489
转载 C#时间日期操作
一、C# 日期格式DateTime dt = DateTime.Now; dt.ToString();//2005-11-5 13:21:25 dt.ToFileTime().ToString();//127756416859912816 dt.ToFileTimeUtc().ToString();//127756704859912816 dt.ToLocalTime().ToStr...
2012-05-14 09:34:18 821
原创 T-sql
删除约束 ALTER table CUSTOMER_PrintBarCode DROP CONSTRAINT PK__CUSTOMER__3214EC27244031E6修改表结构 alter table CUSTOMER_PrintBarCode alter column id bigint 设置set IDENTITY_INSERT CUSTOMER_Pri
2012-05-10 15:47:59 431
原创 SQLServer跨库查询--分布式查询
用openrowset连接远程SQL或插入数据 --如果只是临时访问,可以直接用openrowset--查询示例select * from openrowset('SQLOLEDB','sql服务器名';'用户名';'密码',数据库名.dbo.表名)--导入示例select * into 表 from openrowset('SQLOLEDB','sql服务
2012-05-10 10:52:28 2386
原创 SQL Server自增长列插入指定值--SET IDENTITY_INSERT ON|OFF
想要将值插入到自动编号(或者说是标识列,IDENTITY)中去,需要设定 SET IDENTITY_INSERT示例:1.首先建立一个有标识列的表:CREATE TABLE products (id int IDENTITY PRIMARY KEY, product varchar(40))2.尝试在表中做以下操作:INSERT INTO products (id,
2012-05-10 10:51:51 1731
ntp_1%3a4.2.8p4+dfsg-3ubuntu5.10_arm64.deb
2020-08-31
ffmpeg 合并文件异常.txt
2020-07-21
opencv_python-3.2.0.8-cp36-cp36m-win_amd64.whl
2020-07-20
opencv_python-3.2.0.7-cp36-cp36m-manylinux1_i686.whl
2020-07-20
opencv_python-3.2.0.7-cp36-cp36m-win_amd64.whl
2020-07-20
opencv_python-3.1.0.4-cp36-cp36m-manylinux1_i686.whl
2020-07-20
opencv_python-3.1.0.0-cp27-cp27m-macosx
2020-07-20
opencv_contrib_python-4.3.0.36-cp36-cp36m-win_amd64.whl
2020-07-20
tracklite-master.zip
2020-05-29
L4T Sources public_sources.tbz2
2020-05-12
libnvinfer-samples_4.1.3-1+cuda9.0_arm64.deb
2020-04-29
Miniconda3-latest-Linux-x86_64.sh
2020-04-20
code-stable-code_1.7.2-1479766213_amd64.tar.gz
2020-04-20
2019海康威视SDK,java/net/C++
2020-01-18
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人