SQL automatic data conversion from DEC to HEX
0
I have not much in common with SQL databases.
I need to convert Serial number to HEX, Dk number to HEX and connect these numbers. After some research I made this code
update dbo.UsersAccessUnit
set Code = convert(nvarchar(3), Convert(varbinary(1), 255), 2 ) + convert(nvarchar(5), Convert(varbinary(2), 65534 ), 2 )
where Id between '1' and '2000';
And it works fine. But I want to do all rows automatically. How could I do that?
If I write like this:
update dbo.UsersAccessUnit
set Code = convert(nvarchar(3), Convert(varbinary(1), Serial), 2 ) + convert(nvarchar(5), Convert(varbinary(2), Dk), 2 )
where Id between '1' and '2000';
It doesn't get the right answer.
sql
sql-server edited Nov 11 '18 at 20:27
Larnu
15.3k41630
asked Nov 11 '18 at 19:30
Vytautas Riva Šimkus
12
|
show 6 more comments
0
I have not much in common with SQL databases.
I need to convert Serial number to HEX, Dk number to HEX and connect these numbers. After some research I made this code
update dbo.UsersAccessUnit
set Code = convert(nvarchar(3), Convert(varbinary(1), 255), 2 ) + convert(nvarchar(5), Convert(varbinary(2), 65534 ), 2 )
where Id between '1' and '2000';
And it works fine. But I want to do all rows automatically. How could I do that?
If I write like this:
update dbo.UsersAccessUnit
set Code = convert(nvarchar(3), Convert(varbinary(1), Serial), 2 ) + convert(nvarchar(5), Convert(varbinary(2), Dk), 2 )
where Id between '1' and '2000';
It doesn't get the right answer.
sql
sql-server edited Nov 11 '18 at 20:27
Larnu
15.3k41630
asked Nov 11 '18 at 19:30
Vytautas Riva Šimkus
12
mysql or sql server? they are not same?
– Eray Balkanli
Nov 11 '18 at 19:34
3
also, I don't clearly understand your problem. Why dont u just remove where clause?
– Eray Balkanli
Nov 11 '18 at 19:34
sorry. sql server. with my code i am editing just one single line and I want to edit all rows at once.
– Vytautas Riva Šimkus
Nov 11 '18 at 19:35
please try without where clause?
– Eray Balkanli
Nov 11 '18 at 19:40
So why isn't the comment from @ErayBalkanli the answer..? Are we missing a vital piece of information?
– Larnu
Nov 11 '18 at 19:41
|
show 6 more comments
0
0
0
I have not much in common with SQL databases.
I need to convert Serial number to HEX, Dk number to HEX and connect these numbers. After some research I made this code
update dbo.UsersAccessUnit
set Code = convert(nvarchar(3), Convert(varbinary(1), 255), 2 ) + convert(nvarchar(5), Convert(varbinary(2), 65534 ), 2 )
where Id between '1' and '2000';
And it works fine. But I want to do all rows automatically. How could I do that?
If I write like this:
update dbo.UsersAccessUnit
set Code = convert(nvarchar(3), Convert(varbinary(1), Serial), 2 ) + convert(nvarchar(5), Convert(varbinary(2), Dk), 2 )
where Id between '1' and '2000';
It doesn't get the right answer.
sql
sql-server edited Nov 11 '18 at 20:27
Larnu
15.3k41630
asked Nov 11 '18 at 19:30
Vytautas Riva Šimkus
12
I have not much in common with SQL databases.
I need to convert Serial number to HEX, Dk number to HEX and connect these numbers. After some research I made this code
update dbo.UsersAccessUnit
set Code = convert(nvarchar(3), Convert(varbinary(1), 255), 2 ) + convert(nvarchar(5), Convert(varbinary(2), 65534 ), 2 )
where Id between '1' and '2000';
And it works fine. But I want to do all rows automatically. How could I do that?
If I write like this:
update dbo.UsersAccessUnit
set Code = convert(nvarchar(3), Convert(varbinary(1), Serial), 2 ) + convert(nvarchar(5), Convert(varbinary(2), Dk), 2 )
where Id between '1' and '2000';
It doesn't get the right answer.
sql
sql-server sql
sql-server edited Nov 11 '18 at 20:27
Larnu
15.3k41630
asked Nov 11 '18 at 19:30
Vytautas Riva Šimkus
12
edited Nov 11 '18 at 20:27
Larnu
15.3k41630
asked Nov 11 '18 at 19:30
Vytautas Riva Šimkus
12
edited Nov 11 '18 at 20:27
Larnu
15.3k41630
edited Nov 11 '18 at 20:27
Larnu
15.3k41630
edited Nov 11 '18 at 20:27
Larnu
15.3k41630
15.3k41630
asked Nov 11 '18 at 19:30
Vytautas Riva Šimkus
12
asked Nov 11 '18 at 19:30
Vytautas Riva Šimkus
12
asked Nov 11 '18 at 19:30
Vytautas Riva Šimkus
12
12
mysql or sql server? they are not same?
– Eray Balkanli
Nov 11 '18 at 19:34
3
also, I don't clearly understand your problem. Why dont u just remove where clause?
– Eray Balkanli
Nov 11 '18 at 19:34
sorry. sql server. with my code i am editing just one single line and I want to edit all rows at once.
– Vytautas Riva Šimkus
Nov 11 '18 at 19:35
please try without where clause?
– Eray Balkanli
Nov 11 '18 at 19:40
So why isn't the comment from @ErayBalkanli the answer..? Are we missing a vital piece of information?
– Larnu
Nov 11 '18 at 19:41
|
show 6 more comments
mysql or sql server? they are not same?
– Eray Balkanli
Nov 11 '18 at 19:34
3
also, I don't clearly understand your problem. Why dont u just remove where clause?
– Eray Balkanli
Nov 11 '18 at 19:34
sorry. sql server. with my code i am editing just one single line and I want to edit all rows at once.
– Vytautas Riva Šimkus
Nov 11 '18 at 19:35
please try without where clause?
– Eray Balkanli
Nov 11 '18 at 19:40
So why isn't the comment from @ErayBalkanli the answer..? Are we missing a vital piece of information?
– Larnu
Nov 11 '18 at 19:41
mysql or sql server? they are not same?
– Eray Balkanli
Nov 11 '18 at 19:34
mysql or sql server? they are not same?
– Eray Balkanli
Nov 11 '18 at 19:34
3
3
also, I don't clearly understand your problem. Why dont u just remove where clause?
– Eray Balkanli
Nov 11 '18 at 19:34
also, I don't clearly understand your problem. Why dont u just remove where clause?
– Eray Balkanli
Nov 11 '18 at 19:34
sorry. sql server. with my code i am editing just one single line and I want to edit all rows at once.
– Vytautas Riva Šimkus
Nov 11 '18 at 19:35
sorry. sql server. with my code i am editing just one single line and I want to edit all rows at once.
– Vytautas Riva Šimkus
Nov 11 '18 at 19:35
please try without where clause?
– Eray Balkanli
Nov 11 '18 at 19:40
please try without where clause?
– Eray Balkanli
Nov 11 '18 at 19:40
So why isn't the comment from @ErayBalkanli the answer..? Are we missing a vital piece of information?
– Larnu
Nov 11 '18 at 19:41
So why isn't the comment from @ErayBalkanli the answer..? Are we missing a vital piece of information?
– Larnu
Nov 11 '18 at 19:41
|
show 6 more comments
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53252402%2fsql-automatic-data-conversion-from-dec-to-hex%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53252402%2fsql-automatic-data-conversion-from-dec-to-hex%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
mysql or sql server? they are not same?
– Eray Balkanli
Nov 11 '18 at 19:34
3
also, I don't clearly understand your problem. Why dont u just remove where clause?
– Eray Balkanli
Nov 11 '18 at 19:34
sorry. sql server. with my code i am editing just one single line and I want to edit all rows at once.
– Vytautas Riva Šimkus
Nov 11 '18 at 19:35
please try without where clause?
– Eray Balkanli
Nov 11 '18 at 19:40
So why isn't the comment from @ErayBalkanli the answer..? Are we missing a vital piece of information?
– Larnu
Nov 11 '18 at 19:41