SQL Queries and Tips
Tuesday, December 31, 2013
Generate GUID / Global Unique Identifer simple approach
DECLARE
@CNT
AS
INT
=
1
;
CREATE
TABLE
#tmpguid
(
id
UNIQUEIDENTIFIER
)
WHILE
(
@CNT
<
100
)
BEGIN
INSERT
INTO
#tmpguid
(
id
)
VALUES
(
Newid
(
)
)
SET
@CNT
=
@CNT
+
1
END
SELECT
*
FROM
#tmpguid
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)