Sfrgttk

How does Dispel Magic work against Stoneskin?

Should we release the security issues we found in our product as CVE or we can just update those on weekly release notes?

Can the druid cantrip Thorn Whip really defeat a water weird this easily?

What is the definition of "Natural Selection"?

Should QA ask requirements to developers?

Is going from continuous data to categorical always wrong?

Latest web browser compatible with Windows 98

Is King K. Rool's down throw to up-special a true combo?

If the Captain's screens are out, does he switch seats with the co-pilot?

Plywood subfloor won't screw down in a trailer home

Is a lawful good "antagonist" effective?

Is it true that real estate prices mainly go up?

Gravity alteration as extermination tool viable?

Time dilation for a moving electronic clock

What is the probability somebody's birthday is the day before mine?

Unreachable code, but reachable with exception

What is the dot in “1.2.4."

Is this animal really missing?

Is having access to past exams cheating and, if yes, could it be proven just by a good grade?

When two POV characters meet

validation vs test vs training accuracy, which one to compare for claiming overfit?

How to deal with a cynical class?

Force user to remove USB token

Why does Deadpool say "You're welcome, Canada," after shooting Ryan Reynolds in the end credits?

Do SET Statements happen in order?

Sort order specified in primary key, yet sorting is executed on SELECTsp_executesql adds statements to executed dynamic script?Forcing Join Orderstoring arrays or images in a database tableUpdate a set of SQL statementsupdating the entire column with datetime values based on other values in the rowHowto transfer tracefile into a trace table without loosing the sort order?Investigating errors from strange queryStrange query plan when using OR in JOIN clause - Constant scan for every row in tableHow to identify columns order in a table, bis

0

Since I could not find it out here, do set statements happen in order scripted? Below is query I found. Would I get the same result every time it ran?

DECLARE @Num VARCHAR(10) = '10';

DECLARE @Cleaned VARCHAR(10);

SET @Cleaned = SUBSTRING(@Num, PATINDEX('%[^0]%', @Num+'.'), LEN(@Num));

SET @Cleaned = CASE

                   WHEN LEN(@Cleaned) > 3

                   THEN @Cleaned

                   ELSE RIGHT('00000'+@Cleaned, 3)

               END;

-- to be set up

SELECT @Num AS [before]

     , @Cleaned AS [After]

sql-server ssms best-practices

share

asked 1 min ago

EricEric

1

New contributor

Eric is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

Since I could not find it out here, do set statements happen in order scripted? Below is query I found. Would I get the same result every time it ran?

DECLARE @Num VARCHAR(10) = '10';

DECLARE @Cleaned VARCHAR(10);

SET @Cleaned = SUBSTRING(@Num, PATINDEX('%[^0]%', @Num+'.'), LEN(@Num));

SET @Cleaned = CASE

                   WHEN LEN(@Cleaned) > 3

                   THEN @Cleaned

                   ELSE RIGHT('00000'+@Cleaned, 3)

               END;

-- to be set up

SELECT @Num AS [before]

     , @Cleaned AS [After]

sql-server ssms best-practices

share

asked 1 min ago

EricEric

1

New contributor

Eric is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Since I could not find it out here, do set statements happen in order scripted? Below is query I found. Would I get the same result every time it ran?

DECLARE @Num VARCHAR(10) = '10';

DECLARE @Cleaned VARCHAR(10);

SET @Cleaned = SUBSTRING(@Num, PATINDEX('%[^0]%', @Num+'.'), LEN(@Num));

SET @Cleaned = CASE

                   WHEN LEN(@Cleaned) > 3

                   THEN @Cleaned

                   ELSE RIGHT('00000'+@Cleaned, 3)

               END;

-- to be set up

SELECT @Num AS [before]

     , @Cleaned AS [After]

sql-server ssms best-practices

share

asked 1 min ago

EricEric

1

New contributor

Eric is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

DECLARE @Num VARCHAR(10) = '10';

DECLARE @Cleaned VARCHAR(10);

SET @Cleaned = SUBSTRING(@Num, PATINDEX('%[^0]%', @Num+'.'), LEN(@Num));

SET @Cleaned = CASE

                   WHEN LEN(@Cleaned) > 3

                   THEN @Cleaned

                   ELSE RIGHT('00000'+@Cleaned, 3)

               END;

-- to be set up

SELECT @Num AS [before]

     , @Cleaned AS [After]

share

asked 1 min ago

EricEric

1

New contributor

Eric is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 1 min ago

EricEric

1

New contributor

Eric is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

EricEric

1

New contributor

Eric is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

EricEric

1