http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

Please also show us what you've done. We don't want to be doing homework or exam questions without you trying. We'll help you figure out what's wrong.

foxjazz,

You seem to be frustrated with T-SQL, but it appears that a lot of your complaints are just ignorance in how the language works. You example is one of the...

The encryption is done by the compiler. I'm not sure you can stick the encrypted text in there.

It's moot. If you have a client that wants to mess with the...

You're giving semantic differences. BEGIN and END function as {}. There's not difference. Honestly you could macro those to replace { with Begin if it's that important to you.

Assignment of...

When you query the table you'll get a result set that has multiple rows in it. That can be sent via email to a manager.

This might help: http://www.sqldts.com/235.aspx

This should help:

http://www.sqldts.com/246.aspx

It's possible.

The hostname and many of those metadata fields about the connection are sent through by the driver. They can be overridden easily.

However someone would have to specifically code...

Execute T-SQL task. Put the sproc name in there.

How are you querying the data. You could be causing an implicit CAST.

You need a driver from PHP for reaching SQL Server. This should be found in PHP documentation.

For the connection string, you'll need the server name and then user/password that allows...

Closing.

Closing.

Please don't cross post.

T-SQL comes from SQL. It was developed by Sybase, not MS. It's similar to PL-SQL, which Oracle uses, but there are substantial differences.

A query language, working with sets of data,...

It should go down. That sounds weird, like SQL Server is trying to hold most stuff in memory constantly, and it's exceeding limits so you're paging.

Strange.