Click here to Skip to main content

Questions

T-SQL
Questions

1

answer

ROLLBACK transaction in trigger

17-Sep-19 4:29am - updated 16-May-20 6:10am

1

answer

How make select run faster for a table with 120 columns

4-Nov-19 0:06am - updated 4-Nov-19 2:17am

2

answers

How do i...read all files in a directory

13-Nov-19 22:26pm - updated 14-Nov-19 2:47am

1

answer

Error at rollback transaction line

6-Dec-19 1:11am - updated 6-Dec-19 1:57am

1

answer

Sql server - avoid cursor while serial update

24-Jan-20 3:00am - updated 24-Jan-20 4:29am

, +

3

answers

What causes this error?

11-Feb-20 3:03am - updated 11-Feb-20 10:35am

1

answer

How to convert MS access IFF statement to SQL server query..any help will be really appreciated.

21-Feb-20 9:20am - updated 21-Feb-20 10:42am

1

answer

Joining 4 table in order to produce one master table

20-Apr-20 11:00am - updated 21-Apr-20 2:52am

1

answer

Sql CTE recursive or cursor ?

30-Apr-20 4:48am - updated 30-Apr-20 6:01am

1

answer

Merge data in two rows in SQL server

11-May-20 17:02pm - updated 11-May-20 22:34pm

2

answers

Store procedure not retern value

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

1

answer

T-SQL equivalent to solr

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

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

2

answers

MS SQL GROUP by clause required all the attributes

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

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

0

answers

Optimize XML record updates in SQL server

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

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

, +

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

0

answers

Problem testing history of temporal table using tsqlt framwork

26-Nov-20 10:21am

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

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

Interested
Ignored

Last 24hrs

This month

OriginalGriff	100
Dave Kreskowiak	90
Richard Deeming	80
Pete O'Hanlon	70
M-Badger	30

Pete O'Hanlon	1,185
OriginalGriff	977
Richard MacCutchan	305
Dave Kreskowiak	280
merano99	180