SQL Server @@ROWCOUNT and Hierarchyid Example (MSSQLTips 07/23/2019)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( data provisioning&utm_campaign=sqlprovision&utm_term=email-26805 [Test data provisioning whitepaper - Compare test data provisioning approaches. Get the free whitepaper.]( data provisioning&utm_campaign=sqlprovision&utm_term=email-26805) [How to use @@ROWCOUNT in SQL Server]( In this tip we look at how to use the SQL Server @@ROWCOUNT system variable and things you should know about its usage.... [SQL Server Hierarchyid Example for Bill of Materials]( This tip leverages a prior tip introducing the hierarchyid data type with examples for creating and querying a bill of materials table with hierarchyid values.... [Moving your SQL Server 2008/2008 R2 to Azure - Everything Enterprises Need to Know!]( [Webcast] Support for SQL Server 2008 and 2008 R2 ends July 9th. What does that mean for your Enterprise workloads? Attend this webcast to learn what steps you can take to keep your systems running.... [Tutorial - Machine Learning with SQL Server 2017 and R]( In this tutorial, we will learn the basics of machine learning where we will learn the necessary data science to examine data in relevance to machine learning model development. We will be using R in SQL Server 2017 to apply machine learning related ... [High Performance SANLess SQL Server Cluster]( Making SQL Server deployments resilient to failures is a goal most want to achieve. Whether you are trying to account for high availability and/or disaster recovery, there are various methods to achieve the end goal. One of the most popular approache... data provisioning&utm_campaign=sqlprovision&utm_term=email-26805 data provisioning&utm_campaign=sqlprovision&utm_term=email_content-26806 Test data provisioning for development – free whitepaper Compare the most common approaches to provisioning test data to database development teams and see how they stack up. Learn why traditional approaches like restore from backup are no longer suitable, and how successful organizations are implementing a combined data masking and data virtualization approach. [Get this free whitepaper now]( data provisioning&utm_campaign=sqlprovision&utm_term=email_content-26806) [Installing SQL Server 2017 Express]( Learn the step by step process for all three options (Basic, Media Download and Custom) to install SQL Server Express.... [SQL Server 2016 STRING_SPLIT Function]( During your experience as a SQL Server Database Administrator, you may work with applications that store data as comma-separated values in a single column. To deal with this de-normalized data, you may need to normalize it to work with each single value s... [Using SFTP with SQL Server Integration Services]( My client has hired a vendor for a telemarketing project and they need to send us the collected data. The solution we came up with is to use SFTP to get the files from the vendor and also use SQL Server Integration Services to load the data to the databas... [Twitter]( [Facebook]( [LinkedIn]( You are receiving this as a subscriber of MSSQLTips.com. If you wish to discontinue receiving email, please send us an email to [unsubscribe](mailto:unsubscribe@mssqltips.com?subject=UNSUBSCRIBE). Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}