The sp_execute_external_script system stored procedure is the stored procedure which invokes the external environment to run an external script (either Python or R ) in a T-SQL script. This is quite highlights of the sp_execute_external_script stored and some short notes on it. let’s quickly look at the structure of the stored procedure sp_execute_external_script @language = N’language,…
Sometimes, you would want to split values in a column into separate rows in SQL server. This is a simple guide. Lets check the fields in the table we will be working with. select [orderID] ,[itemType] ,[price] ,[quantity] from [Antrak].[dbo].[ClothingSale] Let’s check the result: We can see that the itemType field has different values…
I receive a lot of emails about where to get quick and excellent resources for explaining most of the concepts of Transact-SQL (T SQL) and Microsoft SQL Server in general What is Transact-SQL or T SQL. T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query…
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs
No products in the cart.