T-SQL R language - return fewer columns
I'm running an R language script under T-SQL where I use REGEX to validate data in two columns. However I only want to output the id column in my result set. My script is: EXECUTE sp_execute_external_script @language = N'R', @script = N' pattern =…
sqlpackage export data
Is it possible to export data only of all the tables in the DB using sqlpackage export action? Schema is not to be included in the .bacpac file.
![](https://techprofile.blob.core.windows.net/images/YC3KiAudCk6A0I6NB9vOyA.png?8DA953)
How to do the bulk insert of one lack records in sql server using node js
Hi, I will store the data in following Json format. Now I want to insert this one lack. records in sql server. Kindly Please provide the best solution and if it's possible share your solution with sql query. [ { key: value, key: value, key: value, key:…
![](https://techprofile.blob.core.windows.net/images/KhnRGP5_AwAAAAAAAAAAAA.png?8DBA61)
Tempdb Shrink Issue in SQL Server
Dear Support Team, I need your consultancy regarding this issue: After shrinking the tempdb in Microsoft sql management studio the tempdb does not shrink and the disk size is not reclaimed even though the db is not being used only works after a restart…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
Could Cross Apply be used in this query?
Here is a demo of my actual table: create table #demo (ID int, ItemID int, QTY int) insert into #demo values (1,101,3),(2,102,1),(3,101,4),(4,102,2),(5,103,3) I have written a query: SELECT t2.ID,t2.QTY,t2.ItemID,t1.TotalQTY FROM (SELECT ItemId,SUM(QTY)…
SQL server 2022
Hi I just installed SQL 2022 Enterprise with trial Now I want to install SQl 2022 standard edition, so Can I backup SQL 2022 Enterprise server DB back up and Restore it to SQL 2022 Standard edition?
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)