Search results for query: *

I am attempting to install SQL Server 2005. I get the error message "SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup...

In a SELECT statement, I need to check whether a particular column contains a NULL and, if so, put four space characters in the output. I cannot just use ISNULL because I need to check for (and replace) other values in a CASE statement. The CASE statement replace my sting of spaces with the...

Hi I am using SQL Server 2000 Enterprise Edition. When I look at the Query execution plan (QEP) for the following T-SQL statements: DECLARE @TT int DECLARE @CC varchar(20) SET @TT = 1 SET @CC = '0' SELECT V FROM VIEW1 WHERE T = @TT AND C = @CC the query optimiser finds an efficient plan...

Hi I would like to write a User-Defined Function (UDF) that returns a Boolean value. This would mean that the UDF could be used where T-SQL syntax calls for a Boolean expression. Could someone tell me how I do this? The list of scalar return types for UDFs does not include a Boolean type...

As part of Meta Data Services (MDS) in SQL Server 2000, Microsoft has released a model development kit (MDK) that works with Rational Rose. Does anyone know of a tutorial guide, or even a case study, describing the use of the MDS MDK with Rational Rose? Of course, both the MDK and RR come...