Discuss Content Posted by James Travis

• Topics

  Started by

  Posts

  Last post

• ISNull Not working

  SELECT OrgCode AS UnitState , OrgCode As State, IsNull(Count(*), 0) As [SLRP Approved] FROM tLo…

  Faye Fouladi

  6 replies

  13 years, 5 months ago

  By: Johan Bijnens

• Is there any difference between a NULL and a Blank field in MS SQL

  My question is, is there any difference between a NULL and a Blank field in MS SQL or are they the …

  shameersinbox

  4 replies

  13 years, 10 months ago

  By: Johan Bijnens

• I want to dispaly 0 when the resultset of count(*) is zero

  When Select Count(*) From Tbltracking where Year(DateStamp) = 2009 returns no records I want to dis…

  Faye Fouladi

  4 replies

  15 years ago

  By: RBarryYoung

• When resultset of count is nothing

  When trying to get the count of records where a certain condition is met and the no records are ret…

  Faye Fouladi

  2 replies

  15 years, 1 month ago

  By: Faye Fouladi

• Find a string in DB objects.

  Comments posted to this topic are about the item Find a string in DB objects.

  Antares686

  1 replies

  16 years, 7 months ago

  By: temp89108

• Understanding the difference between IS NULL and = NULL

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colum…

  Antares686

  40 replies

  16 years, 10 months ago

  By: gatorspike

• Hidden Dangers!

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colum…

  Antares686

  10 replies

  19 years, 7 months ago

  By: JT Lovell

• Review of Guru's Guide to SQL Server Architecture and Internals

  Comments posted to this topic are about the content posted at http://www.sqlservercent

  Antares686

  8 replies

  19 years, 8 months ago

  By: progsup

• PASS Summit 2004 - Another Look

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colum…

  Antares686

  3 replies

  20 years, 2 months ago

  By: Antares686

• What is the search order for Procedures prefixed sp_?

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colum…

  Antares686

  26 replies

  20 years, 9 months ago

  By: fhanlon

• Review of Programming Microsoft SQL Server 2000 with Microsoft Visual

  Comments posted to this topic are about the content posted at http://www.sqlservercent

  Antares686

  2 replies

  20 years, 9 months ago

  By: David.Poole

• How to Fix Inconsistent Metadata Errors

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colum…

  Antares686

  20 replies

  21 years, 3 months ago

  By: phatal

• Backup and Restore of a single table

  In SQL Server 6.5 version, it is possible to backup and load a single table from the backup of full…

  control

  1 replies

  21 years, 11 months ago

  By: Antares686