Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Keep up to date - daily newsletter:
Sign up
Articles with tag
T-SQL
Search for
any
content tagged
t-sql
<< Newer
Items 41 to 60 of 1305
Older >>
The OUTPUT Clause for INSERT & DELETE Statements
In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements.
Read more...
By
Amarendra Reddy Thummeti
2017/05/25
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
4,545 reads
Forecasting with SQL
Can you use SQL Server to extrapolate out trends from your data? Lots of companies would have you buy a BI solution instead, but new author Mark Wojciechowicz brings us a great example of how you could forecast something in T-SQL.
Read more...
By
Mark Wojciechowicz
2017/05/19 (first published: 2010/02/09)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
17,148 reads
Some of my greatest mistakes
You are never too experienced to make mistakes. An occasional dose of humble pie serves as a reminder to up our game.
Read more...
By
David Poole
2017/05/18
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,842 reads
OUTPUT Clause Basics (For Inserts and Deletes)
When INSERTING or DELETING rows from a table, the OUTPUT clause can be used to return a dataset containing the changes made. Mat Richardson explains how.
Read more...
By
Mat Richardson
2017/05/02
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,074 reads
Should I Type * or 1 With the EXISTS Logical Operator
In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" and even "TOP 1 1" or "TOP 1 *". The aim of this article to give a good explanation which option is the best.
Read more...
By
Viacheslav Maliutin
2017/04/24
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
3,343 reads
Nuance of datetime data type in SQL Server
One of the most confusing data types in SQL Server is the datetime datatype.
Read more...
By
Leo Peysakhovich
2017/04/13
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,938 reads
Performaing a Right and Comprehensive Age Calculation Part 2
Age Calculation gets implemented as an Inline table Valued function with a parameter defining which date parts must be counted.
Read more...
By
Sergiy Floka
2017/03/30
|
Source:
SQLServerCentral.com
|
Category:
age calculation
Rating:
|
Discuss
|
Briefcase
|
952 reads
Performing a Right and Comprehensive Age Calculation
Age calculation based on the right method used in real life.
Read more...
By
Sergiy Floka
2017/03/28
|
Source:
SQLServerCentral.com
|
Category:
datetime conversions
Rating:
|
Discuss
|
Briefcase
|
1,780 reads
Adding Years, Months and Days
Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation.
Read more...
By
Pete Revell
2017/03/14
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,257 reads
Detective Stories - Tracking Down the Database's Dependents Part 2
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.
Read more...
By
Brandie Tarvin
2017/03/07
|
Source:
SQLServerCentral.com
|
Category:
database dependencies
Rating:
|
Discuss
|
Briefcase
|
962 reads
Detective Stories - Tracking Down the Database's Dependents Part I
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article.
Read more...
By
Brandie Tarvin
2017/03/06
|
Source:
SQLServerCentral.com
|
Category:
database dependencies
Rating:
|
Discuss
|
Briefcase
|
1,250 reads
Using EXCEPT to Determine Row Differences
How to use the EXCEPT statement to perform row differences.
Read more...
By
M. Douglas Bowan II
2017/02/17 (first published: 2014/03/25)
|
Source:
SQLServerCentral.com
|
Category:
except
Rating:
|
Discuss
|
Briefcase
|
33,908 reads
Lists With, or Without, Ranges in both T-SQL and PowerShell
Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them.
Read more...
By
Additional Articles
2017/02/16
|
Source:
SimpleTalk
|
Category:
powershell
Rating:
Rate this
|
Briefcase
|
4,747 reads
Wildcard Searches
Using wildcard to find patterns in strings going from the basics to some more complicated conditions.
Read more...
By
Luis Cazares
2017/02/10 (first published: 2015/09/29)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
13,127 reads
Query Performance Tuning – A Methodical Approach
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
Read more...
By
Gail Shaw
2017/02/10 (first published: 2015/06/08)
|
Source:
SQLServerCentral.com
|
Category:
performance and tuning
Rating:
|
Discuss
|
Briefcase
|
15,847 reads
Performance of the SQL MERGE vs. INSERT/UPDATE
The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?
Read more...
By
Dwain Camps
2017/02/03 (first published: 2013/10/28)
|
Source:
SQLServerCentral.com
|
Category:
merge
Rating:
|
Discuss
|
Briefcase
|
37,233 reads
The Elusive Conditional WHERE Clause
What's this, a conditional WHERE clause that doesn't use dynamic SQL?
Read more...
By
John Hick
2017/01/27 (first published: 2013/04/18)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
37,446 reads
Simpson's Paradox
This article is a case study and an attempt to explain an interesting phenomenon with data anomalies that is commonly called Simpson's Paradox.
Read more...
By
Mala Mahadevan
2017/01/10
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
3,319 reads
Using Mod to Generate Work Shifts
A short story on using the mod function to a shifting query.
Read more...
By
Joe McGovern
2016/12/22
|
Source:
SQLServerCentral.com
|
Category:
mod
Rating:
|
Discuss
|
Briefcase
|
1,394 reads
How to Capture Deleted Records
This article shows a few techniques that help in capturing deleted records.
Read more...
By
Darko Martinovic
2016/12/19
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,449 reads
<< Newer
Items 41 to 60 of 1305
Older >>
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.