A simple math expression solver
Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.
2011-11-21
5,685 reads
Recursive function
View - Table Usage (Recursive)
Written to explore the table dependencies of a view, especially when the view queries other views.
2009-01-22 (first published: 2009-01-11)
1,102 reads
Recursive Queries using Common Table Expressions (CTE) in SQL Server
The problem arises when the hierarchy level increases as SQL Server is limited to 32 levels of recursion. We need a better way to implement recursive queries in SQL Server 2005. How do we do it?
2008-07-02
5,894 reads
RE: Problem with Query
I changed your query a little. select t.name as tablename , c.name as columnname , isnull(p.name,'''') as ConstraintName, case p.xtype When 'PK' Then 'Primary Key' When 'C' Then 'Check' When 'UQ' Then 'Unique' When 'F' Then 'Foreign Key' When 'TR' Then 'Trigger' When 'D' Then 'Default' Else '' End As ConstraintType from sysobjects t join […]
2003-08-21
2003-06-10
RE: Need a good Internet Mail Server
I would recommend either Vpop3 from PSCS (http://www.vpop3.co.uk), or iMail from Ipswitch (http://www.ipswitch.com). There is a free version of iMail available called iMail Express I believe that offers you a basic mail server for no cost. Hope this helps.
2003-05-28
RE: monitor
You don't mean Task Manager, do you? If you mean something like Current Activity in EM there is a really good script for a sp here: http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=135&lngWId=5 Cheers, Frank
2003-05-22
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers