Regarding Varbinary Convertion in sql
HiI have one column with varbinary datatype
in sql server and i inserted guid in my varbinary data type column
how to reverse value after insert sql server or c# how will get this value.
DECLARE @temp TABLE
(
ID INT IDENTITY(1,1)
, Case_YourName NVARCHAR(50)
, Case_Description NVARCHAR(50)
)
INSERT INTO @temp (Case_YourName, Case_Description)
VALUES
('Phagu Mahato ', 'Will Management'),
UPDATE @temp
SET Case_YourName = SUBSTRING(Case_YourName, CHARINDEX(' ', Case_YourName), LEN(Case_YourName)) + ' ' + SUBSTRING(Case_YourName, 1, CHARINDEX(' ', Case_YoorName))
SELECT * FROM @temp
INSERT Mytable (col1, col2) OUTPUT INSERTED.IDCol VALUES (@param1, @param2);
CREATE FUNCTION STRTOUID()
{
DECLARE @guid VARCHAR(50)
SET @guid = 'a89b1acd95016ae6b9c8aabb07da2010'
SELECT CAST(
SUBSTRING(@guid, 1, 8) + '-' + SUBSTRING(@guid, 9, 4) + '-' + SUBSTRING(@guid, 13, 4) + '-' +
SUBSTRING(@guid, 17, 4) + '-' + SUBSTRING(@guid, 21, 12)
AS UNIQUEIDENTIFIER)
}