Programming SQL

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

Function to compare two version strings
Hi all, Is there an SQL function that compares version strings? I know it can be done with CLR function using .NET System.Version class Thanks, Avi ... 17 Jul 2008 15:49

Insert query problem
The following is the problem query. MetricValue nvarchar(50) Valid values for TargetValue can be NULL, '', or some other string. INSERT INTO @M (ParameterID, EntityID, TargetValue) SELECT M.ParameterID, M.EntityID, M.MetricValue FROM tblMetric M INNER JOIN @ins i ON M.ParameterID = i.ParameterID AND M.Enti... 17 Jul 2008 11:40

Finding columns in tables with specific default constraints
How can I display some specific defaults on some tables? For example some tables may have a default on a CreatingUser_ID column that default the value to suser_sid(). How could I display: 1. table name 2. column name 3. (default) constraint name 4. the default clause Thank you, Omid ... 17 Jul 2008 12:43

view seems to ignore the 'concat null yields null' option
Hello all I have a database and am concatenatiing strings in a view. the value is coming up as null so I assumed that this was becasue 'concat null yields null' was set to true. I changed this setting (using the below) and checked it with the query on the database property (as well as checking the db option)... 17 Jul 2008 10:38

Script to generate SQL Agent jobs.
Anybody know of a script that generate all of the jobs for SQL Agent? TIA - Jeff. ... 18 Jul 2008 10:18

Sql question
Hi, can someone help me out with a query, im really stuck as to why this doesnt work :( Ive got a tree of data, with the tree stored using nested sets. Each node on the tree has a "mode". mode 0 means "inherit the mode from my parent", anything other than 0 is an explicit mode. I need to calculate the inherited ... 17 Jul 2008 09:36

SQL injection attacks
I just found this topic interesting about SQL Injection. http://www.go4expert.com/forums/showthread.php?t=11841 It helped me get the hackers perspective. Thanks Shabbir On Jun 3, 8:03 pm, "Roy Harvey (SQL Server MVP)" <roy_har...(a)snet.net> wrote: On Tue, 3 Jun 2008 05:48:00 -0700, Roger Withnell ... 17 Jul 2008 07:32