F
F
Fyodor2016-11-01 12:54:59
SQL Server
Fyodor, 2016-11-01 12:54:59

MSSQL - what is the guid number?

2008 version.
I pick the table, in two tables there is a field guid uniqueidentifier type which it is not clear to me as are filled. values ​​look like this
{F607EFA1-FB80-43D6-8DB7-00008AF950CB}
How can these things be formed and what are they used for? in transactions? how to form them? Simply inserting a row into a table does nothing, i.e. field is not generated automatically.
I don't see anything in the procedures either. the code itself that forms the records cannot be viewed. You need to figure it out in order to add a new record, I'm not strong in MSSQL, what if this is some kind of obvious thing?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Artyom Karetnikov, 2016-11-01
@Richard_Ferlow

Right click on the table. Then fields. Stand on the right one, and see what kind of function it is formed (although it is already written which one) - and if it is there, then do not worry about the uniqueness, it will form itself.
If there is no default value, then this field is filled from the procedure / function when inserting a replacement. Where - it is necessary to search.
The code that generates the records, why can't you suddenly look at it? The profiler can't be started, right?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question