Relace function of mysql

Hi,
Want to know that is their any option of inserting a record if the record does not exist in the table..while firing update query.
In mysql, we have replace which updates or inserts the record.
do let me know
thanx,
vivek.No SQL Server does not have a command like that. In my case all of my commands are done within a stored procedure, so I first check to see if the record exists, if yes then UPDATE else INSERT.

IF EXISTS (SELECT * FROM myTable WHERE pkey = @.pkey) BEGIN
UPDATE myTable
.
.
.
.
END ELSE
INSERT myTable
.
.
.
.
END|||Thanx,

will surely try with Stored procs.

regards,
vivek.

Registering Error

I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
error
"SLQ Server does exist or access denied(ConnectionOpern(connect))
where is the problem its urgent can any body help me
Yousuf Khan
Programmer
I assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need to
use EM 6.5 to manage 6.5.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
> error
> "SLQ Server does exist or access denied(ConnectionOpern(connect))
> where is the problem its urgent can any body help me
> --
> Yousuf Khan
> Programmer
|||i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
registers it first
Yousuf Khan
Programmer
"Tibor Karaszi" wrote:

> I assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need to
> use EM 6.5 to manage 6.5.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yousuf" <yousuf.yk@.gmail.com> wrote in message
> news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>
>
|||Such an "import" is performed using the SQL Server 2000 Upgrade Wizard (found in the "Microsoft SQL
server - Switch" program group).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:DE8EB7CB-A9A2-4D0F-8E07-CD9E93D554D4@.microsoft.com...[vbcol=seagreen]
>i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
> registers it first
> --
> Yousuf Khan
> Programmer
>
> "Tibor Karaszi" wrote:

Registering Error

I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
error
"SLQ Server does exist or access denied(ConnectionOpern(connect))
where is the problem its urgent can any body help me
Yousuf Khan
ProgrammerI assume that you want to manage 6.5 from Enterprise Manager 2000? If so, ca
n't be done. You need to
use EM 6.5 to manage 6.5.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
> error
> "SLQ Server does exist or access denied(ConnectionOpern(connect))
> where is the problem its urgent can any body help me
> --
> Yousuf Khan
> Programmer|||i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
registers it first
Yousuf Khan
Programmer
"Tibor Karaszi" wrote:

> I assume that you want to manage 6.5 from Enterprise Manager 2000? If so,
can't be done. You need to
> use EM 6.5 to manage 6.5.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yousuf" <yousuf.yk@.gmail.com> wrote in message
> news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>
>|||Such an "import" is performed using the SQL Server 2000 Upgrade Wizard (foun
d in the "Microsoft SQL
server - Switch" program group).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:DE8EB7CB-A9A2-4D0F-8E07-CD9E93D554D4@.microsoft.com...[vbcol=seagreen]
>i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
> registers it first
> --
> Yousuf Khan
> Programmer
>
> "Tibor Karaszi" wrote:
>

Registering Error

I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
error
"SLQ Server does exist or access denied(ConnectionOpern(connect))
where is the problem its urgent can any body help me
--
Yousuf Khan
ProgrammerI assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need to
use EM 6.5 to manage 6.5.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
> error
> "SLQ Server does exist or access denied(ConnectionOpern(connect))
> where is the problem its urgent can any body help me
> --
> Yousuf Khan
> Programmer|||i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
registers it first
--
Yousuf Khan
Programmer
"Tibor Karaszi" wrote:
> I assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need to
> use EM 6.5 to manage 6.5.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yousuf" <yousuf.yk@.gmail.com> wrote in message
> news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
> >I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
> > error
> > "SLQ Server does exist or access denied(ConnectionOpern(connect))
> > where is the problem its urgent can any body help me
> >
> > --
> > Yousuf Khan
> > Programmer
>
>|||Such an "import" is performed using the SQL Server 2000 Upgrade Wizard (found in the "Microsoft SQL
server - Switch" program group).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:DE8EB7CB-A9A2-4D0F-8E07-CD9E93D554D4@.microsoft.com...
>i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
> registers it first
> --
> Yousuf Khan
> Programmer
>
> "Tibor Karaszi" wrote:
>> I assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need
>> to
>> use EM 6.5 to manage 6.5.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Yousuf" <yousuf.yk@.gmail.com> wrote in message
>> news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>> >I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
>> > error
>> > "SLQ Server does exist or access denied(ConnectionOpern(connect))
>> > where is the problem its urgent can any body help me
>> >
>> > --
>> > Yousuf Khan
>> > Programmer
>>