Tag Archives: sql server 2012

Difference between NEWID() and NEWSEQUENTIALID() in SQL Server

Difference between NEWID() and NEWSEQUENTIALID() in SQL Server Both NEWID() and NEWSEQUENTIALID() are used to generate GUID of data type UNIQUEIDENTIFIER in SQL Server. The Basic difference between them is NEWID() generates GUID’s in random order whereas NEWSEQUENTIALID()  generates GUID’s … Continue reading

Posted in SQL Development | Tagged , , , , , , , , , , , , , | Leave a comment

Difference between CHARINDEX and PATINDEX

Difference between CHARINDEX and PATINDEX CHARINDEX: It is a string function which returns the starting position of a pattern. PATINDEX: It is a string function which returns the starting position of a pattern. We can also use wildcard characters in … Continue reading

Posted in SQL Development | Tagged , , , , , , , , | Leave a comment

Conversion functions in SQL Server 2012

Conversion functions  in SQL Server 2012   Before starting with “Conversion functions in SQL Server 2012” we’ll have a look into “Why data conversion needed?” Does SQL Server can’t do it automatically? Yes! SQL server can do data conversion internally … Continue reading

Posted in SQL Development | Tagged , , , , , , , , , | Leave a comment