Browse by Tags

• sqL Server 2000
• Tip
• Tips and Tricks
• trick

• Do you depend on sp_depends (no pun intended)

  I answered this question on the MSDN forums: How can I search all my sprocs to see if any use a function? Several people suggested using sp_depends. You can't really depend on sp_depends because of deferred name resolution. Take a look at this First create Read More... Posted Tuesday, May 06, 2008 1:50 PM by Denis Gobo | 1 Comments Filed under: Gotcha, Tips and Tricks

• SQL Gotcha: Do you know what data type is used when running ad-hoc queries?

  This is for SQL Server 2000 only, SQL Server 2005 is a lot smarter which is another reason to upgrade. When running the following query you probably already know that 2 is converted to an int datatype. SELECT * FROM Table WHERE ID =2 What about the value Read More... Posted Monday, September 10, 2007 11:31 AM by Denis Gobo | 2 Comments Filed under: Tip, sqL Server 2000, trick, Gotcha