SQL EXPLORER
About Me
Mohamed Faizal
Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G
View my complete profile
Tuesday, February 4, 2014
Generate Random numbers and String for the existing table
,
ABS
(
CHECKSUM
(
NewId
()))
%
1244785647
as
Number
,
SUBSTRING
(
CONVERT
(
varchar
(
255
),
NEWID
()),
0
,
9
)
as
[Name]
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment