User Muflix

32 votes

2 answers

571k views

Case with multiple conditions

asked Nov 12, 2014 at 14:59

11 votes

1 answer

55k views

Remove string after second specific character occures from left

asked Jan 16, 2015 at 13:13

8 votes

2 answers

18k views

CROSS APPLY on Scalar function

asked Apr 8, 2015 at 20:12

5 votes

1 answer

414 views

How to change default port for T-SQL Debugger

asked Feb 5, 2016 at 10:59

5 votes

1 answer

5k views

How to register CLR assembly as trusted in SSDT deployment

asked Oct 16, 2022 at 16:31

3 votes

1 answer

680 views

Cross database access with trustworthy on does not work for service account neither with certificate

asked Oct 18, 2022 at 21:33

3 votes

1 answer

225 views

sys.dm_exec_describe_first_result_set returns wrong data type

asked Sep 30, 2022 at 12:16

3 votes

1 answer

6k views

Query XML without namespace

asked Feb 12, 2016 at 11:32

3 votes

1 answer

2k views

CLR Procedure with XML parameter returns Data at the root level is invalid. Line 1, position 1

asked Feb 19, 2016 at 13:15

3 votes

2 answers

2k views

Moving database objects to another database without wizard

asked Jun 15, 2015 at 9:35

2 votes

1 answer

559 views

SMO Copy database or remove all non-system database objects

asked Dec 29, 2015 at 16:10

2 votes

1 answer

602 views

The Trustworthy option should be disabled but what is an alternative?

asked Sep 27, 2022 at 14:11

2 votes

1 answer

994 views

Unpivot columns based on select

asked Dec 17, 2016 at 18:06

1 vote

1 answer

2k views

database roles name convention [closed]

asked Oct 17, 2014 at 8:04

1 vote

1 answer

59 views

Merging almost unique rows together

asked Nov 17, 2014 at 16:36

1 vote

0 answers

257 views

Export hierarchy tree in a specific way

asked Nov 29, 2014 at 23:43

1 vote

1 answer

516 views

Simple SSIS Package Failed User does not exist or has not permission

asked Jul 3, 2015 at 12:22

1 vote

1 answer

481 views

dtsinstall.exe does not deploy packages

asked Aug 31, 2015 at 12:59

1 vote

2 answers

4k views

How to keep row ordering with DISTINCT command or how to add row number to cross apply

asked Dec 3, 2015 at 12:05

0 votes

1 answer

70 views

Columns into rows and rows into columns

asked Nov 16, 2014 at 9:31

0 votes

2 answers

2k views

Selecting rows with condition on two columns together

asked Aug 25, 2014 at 6:29

0 votes

1 answer

128 views

Select children from hierarchy (/a/b/c/d/)

asked Oct 9, 2014 at 14:39

0 votes

1 answer

2k views

Generate Schema and Data to SQL script and Run it on another DB programmatically

asked Dec 4, 2014 at 9:49

0 votes

3 answers

10k views

How to check if range between two numbers is available in table of ranges

asked May 4, 2016 at 14:00

0 votes

2 answers

37 views

text positioning for select list

asked May 16, 2016 at 10:37

0 votes

1 answer

1k views

SQLCMD is not working in pre-deployment script in sql project

asked Jul 19, 2016 at 11:32

0 votes

1 answer

4k views

declare table variable inside function

asked Aug 20, 2019 at 9:24

0 votes

1 answer

96 views

How to generate ER diagram for specific tables in MSDB

asked Jun 7, 2022 at 15:31

0 votes

1 answer

214 views

View or build create table schema statement programmatically with T-SQL [closed]

asked Sep 19, 2022 at 7:37

0 votes

0 answers

27 views

How to limit data transfer on the database level or account level [duplicate]

asked Jan 30 at 15:59

Stack Exchange Network

30 Questions

Case with multiple conditions

Remove string after second specific character occures from left

CROSS APPLY on Scalar function

How to change default port for T-SQL Debugger

How to register CLR assembly as trusted in SSDT deployment

Cross database access with trustworthy on does not work for service account neither with certificate

sys.dm_exec_describe_first_result_set returns wrong data type

Query XML without namespace

CLR Procedure with XML parameter returns Data at the root level is invalid. Line 1, position 1

Moving database objects to another database without wizard

SMO Copy database or remove all non-system database objects

The Trustworthy option should be disabled but what is an alternative?

Unpivot columns based on select

database roles name convention [closed]

Merging almost unique rows together

Export hierarchy tree in a specific way

Simple SSIS Package Failed User does not exist or has not permission

dtsinstall.exe does not deploy packages

How to keep row ordering with DISTINCT command or how to add row number to cross apply

Columns into rows and rows into columns

Selecting rows with condition on two columns together

Select children from hierarchy (/a/b/c/d/)

Generate Schema and Data to SQL script and Run it on another DB programmatically

How to check if range between two numbers is available in table of ranges

text positioning for select list

SQLCMD is not working in pre-deployment script in sql project

declare table variable inside function

How to generate ER diagram for specific tables in MSDB

View or build create table schema statement programmatically with T-SQL [closed]

How to limit data transfer on the database level or account level [duplicate]