Clipmarks - Tsql Clipmarks

0
POPS TSQL Challenge 31 - Managing multiple overlapping date intervals.

by jacobsebastian 6-3-2010

Very interesting challenge to test your TSQL skills

0
POPS Crosstab Pivot-table Workbench

by travislaborde 3-19-2008

Great article, but WAY more TSQL than I ever want to write :)

0
POPS Deleting a column DEFAULT value

by ntziolis 3-7-2008

Nice TSQL script to delete the default value constraint when you dont know the name.

0
POPS Strip leading zeros from a string.

by Osolage 8-6-2007

No Remarks

0
POPS TSQL Count(*) in select with no grouping...

by rbaird 4-12-2007

I have to admit I don't understand it, but using COUNT(*) OVER(PARTITION BY 1) AS theCount you can put a total record count in the select statement. Izaniiice...

0
POPS TSQL Cursor Example

by rbaird 2-5-2007

Quick sample of cursor declaration and use in TSQL

0
POPS Update a Sequential Field with a Single Statement

by grefly 12-5-2006

No Remarks

0
POPS TSQL Date Functions

by rbaird 12-2-2006

Few nice examples of how to calculate some significant days in TSQL.

1
POPS TSQL Linear Regression

by rbaird 11-13-2006

Potential answer on how to calculate a linear regression utilizing standard TSQL.

0
POPS TSQL While Loops

by rbaird 11-7-2006

Good example of while loops in tsql with continue and break keywords defined and explained.

0
POPS scope_identity() vs. @@Identity

by fmcypriano 6-27-2006

No Remarks

0
POPS SQL Order Example

by Xtraeme 6-19-2006

No Remarks

— end of the list —

Search Results

Tsql

Search Options