User Razvan Socol

62 votes

Accepted

Create nested JSON arrays using FOR JSON PATH

answered Dec 17, 2017 at 11:26

18 votes

image data types are invalid for local variables (using openrowset cannot make it work)

answered Mar 28, 2014 at 6:13

15 votes

Accepted

FOR JSON PATH results in SSMS truncated to 2033 characters

answered Mar 3, 2019 at 20:57

10 votes

How to check if the last line in a text box has only one word?

answered Feb 25, 2018 at 11:49

7 votes

T-SQL Contains Search and German Umlaut on SQL Server 2008 R2

answered Dec 22, 2012 at 17:54

7 votes

Visual Studio No Symbols have been loaded for this document

answered Oct 3, 2014 at 7:34

7 votes

Unable to open Tabular project file in Visual Studio

answered Jul 11, 2020 at 4:57

6 votes

Accepted

Return next 10 days including weekday name

answered Jan 16, 2020 at 0:19

5 votes

Accepted

Optimized approach for calculating cosine similarity in SQL Server

answered Jun 29, 2021 at 4:51

5 votes

Accepted

T-SQL Json_modify function

answered Jan 16, 2019 at 20:38

5 votes

Accepted

Suppress result sets from trigger

answered Jun 15, 2015 at 4:20

4 votes

How to get the database name from a sys.all_objects consult

answered Aug 29, 2015 at 9:31

4 votes

How to add custom attributes to SQL connection string?

answered Aug 30, 2014 at 13:00

4 votes

Accepted

Transact-SQL ISJSON function doesn't accept scalars?

answered Jul 4, 2019 at 16:53

4 votes

Oracle SQL Is there a way to find intersections of data sets stored in same table when number of data sets are dynamic

answered Jul 4, 2019 at 5:36

4 votes

Accepted

Invalid column name of temp table

answered Jun 17, 2019 at 18:27

4 votes

Accepted

Convert Month Days Into Weekdays Per Week In SQL

answered Aug 8, 2021 at 10:28

3 votes

What is the memory footprint of a Nullable<T>

answered Feb 28, 2019 at 6:11

3 votes

Accepted

Why ROUND() function adding too many trailing zeros

answered Jun 10 at 4:31

3 votes

Sql - Stored Procedure with multiple if condition

answered May 10, 2023 at 18:11

3 votes

Conversion failed when converting the value '' to data type **

answered Jun 24, 2020 at 14:22

3 votes

How can I search for stored procedures executing other stored procedures?

answered Apr 4, 2019 at 0:33

3 votes

Accepted

Find/create correct enddate for series of tracking records

answered Jun 26, 2015 at 8:30

3 votes

How to simulate count distinct in an indexed view?

answered Jul 4, 2015 at 16:45

3 votes

Accepted

See if multiple entries exist in another table

answered May 14, 2015 at 15:44

3 votes

Accepted

SQL Execute AS userA vs Login as userA

answered Jan 20, 2018 at 10:47

3 votes

Accepted

Concatenate two columns conditionally

answered Feb 7, 2018 at 21:25

3 votes

Accepted

How to stop the execution of a cursor without leaving the result in warnings or errors?

answered Aug 25, 2015 at 6:39

2 votes

Accepted

Can LIKE @Pattern+'%' impose SQL Injection risk?

answered Oct 20, 2016 at 18:08

2 votes

Accepted

Is it possible to obtain information about a trigger within the trigger execution?

answered Sep 20, 2016 at 19:04

Collectives™ on Stack Overflow

275 Answers

Create nested JSON arrays using FOR JSON PATH

image data types are invalid for local variables (using openrowset cannot make it work)

FOR JSON PATH results in SSMS truncated to 2033 characters

How to check if the last line in a text box has only one word?

T-SQL Contains Search and German Umlaut on SQL Server 2008 R2

Visual Studio No Symbols have been loaded for this document

Unable to open Tabular project file in Visual Studio

Return next 10 days including weekday name

Optimized approach for calculating cosine similarity in SQL Server

T-SQL Json_modify function

Suppress result sets from trigger

How to get the database name from a sys.all_objects consult

How to add custom attributes to SQL connection string?

Transact-SQL ISJSON function doesn't accept scalars?

Oracle SQL Is there a way to find intersections of data sets stored in same table when number of data sets are dynamic

Invalid column name of temp table

Convert Month Days Into Weekdays Per Week In SQL

What is the memory footprint of a Nullable<T>

Why ROUND() function adding too many trailing zeros

Sql - Stored Procedure with multiple if condition

Conversion failed when converting the value '' to data type **

How can I search for stored procedures executing other stored procedures?

Find/create correct enddate for series of tracking records

How to simulate count distinct in an indexed view?

See if multiple entries exist in another table

SQL Execute AS userA vs Login as userA

Concatenate two columns conditionally

How to stop the execution of a cursor without leaving the result in warnings or errors?

Can LIKE @Pattern+'%' impose SQL Injection risk?

Is it possible to obtain information about a trigger within the trigger execution?