Developer technologies Transact-SQL

10 answers

Microsoft SQL Server Studio - Dark Mode

Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?

asked

Kıvanç ÖZDEMİR 135

commented

Bryan Diercks 6

4 answers

Invalid object name 'STRING_SPLIT' in SQL Server 2019

Hi Support, Our SQL server version is 2019 and check the compatibility level is 150, but it still have error "Invalid object name 'STRING_SPLIT' ". We also tried the case sensitive according to this link, both of them have the same error. …

asked

Andy Chong 892

edited an answer

Randy Kroeger 0

1 answer

Can I join Developer program?

Hi, I would like to join developer program and be able to learn and test.

asked

Mohammed Arshad 0

answered

Q&A Assist

3 answers

Add Headers To BCP Export

I am using SQL Server 2016, and I am exporting data using BCP. I need the headers exported as well. I saw an example where I could do bcp "Select ''Field1'', ''Field2'', ''Field3'' UNION ALL Select CHAR(34) + Convert(varchar(10), field1,…

asked

Johnathan Simpson 586

commented

rferraton 0

3 answers

fast farward curson vs while loop on @table

hi, need to known weather fast farwand cursor is faster than a while loop made on @table variable haveing less than 15 rows that means 15 iteration. pls tell me which one is faster.

asked

Rajesh Kumar Yadav 20

commented

Erland Sommarskog 128.6K MVP Volunteer Moderator

5 answers

Export data from Excel to MS SQL Server

Hi, We have an excel that stores data in it. Some forms are created inside it that are not tabular in structure. So we can consider excel sheets act as individual pages as in any website. now we need to pull data from excel into database. I…

asked

Ravi Kumar 1

answered

Ramana Kopparapu 306

1 answer

How to trap errors in Agent Job execution

I have an agent job with several steps, each step executing a stored proc. A few times each year, when a step EXEC takes place, there's no response, the proc doesn't run at all, and the step quits upon failure. I have error checking in the proc, but I…

asked

Corey Fleig 160

commented

Corey Fleig 160

2 answers

Convert 14 Char String to Datetime

I have a field in a table called TraceID that stores data like this: 2024040611102200021 The first 8 characters represent the date (YYYYMMDD). The next 6 characters represent the time (HHMMSS). The last five are insignificant numbers. So this would be…

asked

Dom 951

answered

Ramana Kopparapu 306

3 answers

Preventing Database Deletion in SSMS

prevent accidental database deletions within SQL Server Management Studio (SSMS). Currently, I am exploring options to enforce this restriction effectively implemented a DDL trigger Is the above DDL trigger approach appropriate for preventing…

asked

Niket Kumar Singh 835

answered

Ramana Kopparapu 306

4 answers

MERGE Statement results in a Cannot insert duplicate key in object

So we have a MERGE Statement that looks as though it should do the INSERT on NOT MATCHED and the UPDATE on MATCHED correctly. However when processing for some reason it seems to be falling into the NOT MATCHED INSERT portion of the MERGE rather than the…

asked

Bobby P 231

commented

Erland Sommarskog 128.6K MVP Volunteer Moderator

2 answers

can the ROW_NUMBER() function be used without the PARTITION clause?

I'd like to get row numbers for my output without having to use ROW_NUMBER() OVER(PARTITION BY ...). Is this possible, and can you provide an example?

asked

Gil Robinson 0

answered

Ramana Kopparapu 306

3 answers

how to calculate age from date of birth

im required to come up with a script for a solution where you need both peoples date of birth, and age, when registering them its clearly stated that the person wont be asked to input their age, just their dob. but the age is needed what needs to be…

asked

ganeplay506 1

commented

Ramana Kopparapu 306

1 answer

SSIS using Kingswaysoft

Hi Team, I want to do the On prem CRM migration from 8.1 to 9.1 where we have a 9 TB SQL data which is the big challange for us. Someone suggested to do this using Kingswaysoft tool which handles a large data migration. Could you please provide us…

asked

Sachin Joshi 0

edited the question

Rekha 0 Microsoft External Staff Moderator

3 answers

How can convert decimal value into time format as its

How can change to decimal values in to time format as it is without any change in values declare @intime decimal (10,2) = 7.50 declare @intime1 decimal (10,2) = 17.50 declare @breakhrs decimal (10,2) = .45 declare @breakhrs decimal (10,2) = 1.00 …

asked

Polachan Paily 226

edited an answer

bruce 0

2 answers

sp_prepare and sp_execute vs sp_executesql

I have noticed sp_executesql also makes a single plan for a stmt when a stmt is calle in a loop. Generally plan is evicted from cache from first in first out or usage basis.so if i use sp_executesql then i should be fine in a loop in stored procedure…

asked

rajesh yadav 291

commented

Raymond Huynh (WICLOUD CORPORATION) 3,645 Microsoft External Staff Moderator

3 answers

MSDN forum directs me to here

Hello all, I go to this link: https://social.msdn.microsoft.com/Forums/en-US/home and it directs me to : https://learn.microsoft.com/en-us/answers/questions/ask.html?WT.mc_id=msdnredirect-web-msdn Does anyone know what the reason is? …

asked

CouldsInSky 41

commented

Jackson Wordan 0

4 answers

Looking for SQL Server 2019 Architecture Diagram

I am looking for an Architecture Diagram for SQL Server 2019. Can someone point me to a web site? I cannot find anything current.

asked

LCerni 1

answered

long pham 0

2 answers

Why there are null values in stop_execution_date column of msdb.dbo.sysjobactivity table

Hello, We are using below code to identify and stop running SQL Server Agent jobs. SELECT 1 FROM msdb.dbo.sysjobs_view job INNER JOIN msdb.dbo.sysjobactivity activity ON (job.job_id = activity.job_id) …

asked

anil kumar 1,646

commented

BORDIER Stephane 0

3 answers

Stored Procedure not executing as SQL Agent Job

I have a stored procedure (1) that updates JSON data (via JSON_Modify()) in an auditing table to replace raw binary with a short string 'Binary column data.'. This stored procedure functions when executed in SSMS, but when I try to have a SQL Agent Job…

asked

Bryan Lee Briggs 1

answered

Don Price 0

4 answers

IF EXIST UPDATE, IF NOT EXIST INSERT

Hi, i want to know how update a row if exist and if don't exist insert a new row Example:

asked

EvansGxz 1

answered

Victor Garret 0

Developer technologies | Transact-SQL

Filter

Content

4,713 questions with Developer technologies | Transact-SQL tags

Microsoft SQL Server Studio - Dark Mode

Invalid object name 'STRING_SPLIT' in SQL Server 2019

Can I join Developer program?

Add Headers To BCP Export

fast farward curson vs while loop on @table

Export data from Excel to MS SQL Server

How to trap errors in Agent Job execution

Convert 14 Char String to Datetime

Preventing Database Deletion in SSMS

MERGE Statement results in a Cannot insert duplicate key in object

can the ROW_NUMBER() function be used without the PARTITION clause?

how to calculate age from date of birth

SSIS using Kingswaysoft

How can convert decimal value into time format as its

sp_prepare and sp_execute vs sp_executesql

MSDN forum directs me to here

Looking for SQL Server 2019 Architecture Diagram

Why there are null values in stop_execution_date column of msdb.dbo.sysjobactivity table

Stored Procedure not executing as SQL Agent Job

IF EXIST UPDATE, IF NOT EXIST INSERT