Browse by Tags

• logging
• sqL Server 2000
• SQL Server 2005
• Teaser
• Tips and Tricks

• How to log when a function is called?

  This question came up today and here is one way of doing it. It requires running xp_cmdshell so this is probably not such a good idea. The problem with functions is that you cannot just insert into any table. INSERT, UPDATE, and DELETE statements modifying Read More... Posted Thursday, May 08, 2008 2:25 PM by Denis Gobo | 3 Comments Filed under: Functions, logging, Tips and Tricks

• Functions That Are Not Often Used: SIGN

  SIGN is one of those function which you almost never see used in code. Sometimes you are asked by the front-end/middle-tier developers to return a rowcount as well with the result set. However the developers want you to return 1 if there are rows and Read More... Posted Tuesday, February 12, 2008 3:46 PM by Denis Gobo | 1 Comments Filed under: Functions

• Summer SQL Teaser #12 Numeric

  Hi and welcome to another fascinating SQL summer teaser. Summer it is except in Princeton where it was 50 degrees this week. There was no teaser last week because of a death in the family, I had to go to a wake and a funeral last week. That is why this Read More... Posted Thursday, August 23, 2007 1:41 PM by Denis Gobo | 7 Comments Filed under: Functions, Teaser

• C# IsNullOrEmpty Function In SQL Server

  Mladen Prajdic has created a SQL equivalent of the C# IsNotNullOrEmpty I looked at it and thought that there was way too much code Here is my version, you pass an additional parameter in to indicate whether you want blanks only to count or not CREATE Read More... Posted Thursday, June 14, 2007 10:57 AM by Denis Gobo | 3 Comments Filed under: Functions, sqL Server 2000, SQL Server 2005