With years of experience in C# development and SQL database management, I'm here to share insights, tips, and best practices to help you level up your skills.
📚 What You'll Find Here:
🔹 C# Mastery:
🔹 SQL Essentials
🔹 Best Practices
🔹 Real-World Projects
How to generate random numbers in sql server
Get link
Facebook
X
Pinterest
Email
Other Apps
SELECT RandomNumber = CONVERT(VARCHAR,ABS(CHECKSUM(NEWID())))
FROM master.dbo.spt_values
ORDER BY RandomNumber
DECLARE @ONERROR INT DECLARE @idoc INT declare @xmlData NTEXT set @xmlData ='some XML string ' EXEC sp_xml_preparedocument @idoc OUTPUT, @xmlData set @str = '//Sheet' + cast(@TopSheetID as varchar(50)) + '/WBProducts' Select * From OpenXML (@idoc,@str,3) WITH tblProcess
Comments
Post a Comment