http://www.sqlservercentral.com/scripts/split+string/117123/
The above script will split upto 256 char length only. This new version will split upto N length.
2016-09-14 (first published: 2014-10-30)
1,832 reads
This function is used to get the distance between 2 coordinates/latlong in the different formats
2016-09-13 (first published: 2014-10-31)
1,693 reads
This functions are used to convert integers/numbers into binary format and viceversa.
2016-09-09 (first published: 2014-11-18)
1,880 reads
This function is used to get the unused stored procedure list for which doesn't used for given noofdays.
2016-09-01 (first published: 2014-12-03)
3,336 reads
2016-07-26 (first published: 2014-11-20)
2,236 reads
This script is used to split the string using multiple delimiters
2016-05-18 (first published: 2014-10-09)
5,951 reads
This function is used to get the complete table lists are particular table and its last access datetime.
2016-03-07 (first published: 2014-11-03)
3,183 reads
This function is used to calculate the actual unit of conversion for velocity/speed.
2015-02-20 (first published: 2014-12-11)
549 reads
This function is used to calculate the actual unit of conversion for pressure.
2015-02-13 (first published: 2014-12-12)
552 reads
This function is used to calculate the actual unit of conversion for length.
2015-02-06 (first published: 2014-12-15)
827 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers