stableboy的Blog

select   *   from   openrowset(sqloledb     ,Trusted_Connection=yes     ,exec   aa..test) 

https://docs.microsoft.com/zh-cn/sql/relational-databases/scripting/add-transact-sql-snippets?view=sql-server-2017 适用对象：SQL ServerAzure SQL 数据库Azure SQL 数据仓库并行数据仓库您可以将自己的 Transact-SQL 代码段添加到在 SQ...

Data Source = myServerAddress;Initial Catalog = myDataBase;Integrated Security = SSPI;

https://blog.csdn.net/kpchen_0508/article/details/45167481可以搜索通配符字符。有两种方法可指定平常用作通配符的字符：使用 ESCAPE 关键字定义转义符。在模式中，当转义符置于通配符之前时，该通配符就解释为普通字符。例如，要搜索在任意位置包含字符串 5% 的字符串，请使用： WHERE ColumnA L

http://www.itpub.net/forum.php?mod=viewthread&tid=1780983&ordertype=1用Rtrim()select * from OPENQUERY(MYSQLAPP,'select rtrim(char_col),........  from uc.test');或者DBCC TRACEON (8765) WITH NO_INF...

http://www.w3school.com.cn/sql/sql_wildcards.asp通配符描述%替代一个或多个字符_仅替代一个字符[charlist]字符列中的任何单一字符[^charlist]或者[!charlist]不在

SQL Server取datetime的日期部分http://www.cnblogs.com/edong/archive/2016/11/18/6077922.htmlselect convert(date,getdate())

解压版：\data\main_menu.xml例如，修改执行 = F5                  com.mysql.wb.menu.query          Execute (All or Selection)           query.execute           builtin:query.execute

http://blog.csdn.net/lianchangshuai/article/details/6537737SQL中判断字符串中包含字符的方法通过2个函数CHARINDEX和PATINDEX以及通配符的灵活使用函数：CHARINDEX和PATINDEXCHARINDEX：查某字符(串)是否包含在其他字符串中，返回字符串中指定表达式的起始位置。PAT

USE AdventureWorks;GO--Creates an infinite loopWITH cte (EmployeeID, ManagerID, Title) as( SELECT EmployeeID, ManagerID, Title FROM HumanResources.Employee WHERE ManagerID IS NOT NULL

https://www.cnblogs.com/lykbk/p/343432434dsfsdfddferre334343434343.html   1 -- create function 2 create function [dbo].[fnXmlToJson] (@XmlData xml) 3 returns nvarchar(max) 4 as 5 begin 6 ...