Alex_Kuznetsov - All Comments

Remove All Non-Numeric Characters From A String « Strate SQL

Remove All Non-Numeric Characters From A String « Strate SQL — Mon, 23 Nov 2009 09:37:48 GMT

Pingback from Remove All Non-Numeric Characters From A String « Strate SQL

Select * question | keyongtech

Select * question | keyongtech — Thu, 22 Jan 2009 01:07:56 GMT

Pingback from Select * question | keyongtech

Split function | keyongtech

Split function | keyongtech — Sun, 18 Jan 2009 17:31:09 GMT

Pingback from Split function | keyongtech

Calculating cumulative product from previous row (without using cursors) - Page 2 | keyongtech

Sun, 18 Jan 2009 17:21:06 GMT

Pingback from Calculating cumulative product from previous row (without using cursors) - Page 2 | keyongtech

Help with unique contraint | keyongtech

Help with unique contraint | keyongtech — Sun, 18 Jan 2009 16:52:46 GMT

Pingback from Help with unique contraint | keyongtech

re: Using a Foreign key constraint to check validity of History Windows (Start - End Date Windows)

Razvan Socol — Thu, 18 Dec 2008 14:52:05 GMT

We also need a constraint to check that StartedAt<=FinishedAt.

Remove All Non-Numeric Characters From A String

Strate SQL — Thu, 18 Sep 2008 18:54:12 GMT

I completely lack creativity today but thought this link on removing non-numeric characters was kind

re: Remove all non-numeric characters from a string.

Alex_Kuznetsov — Tue, 26 Feb 2008 16:09:33 GMT

I think Simon's solution is better:

http://sqlblogcasts.com/blogs/simons/archive/2008/02/26/String-cleaning-with-TSQL.aspx

re: Remove all non-numeric characters from a string.

Madhivanan — Mon, 25 Feb 2008 08:14:48 GMT

Other similar method

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/12/18/extract-only-numbers-from-a-string.aspx

re: Vote for TOP(@n) OVER(PARTITION BY ... ORDER BY ...) syntax

Alex_Kuznetsov — Sat, 23 Feb 2008 21:30:40 GMT

Adam,

A duplicate indeed. Note that because all the details of Itzik's suggestion were in an attached document, the search did not bring it up for me.

re: Vote for TOP(@n) OVER(PARTITION BY ... ORDER BY ...) syntax

AdamMachanic — Sat, 23 Feb 2008 20:38:22 GMT

This is a duplicate of the following item:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=254390

re: Vote for TOP(@n) OVER(PARTITION BY ... ORDER BY ...) syntax

jamiet — Sat, 23 Feb 2008 18:55:47 GMT

Great idea Alex. I voted 4 and added it to my watch list!!

-Jamie

re: Using a Foreign key constraint to check validity of History Windows (Start - End Date Windows)

AdamMachanic — Thu, 07 Feb 2008 22:20:28 GMT

Clever! I like it!

re: List of tables without primary keys

Uri Dimant — Thu, 07 Feb 2008 05:46:29 GMT

http://dimantdatabasesolutions.blogspot.com/2007/11/tables-that-do-not-have-primary-key.html

re: When It Is OK to Use SELECT * in Production Code.

Madhivanan — Thu, 13 Dec 2007 08:50:41 GMT

Other case to use SELECT * is when checking for existance of the data

IF EXISTS(SELECT * FROM.........)

BEGIN

-- do some stuff here

END