Programming SQL

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

What instances on this box?
Is there an MS-DOS command for "What MS-SQL Server instances on this box?" I've tried: sqlcmd -L but it lists everything the box can see, not just what's on the box. ... 17 Jul 2008 10:38

Update with Case Statement
Hello Everybody, I am writing a stored proc for generating a report and it has below SQLs. I am attempting to update the Premium and remittance basing on the source id. But its not giving me the desired result. I am trying to update 34 columns basing on the source id. Could anyone please tell me why Premi... 17 Jul 2008 06:31

Retive username / machine name
Hi, How can i retirve information as follows : 1. User name who execute an sql statement. 2. machine name (on which machine sql statement execute). 3. is sql statement execute by directly by management studio/ qa or an application. and if an appliction, can i get the application name? Rahul ... 18 Jul 2008 06:11