C# & PHP programmeur richardvandenwinkel

  • portfolio
  • klanten
  • over mij
  • wat ik doe
  • contact
  • Some SQL script i used to detect/remove double entries

    DECLARE @MinID int; DECLARE @MaxID int; DECLARE @ID int; SELECT @MinID = MIN(ProductID) from Product; SELECT @MaxID = MAX(ProductID) from Product; SELECT @ID = ProductID from Product WHERE FK_ProductTypeID=’4′; SELECT TOP 1 Title FROM Product WHERE ProductID < @ID OR @ID=@MinID ORDER BY ProductID DESC; SELECT TOP 1 Title FROM Products WHERE ProductID > @ID [...]

    lees meer »

    Thursday 8 December 2011  |  T-SQL, blog

  • SQL Queries to find double entries

    3 possible SQL Queries to retrieve double entries in a table

    lees meer »

    Saturday 8 May 2010  |  T-SQL

  • T-SQL Split function

    T-SQL Split function

    lees meer »

    Tuesday 4 May 2010  |  T-SQL

  • Dynamic Stored Procedure with Count, Filter & Paging

    Dynamic Stored Procedure with Count, Filter & Paging

    lees meer »

     |  T-SQL, blog

  • SQL Query to drop all FK constraints

    SQL Query to drop all FK constraints

    lees meer »

    Tuesday 14 July 2009  |  T-SQL

  • Use a non-recursive User Defined Function in SQL Server to get all descendants for an element

    Use a non-recursive User Defined Function in SQL Server to get all descendants for an element

    lees meer »

    Thursday 16 April 2009  |  T-SQL

  • Get the inserted ID with Scope_Identity()

    Get the inserted ID with Scope_Identity()

    lees meer »

    Wednesday 10 September 2008  |  C#, T-SQL

  • Get info about columns in a database with SqlDataAdapter.FillSchema

    Get info about columns in a database with SqlDataAdapter.FillSchema

    lees meer »

     |  C#, T-SQL

Zoeken

Categoriën

  • ASP.NET
  • blog
  • C#
  • CSS
  • Javascript
  • JQuery
  • mySQL
  • PHP
  • Portfolio
  • Regular Expressions
  • T-SQL
  • Uncategorized
  • Unix
  • Wordpress

Archief

  • March 2016
  • February 2015
  • July 2014
  • October 2013
  • August 2013
  • January 2012
  • December 2011
  • September 2011
  • July 2011
  • March 2011
  • January 2011
  • November 2010
  • September 2010
  • July 2010
  • May 2010
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • January 2009
  • October 2008
  • September 2008

Laatste notities

  • WordPress – Custom username validation
  • Decompile an .mo into a .po file using POEdit’s msgunfmt.exe
  • Javascript blueprint class for WordPress w. jQuery
  • Some SQL script i used to detect/remove double entries
  • Flash-achtige intro en navigatie met jQuery
  • nl2li – WordPress template tag

Categoriën

  • ASP.NET
  • C#
  • CSS
  • Javascript
  • JQuery
  • mySQL
  • PHP
  • Regular Expressions
  • T-SQL
  • Unix
  • Wordpress
Powered by Wordpress