Clipmarks - Tsql Clipmarks

0
POPS Linq Exception - Update without primary key

by robertdondo 8-13-2009

I was getting this error because I have a table without a primary key in the db, but need key in linqdatasrc. Sln was to set Auto-Sync to OnInsert as described in this clip.

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.