Programming SQL

sproc question
In a sproc I need to issue a select, it returns five columns and always only one row. I need to pass those five values back to the calling proc in output parameters. Any of the five values could be Null. How do I do this? My 1360 page book (Wrox) does not show me. All the examples have ony one output parameter.... 17 Jul 2008 13:45

Question on triggers for our audit tables
We have several versions of our database: OurDatabaseDev OurDatabaseQA OurDatabaseUAT OurDatabase (Production) Furthermore, we have separated our audit tables in separate databases: OurDatabaseDevAudit OurDatabaseQAAudit OurDatabaseUATAudit OurDatabaseAudit (Production) We have ins... 18 Jul 2008 11:20

Schema comparison of two databases
Visual Studio database edition's schema comparison tool does a good job of identifying all differences between two databases. How do I go about doing this schema comparison directly in SQL server 2005 or 2008 and without the Visual Studio database edition? Thank you, Omid ... 17 Jul 2008 16:51

CTE Query
Hello all, I am trying to write a simple CTE query in SQL server 2005 as below: WITH TPAIPCTE(PIN, PINCount) AS ( SELECT PIN, COUNT(PIN) FROM DR_DetailRecordIP WHERE TaxYear = '05' AND Installment = '1' GROUP BY PIN ) The abvoe quey generates the following exception: Msg 102, Level 15, State 1, L... 17 Jul 2008 13:45

Connection Status
I have a table with the following information/columns: ServerName UserName PWord ConnectionStatus I want to write a SQL script that will test the user connection with the information in the table and update the ConnectionStatus column with a zero (0) if the connection is successful. I am basically trying t... 17 Jul 2008 16:51

How to display free spaces after massive truncate.
I have a db which about 417 gb, after I did some archives and truncate bunch of tables. I was able to save some spaces but still showing 417 gb on GUI. Is there a command that I need to run to show free spaces. Thanks. Here is the information when I run the sp is return correct but the gui is not showing ... 17 Jul 2008 12:43

Duplicate columns across 4 columns
Hi, We have a table called Clients that allows up to 4 telephone numbers to be entered. I am trying to write a query that will identify if another client has the same telephone number. I need to look in any of the 4 fields. E.g. If Client 1 has a tel no of 555555555 in TelNo1ID column and Client 2 has a t... 17 Jul 2008 14:47

Handling null dates ?
My tables have date ranges where the 'to' date can be open. I was advised not to use nulls in date/time columns. How is this normally done? I was told to put something like '12/31/2999' in there and test for that instead of null but this seems strange to me. ... 17 Jul 2008 13:45

Saving an image to SQL Server's image datatype
I am using ASP.NET 2.0, and need to know how to save and use an image that is stored in an SQL Server image datatype. How can I do this using ASP.NET? Thanks. ... 3 Aug 2008 10:59

Find nvarchar with special chars
SQL 2000. I want to find all records in a table that have special characters (e.g. %, &, @, etc.) in the RateCode column, basically anything other than a number or a letter (both upper and lower case ok). My SELECT stmt would be like SELECT EmployeeNumber, RateCode FROM EmployeePayRates WHERE RateCode LIKE... 17 Jul 2008 12:43