Thank this author by sharing:
By Maysarah Abu-Laban, 2008/08/11
Example 1:
After creating the function copy this into your Query Pane
SELECT dbo.Is_Leap (1800) AS [1800], dbo.Is_Leap (1900) AS [1900], dbo.Is_Leap (2000) AS [2000], dbo.Is_Leap (2004) AS [2004], dbo.Is_Leap (2008) AS [2008]
Example 2:
Print dbo.Is_Leap (2009)
The curses of dynamic sql
If you make changes to the settings of a database, it can cause the procedure cache to be cleared. M...
Hello, I have table named 'a' that have 2 columns 'aa' and 'cc' corresponding to 2 PK columns i...
Comparing between tables, I have found out that some of them result in an error like: The text, nt...
Hello, I have wrote one store proc. So, in the stored procedure, it is using one table which is ...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
