SQL
Daniel799
DXC.technology
展开
-
SQL SERVER 修改字段长度
Syntax:ALTER TABLE tableName ALTER COLUMN columnName nvarchar(max)原创 2019-07-04 10:01:38 · 16530 阅读 · 0 评论 -
SQLServer Job的创建
General:设置正确的Owner 一般设置为系统管理员账号Steps:填写步骤名称选择步骤类型为Operating system(CmdExec),该类型可以设置路径运行exe程序。在Command框中复制执行路径。在Advanced中选择Quit the job reporting sucess.Quit the job reporting failure.Schedules:...原创 2019-03-01 15:58:13 · 1321 阅读 · 0 评论 -
SQL Server 解决本地账户无法登陆
出现 error:40-Could not open a connenction to SQL Server.这种情况需要开启 SQL Server service.开启方法:Sql Server Configuration Manager--->SQL Service--->SQL Server(MSSQLSERVER)--->Star如果Star失败。则需要打开系...原创 2019-01-12 21:44:45 · 4886 阅读 · 0 评论 -
Dynamics CRM SQL 实体ObjectTypeCode查询&表单共享用户的查询
1.实体ObjectTypeCode查询SELECT [ObjectTypeCode] FROM Entity WITH(NOLOCK) WHERE name='EntityName'2.表单共享用户的查询 --PrinciplId是SystemUserIdSELECT PrincipalId,PrincipalTypeCode,AccessRightsMaskFROM Pr...原创 2018-12-13 15:51:20 · 864 阅读 · 0 评论 -
Dynamics CRM SQL查询OptionSet字段对应的文本
SELECT Value FROM StringMap WHERE AttributeName='字段名称' and LangId=2052 and--语言 1033为英文ObjectTypeCode=(SELECT [ObjectTypeCode] FROM Entity WITH(NOLOCK) WHERE name='实体名称') ...原创 2018-11-28 11:28:53 · 816 阅读 · 0 评论 -
SQL Trigger 创建按照当日日期的递增表单号
表单编号:C+yyyyMMdd+编号(001开始递增)如:C20181118001USE [数据库]GO/****** Object: Trigger [dbo].[表名] Script Date: 2018/11/21 14:55:31 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =========...原创 2018-11-21 15:04:34 · 363 阅读 · 0 评论 -
SQL 创建视图访问其他数据库 & 不同数据库表格的关联查询
我们访问其它 SQL Server的数据库,我们可以通过 OPENDATASOURCE (SQL Server 2000 以上版本支持) 来完成。1.创建视图的方式访问数据库Create VIEW [dbo].[vTableName]ASSelect * FROM OPENDATASOURCE( 'SQLOLEDB', 'PWD=loginPasswor...转载 2018-09-06 16:13:13 · 7564 阅读 · 0 评论 -
SQL Union & Intersection Introduction
UnionThe union is an operation that combines elements of two sets.The resulting union set will be a set consisting of all of these elements repeated exactly once, that is, no duplicates are allowed....原创 2018-09-06 15:10:13 · 398 阅读 · 0 评论 -
SQL Join Introduction
Inner JoinThe kind of joins where all rows that don't match the join condition exactly are eliminated are called inner joins.Outer JoinIn this kind of join, the resultset consists of rows that m...原创 2018-09-06 14:42:18 · 92 阅读 · 0 评论 -
SQL 数据库操作Utility
using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using System.Collections;using System.Xml;using System;namespace Utility{ /// 此类为抽象类, ...原创 2018-09-19 14:41:30 · 473 阅读 · 0 评论 -
Dynamics CRM SQL实体字段查询
--查询实体select * from Entity where name = 'new_priceevaluation'--查询Attribute 信息select top(100) a.name as 字段名,b.label as 显示名,c.description as 类型, b.ObjectColumnName as 方式, * from attribute a join ...原创 2018-08-30 13:31:57 · 1546 阅读 · 0 评论 -
SQL OVER() Partition By Order By
--Partition by 作用是分组,没有进行聚合,返回多条记录。 order by 是排序--写法 函数名 +over(partition by)别名--写法 函数名 +over(order by)别名--写法 函数名 +over(partition by 列名 order by 列名)别名Declare @tbl1 table(n...原创 2018-08-30 17:44:22 · 9026 阅读 · 0 评论