Access Format Equivalent

Hello:
What would the equivalent syntax be to format the
following in SQL as can be done in Access.
Format("000000",employee) to return 012345 from 12345
CREATE TABLE #Temp
(
Employee CHAR(6)
)
INSERT INTO #Temp VALUES ('1')
INSERT INTO #Temp VALUES ('12')
INSERT INTO #Temp VALUES ('123')
INSERT INTO #Temp VALUES ('1234')
INSERT INTO #Temp VALUES ('12345')
SELECT * FROM #Temp
SELECT REVERSE(LEFT(LTRIM(REVERSE('000000'+ Employee)),6))
FROM #Temp
Rohtash Kapoor
http://www.sqlmantra.com
"Bryan" <anonymous@.discussions.microsoft.com> wrote in message
news:1c02d01c45186$9f7810d0$a001280a@.phx.gbl...
> Hello:
> What would the equivalent syntax be to format the
> following in SQL as can be done in Access.
> Format("000000",employee) to return 012345 from 12345
>
|||Thanks for the reply, but I think I found a simpler way.
select right('000000' + convert(varchar,
employee_number), 6)

>--Original Message--
>CREATE TABLE #Temp
>(
> Employee CHAR(6)
>)
>INSERT INTO #Temp VALUES ('1')
>INSERT INTO #Temp VALUES ('12')
>INSERT INTO #Temp VALUES ('123')
>INSERT INTO #Temp VALUES ('1234')
>INSERT INTO #Temp VALUES ('12345')
>SELECT * FROM #Temp
>SELECT REVERSE(LEFT(LTRIM(REVERSE('000000'+
Employee)),6))
>FROM #Temp
>--
>Rohtash Kapoor
>http://www.sqlmantra.com
>"Bryan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1c02d01c45186$9f7810d0$a001280a@.phx.gbl...
>
>.
>

Access denied on restart

The following error occures after installation of several
Hotfixes:
"The MSSQLServer service failed to start due to the
following error:
Access is denied."
It seems that the LocalSystem account cannot start the
MSSQL services. The service is temporarily started using
the domain admin account. I recently installed Hotfixes
KB824151, KB841533, KB840987, KB841356 en KB883935 on my
W2K SQL server, running SQL 7.0.
Before de-installing and restarting these hotfixes one-by-
one, i thought to have a try via this newsgroup.
TIA,
Wouter
Take a look in Books online... Search for Services Accounts.
There it details all of the requirements for permissions for the accounts...
The thing that is strange is that I have never , ever had any problems
starting SQL with localsystem...
If you have changed the account using control panel, services and are using
Full text search, you could cause a problem... In my opinion it is a best
practice to set up an account specifically for SQL Services login anyway...
Perhaps it is time you do that...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Wouter" <anonymous@.discussions.microsoft.com> wrote in message
news:0f5b01c4d606$b1a624e0$a501280a@.phx.gbl...
> The following error occures after installation of several
> Hotfixes:
> "The MSSQLServer service failed to start due to the
> following error:
> Access is denied."
> It seems that the LocalSystem account cannot start the
> MSSQL services. The service is temporarily started using
> the domain admin account. I recently installed Hotfixes
> KB824151, KB841533, KB840987, KB841356 en KB883935 on my
> W2K SQL server, running SQL 7.0.
> Before de-installing and restarting these hotfixes one-by-
> one, i thought to have a try via this newsgroup.
> TIA,
> Wouter
|||Wayne,
Thanks for you reply. The thing is, we also never, ever
had problems starting SQL with the LocalSystem account,
untill I installed the hotfixes. I'm pretty sure un-
installing the hotfixes will solve my problem, but that is
not the general idea behind hotfixes, is it?
Any other suggestions? If not I'll consider creating a SQL
Services login account.
Wouter

>--Original Message--
>Take a look in Books online... Search for Services
Accounts.
>There it details all of the requirements for permissions
for the accounts...
>The thing that is strange is that I have never , ever had
any problems
>starting SQL with localsystem...
>If you have changed the account using control panel,
services and are using
>Full text search, you could cause a problem... In my
opinion it is a best
>practice to set up an account specifically for SQL
Services login anyway...
>Perhaps it is time you do that...
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"Wouter" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:0f5b01c4d606$b1a624e0$a501280a@.phx.gbl...
several[vbcol=seagreen]
by-
>
>.
>

Access denied on restart

The following error occures after installation of several
Hotfixes:
"The MSSQLServer service failed to start due to the
following error:
Access is denied."
It seems that the LocalSystem account cannot start the
MSSQL services. The service is temporarily started using
the domain admin account. I recently installed Hotfixes
KB824151, KB841533, KB840987, KB841356 en KB883935 on my
W2K SQL server, running SQL 7.0.
Before de-installing and restarting these hotfixes one-by-
one, i thought to have a try via this newsgroup.
TIA,
WouterTake a look in Books online... Search for Services Accounts.
There it details all of the requirements for permissions for the accounts...
The thing that is strange is that I have never , ever had any problems
starting SQL with localsystem...
If you have changed the account using control panel, services and are using
Full text search, you could cause a problem... In my opinion it is a best
practice to set up an account specifically for SQL Services login anyway...
Perhaps it is time you do that...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Wouter" <anonymous@.discussions.microsoft.com> wrote in message
news:0f5b01c4d606$b1a624e0$a501280a@.phx.gbl...
> The following error occures after installation of several
> Hotfixes:
> "The MSSQLServer service failed to start due to the
> following error:
> Access is denied."
> It seems that the LocalSystem account cannot start the
> MSSQL services. The service is temporarily started using
> the domain admin account. I recently installed Hotfixes
> KB824151, KB841533, KB840987, KB841356 en KB883935 on my
> W2K SQL server, running SQL 7.0.
> Before de-installing and restarting these hotfixes one-by-
> one, i thought to have a try via this newsgroup.
> TIA,
> Wouter|||Wayne,
Thanks for you reply. The thing is, we also never, ever
had problems starting SQL with the LocalSystem account,
untill I installed the hotfixes. I'm pretty sure un-
installing the hotfixes will solve my problem, but that is
not the general idea behind hotfixes, is it?
Any other suggestions? If not I'll consider creating a SQL
Services login account.
Wouter

>--Original Message--
>Take a look in Books online... Search for Services
Accounts.
>There it details all of the requirements for permissions
for the accounts...
>The thing that is strange is that I have never , ever had
any problems
>starting SQL with localsystem...
>If you have changed the account using control panel,
services and are using
>Full text search, you could cause a problem... In my
opinion it is a best
>practice to set up an account specifically for SQL
Services login anyway...
>Perhaps it is time you do that...
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"Wouter" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0f5b01c4d606$b1a624e0$a501280a@.phx.gbl...
several[vbcol=seagreen]
by-[vbcol=seagreen]
>
>.
>