修改并行度：修改了这个“最大并行度”，如果再没出现 cxpacket应该没问题了参考资料：http://jingyan.baidu.com/article/5d6edee22daf8799eadeeca2.html原文：http://www.cnblogs.com/wdkshy/p/4164804.html
GPS平台、网站建设、软件开发、系统运维，找森大网络科技！https://cnsendnet.taobao.com来自森大科技官方博客http://www.cnsendblog.com/index.php/?p=973 mysql无法外网连接 Host * is not allowed to connect to this MySQL server 在本机登入mysql后，更改"mysql"数据库里的"user"表里的"host"项，从"localhost"改为‘%‘。 代码如下 mysql> mysql>use mysql; mysql>select host from user where user=‘root‘; mysql...
if exists(select name from sysobjects where name = ‘stuInfo‘)drop table stuInfogocreate table stuInfo(stuName varchar(20) not null, --学员名称stuNo char(6) not null, --学号stuSex char(2) not null, --性别stuAge int not null, --年龄stuID numeric(18,0) not null, --身份证号，numeric（18，0）表示18位数字，小数位数为0stuSeat smallint identity(1,1), --座位号：自动编号（标识列），从1开始自增s...
SQLC#tinyint bytesmallint Int16char stringint int 原文：http://www.cnblogs.com/tianhengblogs/p/6322294.html
--3.建立有空间数据的表 create table x (v int not null identity(1,1) primary key,geog geography not null,geogWKT as geog.STAsText() )--4.添加空间数据 insert into x(geog) values(geography::Parse(‘POLYGON((-93.12336.943,-93.12636.953,-94.12936.986,-93.12336.943))‘)), --多边形，开始坐标和结束坐标必须相同,注意polygon中必须包含2层括号，否则报错(geography::Parse(‘POINT(-93.123 36.943)‘)), --点坐...
基本够用，存一下，以后找起来方便 publicabstractclass DB{//数据库连接字符串(config来配置)protectedstaticstring connectionString = ConfigurationManager.AppSettings["connectionString"];public DB(){}#region 公用方法publicstaticint GetMaxID(string FieldName, string TableName){string strsql = "select max(" + FieldName + ")+1 from " + TableName;object obj = GetSingle(strsql);if (obj == null){return1;}els...
C#同步SQL Server数据库Schema1. 先写个sql处理类：using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Text;namespace PinkDatabaseSync {class DBUtility : IDisposable{private string Server;private string Database;private string Uid;private string Password;private string connectionStr;private SqlConnection sqlConn;public void EnsureConnectionIsOp...
I tried to upgrade AX 2012 R3 Retail channel database from CU9 to CU11 for client.after generated new CreateDatabase.dll with upgraded Retail SDK, ran the Channel Configuration Utility, but got error. So I tried the sql queries from CreateDatabase project‘s DatabaseScript.txt in SSMS. store database‘s sql engine is sql server 2008, which does not support sql function ‘CONCAT‘. (It‘s supported...
1.过程： 1>注册驱动器类：Class.forName() 2>连接数据库： String url = "jdbc:sqlserver://localhost:1433;DatabaseName=DataBaseName"; String uername = "dbuser"; String password = "secret"; Connection conn = DriverManager.getConnection(url,username,password); 3>执行sql语句： Statement stat = conn.createStatement(); ...
select * from 表名order by Convert(int,left(列名,charindex(‘.‘,列名+‘.‘)-1)) asc, 列名asc charindex(‘.‘,列名) 查询第一个.（点）在第几位 charindex(‘.‘,列名+‘.‘) 给没有数据在最后面加个.（点） 这样可以让第一位没有小数点的数据也能查出来 left(列名,charindex(‘.‘,列名)) 查询小数点左面值 left(列名,charindex(‘.‘,列名+‘.‘)) 在所有值后面加个. left(列名,charindex(‘.‘,列名+‘....
挂载数据盘#vgdispaly的Total PE安装SQL Server服务端1.下载SQL Server Red Hat Repository配置文件：curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo2.安装SQL Server实例yum install -y mssql-server3.运行mssql-conf setup按照提示配置，选择版本、设置SA密码。/opt/mssql/bin/mssql-conf setup4.验证服务是否正常运行：systemctl status mssql-server5.禁用...
经常用Python写demo来验证方案的可行性，最近遇到了Python访问SqlServer的问题，这里总结下。一、Windows下配置Python访问Sqlserver环境：Windows 7 + Sqlserver 20081、下载并安装pyodbc下载地址:http://code.google.com/p/pyodbc/downloads/list2、访问SqlServer复制代码 代码如下: >>> import pyodbc >>>cnxn = pyodbc.connect(‘DRIVER={SQL Server};SERVER=192.168.1.100\\sql;DATABASE=testDB;UID=sa;PWD=myPassword‘)>>>cu...
Sql Server 基础知识： http://blog.csdn.net/t6786780/article/details/4525652 Sql Server 语句大全： http://www.cnblogs.com/yubinfeng/archive/2010/11/02/1867386.html 原文：http://www.cnblogs.com/mingmingruyuedlut/p/3197377.html
CREATE TABLE tTable(id INT ,f1 VARCHAR(10) ,f2 VARCHAR(10) ,f3 VARCHAR(10)) GO INSERT INTO tTableSELECT 11 ,12 , 13 , 14 INSERT INTO tTableSELECT 13 ,24 ,25,26GOCREATE TABLE tTable2(id INT ,f5 VARCHAR(10) ,f6 VARCHAR(10)) GOCREATE PROC MERGETest ASBEGINMERGE INTO tTable2 T1USING( SELECT id ,f3 ,f2 FROM tTable )T2 ON ( T1.id = T2.id )WHEN MATCHED THEN UPDATE SET T1.f5 = T2.f2 ,T1.f6 = T...
SELECT t.name Tname,p.name Pname,c.name Cname FROM sys.objects T INNER JOIN sys.objects P ON t.object_id=p.parent_object_id AND t.type=‘U‘ AND p.type=‘PK‘INNER JOIN sys.SysColumns C ON c.id=t.object_id INNER JOIN sysindexes i ON i.name=p.nameINNER JOIN sysindexkeys k ON k.id=c.id AND k.colid=c.colid AND k.indid=i.indid select a.name as FieldName, -- 字段名a.isnullable, -- 是否可为空--b.Value a...