12 questions with SQL Server Training tags

Sort by: Updated
Updated Created Answers
1 answer One of the answers was accepted by the question author.

is there a describe or show function in SQL server 2022?

I have a query in the SQL 2005 server we use for archive retrieval and a similar query in our 2019 box works with no issue. Declare @POnumber varchar(max) = '6801415970' SELECT * FROM dbo.SA15 WHERE PONO = /*'6801415970'*/ @POnumber SELECT * FROM…

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
12 questions
asked 2024-08-08T13:47:29.87+00:00
Jonathan Brotto 420 Reputation points
edited the question 2024-08-10T19:00:18.55+00:00
pnaroju 3,150 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

can I declare a variable after the query

I have a variable that is a list that I will split and but not anting to put it on top of the SQL file as I like to see my query before.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,476 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
114 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,690 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
12 questions
asked 2024-08-08T15:13:00.9633333+00:00
Jonathan Brotto 420 Reputation points
accepted 2024-08-09T14:24:15.3333333+00:00
Jonathan Brotto 420 Reputation points
1 answer One of the answers was accepted by the question author.

declare a variable with multiple items like an in for a where clause?

Is it possible to declare a variable with multiple items like an in for a where clause?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,476 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
114 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,690 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
12 questions
asked 2024-08-08T14:19:55.0666667+00:00
Jonathan Brotto 420 Reputation points
commented 2024-08-09T02:16:28.26+00:00
AmaranS 7,240 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Find duplicate rows in SQL

I don't mind the approach but was I was looking for a PO within my database and found duplicate rows. Like, have a way to catch these.

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
12 questions
asked 2024-07-30T18:52:30.0133333+00:00
Jonathan Brotto 420 Reputation points
accepted 2024-08-02T13:10:04.3633333+00:00
Jonathan Brotto 420 Reputation points
0 answers

Microsoft Applied Skill 4 - Failure to create Databases 1-4

While attempting the "Migrate SQL Server Workloads to Azure SQL Database" it failed to create Databases: DB1, DB2, DB3, and DB4. While DB5 was a partial. Has anyone else had this happen to them? What steps have you taken to resolve this…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,476 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
12 questions
asked 2024-07-14T02:43:10.5333333+00:00
Jacob Shuster 0 Reputation points
commented 2024-07-25T10:46:41.32+00:00
AmaranS 7,240 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

I have a query where I like to run in another server and database

I opened a query in another database, and I would like to run it in another window. Is there a way to do that while keeping the same query window? For example server A database Q to server B database Y.

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
12 questions
asked 2024-07-23T14:46:46.1766667+00:00
Jonathan Brotto 420 Reputation points
edited the question 2024-07-23T16:59:13.74+00:00
VarunTha 12,500 Reputation points Microsoft Vendor
2 answers

Typo on page

Hi, where do we give feedback for a typographical error on a MS Learn page? https://learn.microsoft.com/en-us/training/modules/sql-server-2022-performance-enhancements/3-memory-feedback-exercise Item 6. IsMemoryGrangFeedbackAdjusted should be…

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
12 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
578 questions
asked 2024-05-31T19:07:21.7766667+00:00
Ric Oliva 0 Reputation points
edited the question 2024-07-03T04:21:10.9966667+00:00
Ryan Hill 29,666 Reputation points Microsoft Employee
2 answers

How can I change the data mapping?

I'm importing a file via excel into a table in SQL. I keep getting this error about the date time. I've tried changing the date format in Excel and nothing helps. Also I can't change the format type either.

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
12 questions
asked 2024-06-26T20:03:12.53+00:00
Danielle 0 Reputation points
commented 2024-07-01T06:44:06.22+00:00
LucyChen-MSFT 5,060 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Search all columns with the same where clause

Is there a way to search all columns with the same where clause? It is one piece of text and ideally not write a long where with or statement would be nice.

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
12 questions
asked 2024-06-11T18:15:45.0166667+00:00
Jonathan Brotto 420 Reputation points
accepted 2024-06-13T14:19:17.6+00:00
Jonathan Brotto 420 Reputation points
0 answers

Security Update for SQL Server 2019 RTM GDR (KB5035434) failed

Security Update for SQL Server 2019 RTM GDR (KB5035434) failed

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
12 questions
asked 2024-04-21T23:27:28.2766667+00:00
Roger Bergeron 10 Reputation points
edited the question 2024-04-22T06:03:13.3566667+00:00
SadiqhAhmed-MSFT 48,351 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

What does "Three and Four-part names? mean in "Elastic Query?

as question, would you please advise?

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
12 questions
asked 2024-02-18T15:06:42.2966667+00:00
Ho Ming Tam 45 Reputation points
edited the question 2024-03-27T09:04:42.29+00:00
AmaranS 7,240 Reputation points Microsoft Vendor
2 answers

Is there a mistake in the depiction of EXCEPT Operator using Venn Diagram in the Advanced T-SQL Training

I believe there is a mistake in the Venn Diagram that depicts the usage of EXCEPT Operator in the Advance T-SQL Training. The result set should give "Silver/Black" also in the output as this is in the First Result Set and NOT in the Second One.…

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
12 questions
asked 2024-02-03T06:44:21.65+00:00
Santosh Kumar Vellala 0 Reputation points Microsoft Employee
edited the question 2024-03-27T09:00:42.18+00:00
AmaranS 7,240 Reputation points Microsoft Vendor