You’re correct that it cannot guarantee uniqueness, however there are approximately 3.402823669209387e+38 different values in a 32 digit hex value (16^32). That means that, assuming the math behind the algorithm gives a good distribution, your odds are phenomenally small that there will be a duplicate. You do have to keep in mind that it IS … Read more
Here’s a code snippet showing how to insert a GUID using a parameterised query: using(SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using(SqlTransaction trans = conn.BeginTransaction()) using (SqlCommand cmd = conn.CreateCommand()) { cmd.Transaction = trans; cmd.CommandText = @”INSERT INTO [MYTABLE] ([GuidValue]) VALUE @guidValue;”; cmd.Parameters.AddWithValue(“@guidValue”, Guid.NewGuid()); cmd.ExecuteNonQuery(); trans.Commit(); } }
How about the UUID of the root filesystem? You can get the root filesystem device from /etc/fstab, either by manually parsing the file or by using getfsent (3) or getfsfile (3). Once you have the device, you can get the UUID by either checking the links in /dev/disk/by-uuid or from the blkid command.
SELECT (sub)queries return result sets. So you need to use IN, not = in your WHERE clause. Additionally, as shown in this answer you cannot modify the same table from a subquery within the same query. However, you can either SELECT then DELETE in separate queries, or nest another subquery and alias the inner subquery … Read more
SessionStorage is per tab/window, so you can define a random number in sessionStorage and get it at first if exists: var tabID = sessionStorage.tabID ? sessionStorage.tabID : sessionStorage.tabID = Math.random(); UPDATE: In some cases, you may have same sessionStorage in multiple tab (e.g. when you duplicate tab). In that case, following code may help: var … Read more
DECLARE @uuid VARCHAR(50) SET @uuid = ‘a89b1acd95016ae6b9c8aabb07da2010’ SELECT CAST( SUBSTRING(@uuid, 1, 8) + ‘-‘ + SUBSTRING(@uuid, 9, 4) + ‘-‘ + SUBSTRING(@uuid, 13, 4) + ‘-‘ + SUBSTRING(@uuid, 17, 4) + ‘-‘ + SUBSTRING(@uuid, 21, 12) AS UNIQUEIDENTIFIER)
Are serial numbers of NFC tags truely unique? That depends on the tag product and what you consider truely unique. E.g.: ISO 14443 Type A tags with 4 byte serial numbers: There certainly exist duplicates (mainly because there is no clear scheme to divide the available range of serial numbers among the various manufacturers) and … Read more
In My case it was ibGoogleAnalytics_debug.a library. To find which library is using uniqueidentifier method, go to your project folder and type in: $ find . | grep -v .svn | grep “\.a” | grep -v “\.app” | xargs grep uniqueIdentifier I got this: Binary file ./My_Project/libGoogleAnalytics_debug.a matches
You can get the GUID back by using OUTPUT. This works when you’re inserting multiple records also. CREATE TABLE dbo.GuidPk ( ColGuid uniqueidentifier NOT NULL DEFAULT NewSequentialID(), Col2 int NOT NULL ) GO DECLARE @op TABLE ( ColGuid uniqueidentifier ) INSERT INTO dbo.GuidPk ( Col2 ) OUTPUT inserted.ColGuid INTO @op VALUES (1) SELECT * FROM … Read more
Check into this thread,. However you should be careful as it’s documented as “can change upon factory reset”. Use at your own risk, and it can be easily changed on a rooted phone. Also it appears as if some manufacturers have had issues with their phones having duplicate numbers thread. Depending on what your trying … Read more