Monthly Archives: August 2008

Simple Cursor

  Thank you http://cgaskell.wordpress.com/2006/12/06/sql-tsql-cursor-syntax-a-quick-reference/   DECLARE @price moneyDECLARE @get_price CURSOR SET @get_price = CURSOR FOR     SELECT price FROM titles OPEN @get_price FETCH NEXT FROM @get_price INTO @price WHILE (@@FETCH_STATUS = 0) BEGIN     IF @Price < 20 SELECT ‘Under 20′     ELSE SELECT @Price      FETCH … Continue reading

Posted in Uncategorized | Leave a comment

Great .NET cheat sheets

http://john-sheehan.com/blog/index.php/net-cheat-sheets/

Posted in Uncategorized | Leave a comment

Nice and easy aspx popup error

Response.Write("<script language=\"javascript\"> alert(‘This is an error’); window.open( \"page name\",\"window name\");</script>");Response.Flush();

Posted in Software Development | Leave a comment

sproc header text

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N‘sproc_name’) AND OBJECTPROPERTY(id, N‘IsProcedure’) = 1) DROP PROCEDURE  sproc_name GO CREATE PROCEDURE  sproc_name … 

Posted in Uncategorized | Leave a comment