Developer technologies Transact-SQL

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 830

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 127.4K 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) 2,215 Microsoft External Staff

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://free.blessedness.top/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

4 answers

How to debug SP procedure from SSMS

My sql server database is Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) i want to…

asked

Sudip Bhatt 2,281

commented

Tahir Nawaz 0

4 answers

Calculating Elapsed Time From Start & End Time

Hi, Running SQL Server 2008 R2. I have the following sample table: CREATE TABLE [dbo].[Test] ( [Test_ID] [int] NOT NULL, [Start_Time] [char](5) NULL, [End_Time] [char](5) NULL, [Elapsed_Time] [char](5) NULL, CONSTRAINT …

asked

VDT-7677 171

commented

Husayn Lipkin 0

3 answers

SQL Server: query performance

I would like to write a fast query returning the data that the following query returns: SELECT M,COmb,Mod,Loc,Initial, Final,Kms_,R,Franq,Num_Fleet,Pneus,Cli,Active,Interv, Cost1,Cost2,Name,Colab_Cod,col.colName FROM tFleetCars AS v OUTER APPLY ( …

asked

JDias 161

commented

Erland Sommarskog 127.4K MVP Volunteer Moderator

5 answers

Performance of View with where clause

I have a table say employee(employeeid,employeename,salary,dateofbirth) which has around 1M+ records.. now i have created a view as below (i) create view vw_emp as select * from employee my question is:- what is the impact of performance if i…

asked

Chitra Swaroop 1

commented

Jeff Moden 11

4 answers

Error handler would not be running in case of sequence error

Group Because leaving my sequence name incorrect ( sqc_LogReplic_tmpx ) it would not be entering the error handling routine. And adjusting to the correct name ( sqc_LogReplic_tmp ) and the routine executing the division by 0 instruction would…

asked

Claudinei Aparecido da Silva 41

accepted

Claudinei Aparecido da Silva 41

6 answers

which is best for performance filtering on where or filtering on join ?

I work on sql server 2019 i don't know which is best for performance filtering on where condition or filtering on join with another meaning which is best first query select A.* from A inner join B on A.ID=B.ID INNER JOIN C ON C.ID=B.ID …

asked

ahmed salah 3,216

commented

Mark Ferguson 0

3 answers

Transaction Log Cannot Be Truncated After Memory-Optimized Filegroup Removal

Hello there, One of our clients is facing an issue with a database where the memory-optimized filegroup was forcibly removed using DBCC CHECKDB (test, REPAIR_ALLOW_DATA_LOSS). The database remains functional, but the transaction log continues to grow and…

asked

kedar giri 81

edited a comment

Palm Plumb 0

2 answers

unable to import data into SSMS

HI Team, Am unable to import data into SSMS from network location. ERROR: TITLE: SQL Server Import and Export Wizard The operation could not be completed. ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local…

asked

Damodara Kuntrapaku 0

answered

Erland Sommarskog 127.4K MVP Volunteer Moderator

Developer technologies | Transact-SQL

Filter

Content

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

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

How to debug SP procedure from SSMS

Calculating Elapsed Time From Start & End Time

SQL Server: query performance

Performance of View with where clause

Error handler would not be running in case of sequence error

which is best for performance filtering on where or filtering on join ?

Transaction Log Cannot Be Truncated After Memory-Optimized Filegroup Removal

unable to import data into SSMS