tsql Image

tsql

question
Jad2SQL avatar image
Jad2SQL edited Default

how not to update/insert sql table with null/blank value

tsql database datawarehouse

0 Likes

0Answers

0 Comments

question
mooriginal avatar image
mooriginal answered Default

Insert causing blocking SQL2012

tsql sqlserver2012 blocking

This question has an accepted answer. Accepted

0 Likes

4Answers

0 Comments

question
AmeshJeram avatar image
AmeshJeram asked Default

grouping rows using t-sql when other columns are blank

tsql sql query mssql grouping

0 Likes

0Answers

0 Comments

question
mooriginal avatar image
mooriginal answered Default

Tsql batch script does not stop executing

tsql code mssql2012

This question has an accepted answer. Accepted

0 Likes

4Answers

0 Comments

question
kenb_SQL avatar image
kenb_SQL asked Default

Parsing XML Column in Table With Dynamic Number of Elements

tsql xml parse

0 Likes

0Answers

0 Comments

question
Kev Riley avatar image
Kev Riley answered Default

Why case..when get a table scan ? how to workarround ?

tsql sql server 2017

0 Likes

1Answer

0 Comments

question
Jeff Moden avatar image
Jeff Moden answered Default

How to replace below cursor code to any other method

tsql sqlserver

0 Likes

1Answer

1 Comment

question
Jeff Moden avatar image
Jeff Moden answered Default

Does anyone use ON DELETE SET DEFAULT with their foreign key constraints?

tsql foreign-key constraints

0 Likes

1Answer

0 Comments

question
LearningToCode avatar image
LearningToCode asked Default

TSQL - How to return query results over two rows

t-sql tsql

0 Likes

0Answers

0 Comments

question
Jeff Moden avatar image
Jeff Moden commented Default

Get the correct workday based on a table of valid business day

tsql table

0 Likes

0Answers

1 Comment

question
EdMcD avatar image
EdMcD asked Default

When modifying xml using XML.MODIFY how do you add namespace to a sql:variable

tsql xml sql xml

0 Likes

0Answers

0 Comments

question
vickyarea51 avatar image
vickyarea51 answered Default

Long running transaction alert configuration

tsql alerts

This question has an accepted answer. Accepted

0 Likes

2Answers

0 Comments

question
BUD avatar image
BUD published Default

Removing white space/line breaks from string

tsql sql2014

0 Likes

1Answer

7 Comments

question
Dnirmania avatar image
Dnirmania edited Default

Im trying to write a code that can change endpoint AG owner DB owner and delete that login. Can anyone help me with what's wrong in this code

tsql

0 Likes

1Answer

0 Comments

question
BHVSVASU avatar image
BHVSVASU asked Default

Recursive CTE

tsql performance cte recursion

0 Likes

0Answers

0 Comments

484 Posts
262 Users
0 Followers

Topic Experts

joe_justguessing avatar image
joe_justguessing
0 Points
SQLArnold avatar image
SQLArnold
0 Points