Click here to Skip to main content

Questions

T-SQL
Questions

1

answer

Can make query below take less time this when run on SQL server 2012 ?

14-Jun-21 0:54am - updated 14-Jun-21 3:56am

SQL-Server-2008

1

answer

How to using alternative solution of like ?

11-Jun-21 1:30am - updated 12-Sep-22 0:55am

SQL-Server-2008R2

1

answer

Database design for monthly payments

27-Apr-21 14:54pm - updated 28-Apr-21 8:25am

1

answer

How to arrange featurename of comptitor first then npx feature name second based on displayorder?

14-Apr-21 18:09pm - updated 21-Apr-21 6:09am

stored-procedure

1

answer

How to avoid duplicates in XML while inserting into SQL table

24-Mar-21 3:49am - updated 24-Mar-21 7:10am

SQL-Server-2012

2

answers

When search on long text on table have 40 milion rows it is very slow so what I do ?

20-Feb-21 12:22pm - updated 20-Feb-21 15:02pm

stored-procedure

1

answer

I get error the multi-part identifier "rhst.name" could not be bound.?

18-Feb-21 0:26am - updated 18-Feb-21 1:12am

stored-procedure

1

answer

Find different procedure amount on the same date

4-Feb-21 1:14am - updated 4-Feb-21 1:37am

SQL-Server-2016

1

answer

Why json string values are missing when passed as parameter of stored procedure from efcore?

3-Feb-21 5:34am - updated 3-Feb-21 5:43am

1

answer

How to remove multiple characters between 2 special characters in a column in SSIS/SQL

12-Jan-21 0:46am - updated 12-Jan-21 2:13am

0

answers

Problem testing history of temporal table using tsqlt framwork

26-Nov-20 10:21am

1

answer

Solvedwhat am I missing …the current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction

23-Nov-20 0:57am - updated 23-Nov-20 19:03pm

SQL-Server-2012

1

answer

When update data on temparts table mass value changed after float point ?

7-Nov-20 8:06am - updated 8-Nov-20 23:44pm

SQL-Server-2012

, +

0

answers

Optimize XML record updates in SQL server

3-Oct-20 4:57am - updated 5-Oct-20 3:51am

0

answers

Can anyone help me with code optimization on my T-SQL 2K16 query?

14-Sep-20 21:07pm - updated 14-Sep-20 21:12pm

2

answers

MS SQL GROUP by clause required all the attributes

23-Aug-20 21:50pm - updated 23-Aug-20 23:07pm

1

answer

How to store multiples values to a column using SET?

16-Jul-20 8:34am - updated 16-Jul-20 21:48pm

SQL-server-2000

SQL-Server-2005

, +

1

answer

How to fill out the second column accordint to the string in the first column using while

7-Jul-20 1:19am - updated 7-Jul-20 1:37am

SQL-Server-2016

1

answer

T-SQL equivalent to solr

26-Jun-20 21:27pm - updated 26-Jun-20 22:34pm

2

answers

Store procedure not retern value

20-May-20 2:23am - updated 20-May-20 5:57am

To narrow down your search try filtering by tags using the Filter box at the top right.

Interested
Ignored

Last 24hrs

This month

Pete O'Hanlon	95
Dave Kreskowiak	50
Richard MacCutchan	45
Daniel Pfeffer	40
OriginalGriff	38

Pete O'Hanlon	2,305
OriginalGriff	1,683
Graeme_Grant	1,150
Richard Deeming	893
Dave Kreskowiak	839