SQL Server database programming

I'm hoping SQL can allow me to refer to an expression in a Select, but can't find any syntax; I suppose that a function might work.  Here's the problem:   I've got a existing DB table with a date stored as an integer, so to ...

Hi, The question is mentioned below the DDL. CREATE TABLE BUDGET ( emp_id INT, task_name VARCHAR(20), allotted INT, spend INT, commn INT, balance INT, date_spend DATETIME ) GO INSERT INTO budget VALUES(1,'TASK1',1000,800,25,175,'JAN 1 2005') ...

For reasons that are not relevant (though I explain them below *), I want, for all my users whatever privelige level, an SP which creates and inserts into a temporary table and then another SP which reads and drops the same temporary table. ...

Hello there I need to create sql mail in order to send messages by sql events. I've decered my mail with windows mail and i couldn't use it on sql server where can be the problem? ...