Questions - QStack.ai

10

views

1

answer

no

votes

2022-05-15 03:00:00 +0000 huitzilopochtli

How can T-SQL Data Table that uses NUMERIC(18,6) Data Type display only zeroes after the decimal point, maintaining decimal precision?

t-sql
sql

14

views

1

answer

4

votes

2021-07-26 01:00:00 +0000 devzero

How can non-alphanumeric characters be removed from T-SQL?

sql
t-sql

11

views

1

answer

4

votes

2021-11-29 00:00:00 +0000 qstack

How can the output of an SQL query be assigned to a variable in TSQL?

t-sql
sql

11

views

1

answer

2

votes

2021-11-02 13:00:00 +0000 david

What is the method in T-SQL for combining two concrete tables?

12

views

1

answer

3

votes

2022-06-20 10:00:00 +0000 nofretete

What is the T-SQL query to obtain the name and state (Primary or Secondary) of a Windows Server Failover Cluster node?

t-sql
sql

14

views

1

answer

4

votes

2023-05-18 06:38:02 +0000 ladyg

What is the process for configuring a Microsoft SQL Server API to receive REST requests and deliver JSON responses?

11

views

1

answer

3

votes

2023-06-24 03:47:01 +0000 ladyg

How do I delete the final character from a string using T-SQL?

sql
t-sql

13

views

1

answer

1

vote

2023-06-27 18:00:02 +0000 woof

What is the reason for the syntax error during the compilation of a PL/SQL procedure caused by the presence of BEGIN TRY and END CATCH statements?

11

views

1

answer

3

votes

2023-07-09 14:56:02 +0000 djk

What is the unusual behavior of a SQL Server and T-SQL when dealing with a multi-value INSERT INTO statement and a sql_variant type column?

sql
t-sql

15

views

1

answer

1

vote

2023-07-11 00:54:01 +0000 qstack

How can SSMS highlight the identical literals when selecting a string in a script?

15

views

1

answer

2

votes

2023-07-19 03:25:02 +0000 qstack

What is the DAX equivalent of the T-SQL function AVG OVER(PARTITION BY)?

sql
t-sql

11 questions

How can T-SQL Data Table that uses NUMERIC(18,6) Data Type display only zeroes after the decimal point, maintaining decimal precision?

How can non-alphanumeric characters be removed from T-SQL?

How can the output of an SQL query be assigned to a variable in TSQL?

What is the method in T-SQL for combining two concrete tables?

What is the T-SQL query to obtain the name and state (Primary or Secondary) of a Windows Server Failover Cluster node?

What is the process for configuring a Microsoft SQL Server API to receive REST requests and deliver JSON responses?

How do I delete the final character from a string using T-SQL?

What is the reason for the syntax error during the compilation of a PL/SQL procedure caused by the presence of BEGIN TRY and END CATCH statements?

What is the unusual behavior of a SQL Server and T-SQL when dealing with a multi-value INSERT INTO statement and a sql_variant type column?

How can SSMS highlight the identical literals when selecting a string in a script?

What is the DAX equivalent of the T-SQL function AVG OVER(PARTITION BY)?

Contributors

Tags