T-SQL
文章平均质量分 55
hery2002
这个作者很懒,什么都没留下…
展开
-
[转贴]How do I find a stored procedure containing ?
http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.htmlI see this question at least once a week. Usually, people are trying to find all the stored procedures that转载 2008-03-28 21:33:00 · 870 阅读 · 0 评论 -
T-SQL:zz检查文件夹下的文件大小
原文:Check Up Size Of Each Folder In a Path,版权归原作者. 贴过来备用:USE [DB_Maint]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF OBJECT_ID(N'[dbo].[usp_Folder_Size_Check]') IS NOT NULLBEGIN DROP PROCEDUR转载 2015-06-11 20:38:11 · 550 阅读 · 0 评论 -
T-SQL:[zz]SQL Server NOLOCK Hint & other poor ideas.
今天逛论坛看到问NOLOCK的问题,搜到MSDN上有一篇比较好的文章,转载到这里。留爪! SQL Server NOLOCK Hint & other poor ideas转载 2015-05-29 21:03:08 · 509 阅读 · 0 评论 -
学习SQL Server推荐的10本书
今天在sqlmag上闲逛,看到了这篇一年前写的文章,正好在看其中的一本,推荐给大家。原文地址:Top 10 Highly Recommended SQL Server Books.转载 2015-04-17 23:28:32 · 19856 阅读 · 3 评论 -
T-SQL:取最值的几种方式的简单比较.
通常情况下,都会遇到取最值的情况,T-SQL提供了多种方式实现最值比较,简单罗列几种。 1. NOT EXISTSUSE [AdventureWorks2012];GODBCC FREEPROCCACHE;GOSET STATISTICS PROFILE ON;SET STATISTICS IO ON;SET STATISTICS TIME ON;SELECT DISTINCT原创 2015-04-19 01:13:11 · 651 阅读 · 0 评论 -
T-SQL: JOIN的几种关系
SQL Server提供了多种JOIN机制,在联机丛书FROM (Transact-SQL)中列举了四种JOIN操作.1.INNER JOIN(交集) INNER JOIN在数学上是指两个集合的交集,数学符号∩。如下图所示,图中红色部分则为INNER JOIN的结果。 例如: {1, 2} ∩ {1, 2} = {1, 2}. {1, 2} ∩ {2,原创 2015-04-23 00:31:25 · 1063 阅读 · 0 评论 -
T-SQL:提取第一次出现的数字组合
问题:提取任意字符串中第一次出现的数字组合。USE [AdventureWorks2012];GODECLARE @t_TB TABLE( ColVal VARCHAR(20));INSERT INTO @t_TB VALUES ('ABC123'), ('ENA329'), ('EEE22W33'), ('F1W2C3E8'), ('DDDDDDD'原创 2015-04-19 00:32:33 · 543 阅读 · 0 评论 -
To SP or not to SP in SQL Server: an argument for stored procedures
http://www.simple-talk.com/sql/t-sql-programming/to-sp-or-not-to-sp-in-sql-server-an-argument-for-stored-procedures/The database-as-API approachBy Adam MachanicThis article is adapted from Ada转载 2008-04-09 21:10:00 · 890 阅读 · 0 评论 -
Find Nth maximum value in SQL Server
http://www.sqlteam.com/article/find-nth-maximum-value-in-sql-serverBy Guest Authors on 11 April 2004 | 13 Comments | Tags: SELECT This aritlce is written by Hariharan Velayuthan. He writes转载 2008-04-10 21:52:00 · 1577 阅读 · 2 评论 -
How to check Fragmentation on SQL Server 2005
http://blogs.msdn.com/jorgepc/archive/2007/12/09/how-to-check-fragmentation-on-sql-server-2005.aspxAuthor: jorgepc I have been asked this question several times: Is there a tool in SQL Server whe转载 2008-04-09 21:07:00 · 1579 阅读 · 0 评论 -
SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained
http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspxSQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explainedThe dust has n转载 2008-04-02 10:32:00 · 2396 阅读 · 2 评论 -
Stored procedures: Find columns and tables
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1109458,00.htmlthe author: Brian Walker is a senior database architect in an IS department that uses SQL Server 2000 and the .NET Framewor转载 2008-03-28 21:55:00 · 835 阅读 · 0 评论 -
T-SQL: GROUP BY
GROUP BY的用法:GROUP BY (Transact-SQL) -- Declare Table variable.. DECLARE @tbA TABLE ( ID INT NOT NULL IDENTITY(1,1) ,原创 2015-05-26 11:42:29 · 1079 阅读 · 0 评论