Comparing Stored Procedures, Part 5

Fifth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures

Cloning

RE: Question of the Day for 07 Sep 2004

The answer is not incorrect but the wording is a bit misleading. While it is true that adding 'not null' changes the outcome, it is not true that the column will be filled with 'N' automatically as such.Regards

Locating global temp tables via asp problem

Hi,I've created a temp table to hold values for a report within an sp. ASP code then checks for the existance of the temp table to decide if a report report is to be printed or not. strSQL = "SELECT id FROM tempdb..sysobjects WHERE name = '##tmptable' AND Type = 'U'"After the sp has run, I can run the above via SQL […]

RE: Doing Short Circuiting in WHERE clause

Actually, I did think of implementing 'jpipes' method before I posted. But when you give users 4 to 8 different ways to tailer their search, like Scott says, the permutations sure add up quickly. I think that some of my search senerios will likely bias one over another method.....albeit not necessarily from a performance aspect. […]

RE: Numbering the Result Set - Like Rownum(ORACLE)

There is no equivalent to ROWNUM in SQL. Take a look at this: http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133

RE: NULL values in source table don't add up

Ryan, In my opinion there is no reason at all to not replace NULLs in your fact table by references to a 'N/A' record. I can see your management's point if you're talking about a table that is used in an OLTP environment, but in an OLAP environment NULL values in the dimension fields just […]

RE: startup procedure listing

You can try: use master select name from sysobjects where objectproperty(id, 'ExecIsStartup') = 1

RE: Database can't be reached by users

Everything worked fine until the database was moved to a new virtual server and a new array. ODBC connections worked before the move. And the ODBC connections don't change from one node to another anyways. The backup is being run as a job step that I wrote. The step is: backup mydatabase to dbdevice with […]

RE: SQL and XML format

Hi Crispin I used the following: Select client_id, cl_fname, cl_lname FROM clients AS Client for XML AUTO, ELEMENTS This gives me: <Client> <client_id>1</client_id> <cl_fname>koos</cl_fname> <cl_lname>Viljoen</cl_lname> </Client> This is ok, but i am actually looking for: <Client client_id="1"> <cl_fname>koos</cl_fname> <cl_lname>Viljoen</cl_lname> </Client> How would I have to change the query if at all it is possible Cheers […]