Farrell,

this comparison is a bit skewed, but php is pretty much like asp. Just another script language to bring dynamic content to the web. Take Linux, MySQL, Apache and PHP...

what will this select statement do?

It returns 1 = TRUE. So sysprocesses is a fake table. You can read about the OBJECTPROPERTY thing in BOL. It comes in handy in...

I don't think you can trigger sysprocesses as this is a fake table. It is a memory structure that only materialized when queried:

select

 objectproperty(object_id('sysprocesses'),'Tableisfake')

-----------

1

(1 row(s) affected)

What about a job...

Actually I think it's a bit unfair to expect my wife to take care of the kids all day, even when I'm at home. No, usually I bring the kids...

This should help you:

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

Sorry, this link might be better http://spaces.msn.com/members/jtkane/

See if this helps: http://sqljunkies.com/WebLog/JT_Kane/

or search here for John T. Kane. He is very specialised in all varieties of full text questions.

This might be a good place to start:

http://www.microsoft.com/downloads/details.aspx?FamilyID=62B348BB-0458-4203-BB03-8BE49E16E6CD&displaylang=en

That's a myth! You *can* create indexes on BIT columns:

CREATE TABLE IndexBit

(

 b1 BIT

)

CREATE CLUSTERED INDEX ixBit ON IndexBit(b1)

The command(s) completed successfully.

the example doesn't make too much sense, however it shows...

By the way, Frank is always on line

Only when I'm at work As you know, since three weeks I have other tasks to...

SELECT Total = ISNULL(amt_recharge,0) + ISNULL(amt_food.0) FROM ....

You don't need a total column at all. It's redundant.

You can write this code in Query Analyzer, which you will find in the...

See if this helps:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx

The big free software projects, like the Linux kernel, have very few of these kind of issues compared to proprietary code. The main reason being any budding software engineer looks...

Let me add this one: http://www.sqlservercentral.com/columnists/dsumlin/lookupstrategy.asp

The lazycoder might use something like

WHERE Your datecolumn  >= GETDATE() - 60