Insane Meditation

Really interesting thing I realised today: Using OPTION (FORCE ORDER) within a UDF, at least in SQL Server 2005 (i haven’t tested in other versions), doesn’t work if you are within the RETURN clause. It does, however, if you aren’t. For example: CREATE FUNCTION SchemaName.udfName ()RETURNS VARCHAR(50)ASBEGIN    RETURN    (            SELECT  t1.Field        FROM    SchemaName.Table1 t1        [...]

SQL Express is the free, low-powered MySQL-competing version of SQL Server. It’s primarily neutered when it comes to hardware utilization (it will use at most 1 CPU and 1GB memory) and maximum database size (4GB excluding log files), but for quite a large number of personal or workgroup-level applications, as well as test and development [...]