If your proc "is designed to do the same sort of thing as Access's cascade delete function", why not just set Delete Rule to Cascade for your relationship?

That is one of the ways you can do it without a cursor:

declare @iLastPersonId int

create table #t_person

(

person_id INT NOT NULL IDENTITY(1,1),

...

Can you explain a bit what you mean by idle table?

Actually triggers are raised on some action (update, insert or delete).

If you want to raise something when nothing happens...

and

sp_helpindex tablename

To my knowledge, SQL2008 provides a better and more reliable way to check object dependency in SQL Server than in SQL2005 - it is new sys.sql_expression_dependencies. Some more details...

Jeff Moden (7/19/2010)

Eugene Elutin (7/19/2010)

Jeff Moden (7/15/2010)

Eugene Elutin (7/14/2010)

If you need high-performance heavy string manipulation functions write them as CLR...

Other SQL developers may be not generaly using...

Simple answer:

There is no "more elegant way". You can script executing of sp_refreshsqlmodule for each UDF in your database and run this script after altering any view/table (please note...

"!=" it is...

Jeff Moden (7/15/2010)

Eugene Elutin (7/14/2010)

If you need high-performance heavy string manipulation functions write them as CLR functions in c#. T-SQL...

If...

It is matter of preference...

Check this one:

http://www.blackwasp.co.uk/SQLDateTimeCutOff.aspx

funooni (7/19/2010)

...

Supplying the value value 19 to DATEPART function with the first option 'WEEK', it will return 3 which means this is the 3rd week of the month.

One more thing...

As you table design does look like flat-file and not a proper table of realtional database, I can guide you first how to design the table in relational database...

Your table...