Email Resultset with sql mail?

I would like to email myself the results of a query once a day. Can I do thi
s
with sql mail? If so, can someone point me in the direction of some
documentation on how to do this?From SQL BOL
This example sends the results of the sp_configure to Robert King.
EXEC xp_sendmail 'robertk', @.query = 'sp_configure'
HTH. Ryan
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:F035773E-BD7A-43D9-AEF1-3AE09C88F3AD@.microsoft.com...
>I would like to email myself the results of a query once a day. Can I do
>this
> with sql mail? If so, can someone point me in the direction of some
> documentation on how to do this?

Email Resultset with sql mail?

I would like to email myself the results of a query once a day. Can I do this
with sql mail? If so, can someone point me in the direction of some
documentation on how to do this?
From SQL BOL
This example sends the results of the sp_configure to Robert King.
EXEC xp_sendmail 'robertk', @.query = 'sp_configure'
HTH. Ryan
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:F035773E-BD7A-43D9-AEF1-3AE09C88F3AD@.microsoft.com...
>I would like to email myself the results of a query once a day. Can I do
>this
> with sql mail? If so, can someone point me in the direction of some
> documentation on how to do this?
sql

Email Resultset with sql mail?

I would like to email myself the results of a query once a day. Can I do this
with sql mail? If so, can someone point me in the direction of some
documentation on how to do this?From SQL BOL
This example sends the results of the sp_configure to Robert King.
EXEC xp_sendmail 'robertk', @.query = 'sp_configure'
--
HTH. Ryan
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:F035773E-BD7A-43D9-AEF1-3AE09C88F3AD@.microsoft.com...
>I would like to email myself the results of a query once a day. Can I do
>this
> with sql mail? If so, can someone point me in the direction of some
> documentation on how to do this?

Electrical Symbols - Ohms - micro

Hi,
would anyone be able to point me in the right direction on how to save
the
electrical symbols for ohms and micro in a sql server field.
Many thanks,Make sure you use NVARCHAR, and pass the character in a string with the N
prefix.
CREATE TABLE dbo.foo
(
symbol NVARCHAR(32)
);
GO
INSERT dbo.foo
SELECT N''; -- not sure if this will be correct in your newsreader
GO
SELECT symbol FROM dbo.foo;
GO
DROP TABLE foo;
GO
"Jedawi" <jedawi@.hotmail.co.uk> wrote in message
news:eK9ZVWkBGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hi,
> would anyone be able to point me in the right direction on how to save
> the
> electrical symbols for ohms and micro in a sql server field.
> Many thanks,
>
>|||Many thanks Aaron, works a treat..
Cheers
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uVLElYkBGHA.1008@.TK2MSFTNGP12.phx.gbl...
> Make sure you use NVARCHAR, and pass the character in a string with the N
> prefix.
> CREATE TABLE dbo.foo
> (
> symbol NVARCHAR(32)
> );
> GO
> INSERT dbo.foo
> SELECT N''; -- not sure if this will be correct in your newsreader
> GO
> SELECT symbol FROM dbo.foo;
> GO
> DROP TABLE foo;
> GO
>
>
> "Jedawi" <jedawi@.hotmail.co.uk> wrote in message
> news:eK9ZVWkBGHA.1288@.TK2MSFTNGP09.phx.gbl...
>