Then again, I disagree!

There is no binary answer to this question. Each approach has its pros and cons and in some environments it might be advisable to use the db...

Search the forum. There are plenty of threads on how to strip the time off a datetime or how to do search an compare on datetimes.

You might want to have a look at this:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

and decide then which way to go.

It depends on several factors which one offers best performance. The only way to find this out is to test both in your environment. Dynamic SQL is mostly considered not...

Forgot to mention that you should run this against the pubs database

Here's an example utilizing sp_executesql:

http://www.insidesql.de/modules.php?op=modload&name=News&file=article&sid=134

HTH

I was wondering what technic do they use?

Whats the magik trick???

What's so magic about this anyway?

• Use a RDBMS
• Design a sound schema
• Create useful indexes
• Create sound queries

there you go

Not sure, if I fully understand you, but I think you're missing link is INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE. So something like this

SELECT 

 C.TABLE_NAME

 , C.ORDINAL_POSITION

 , C.COLUMN_NAME

FROM

 INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC

INNER JOIN

 INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CCU

ON

 RC.CONSTRAINT_NAME = CCU.CONSTRAINT_NAME

 INNER JOIN

  INFORMATION_SCHEMA.COLUMNS...

Have you ever thought about replacing your VARCHAR(5000) column with a text datatype column?

Btw, there is SET PARSEONLY { ON | OFF }. Never used it myself, but might be worth having a look at in BOL.

Like Mike already said, you're trying to reinvent the wheel!

If I were you, I wouldn't waste my time with such a thing.

The other important consideration is also already mentioned: SQL...

Playing around with SQL Server's system objects is one of the easiest ways to fubar SQL Server. In doing so, you're running an unsupported system. I would rather contact the...

You mean something liek this

SET NOCOUNT ON
CREATE TABLE year_t
(
year_now INT DEFAULT SELECT DATEPART(YEAR, GETDATE()) --DATEPART(year,GETDATE())
)
INSERT INTO year_t DEFAULT VALUES
SELECT * FROM year_t
DROP TABLE year_t
SET NOCOUNT OFF

has worked for you???

Cute!

I like this HTML-thingy

What is your goal?