Showing posts with label presents. Show all posts
Showing posts with label presents. Show all posts

Monday, March 12, 2012

Instalation MSDE

When I execute the following instruction
OSQL /USA /P
presents the following error message:
[Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
SQL Server does not exist or access denied.
[Microsoft]{ODBC SQL Server Driver] Connectionopen
(connect())
Operating system WINDOWS 98 2 Edition
When I verify in the configurations / Panel of Control appeared a new icon
(MSDTC don't remind the acronym). When I execute and requested that selects
the service in what doesn't appear noneEither sa has a non-null password or MSDE is not installed as the default
instance. Use osql /l to list the available servers.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:#YYYXxFTDHA.1324@.TK2MSFTNGP11.phx.gbl...
> When I execute the following instruction
> OSQL /USA /P
> presents the following error message:
> [Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
> SQL Server does not exist or access denied.
> [Microsoft]{ODBC SQL Server Driver] Connectionopen
> (connect())
> Operating system WINDOWS 98 2 Edition
> When I verify in the configurations / Panel of Control appeared a new icon
> (MSDTC don't remind the acronym). When I execute and requested that
selects
> the service in what doesn't appear none
>

Friday, February 24, 2012

Inserting Text

Could someone help me, please?

How do I insert text, something like a header, before the result of the query presents itself?

I want the text to appear before the result. Not like an alias, that I know how to do.

Thanks.

SELECT 'This is my Header Message'

SELECT colList FROM MyTable

OR


SELECT
'This is My Header Message',
Col1,
Col2,
etc
FROM MyTable