19/10/2012

[SQL] SQL Server SELECT FROM DUAL

In Oracle, you can easily test functions or simple statements with:

SELECT [things to test] FROM DUAL WHERE [conditions];

eg: SELECT LENGTH('string') FROM DUAL;

But Microsoft SQL Server doesn't have the FROM DUAL syntax; instead you should:

SELECT [thing to test] WHERE [conditions];

eg: SELECT LEN('string');

No comments:

Post a Comment

With great power comes great responsibility