15 questions with SQL Server Training tags

Sort by: Updated
Updated Created Answers
2 answers

Msg 206, Level 16, State 2, Line 9 Operand type clash: int is incompatible with date (I want only year not full date then how I get)

CREATE TABLE employe ( ID INT, YEar DATE, FirstName VARCHAR(50), LastName VARCHAR(50), ); Insert into employe values (1,2020, 'John', 'Doe'), (2, 2021,'Jane', 'Smith'), (3, 2022,'Alice', 'Johnson')

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.
15 questions
asked 2025-05-03T13:48:28.6233333+00:00
pallavi potnuru 0 Reputation points
answered 2025-05-03T15:33:40.6633333+00:00
Erland Sommarskog 120.3K Reputation points MVP
1 answer

Hello,Is there any foundation certification for SQL if so, is training material provided and what's the cost

I need information on if there is any foundation level certification for sql that I can aquire. Also need to know if there is any training provide for the same and it's fees

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.
15 questions
asked 2025-03-12T17:14:33.01+00:00
Namarata Venkat 0 Reputation points
edited an answer 2025-03-18T05:12:59.62+00:00
Rakesh Gurram 14,395 Reputation points Microsoft External Staff
1 answer One of the answers was accepted by the question author.

How to use the Get data features in Power Bi Desktop to import data from SQL Server

Hi, Could you please help me out? I'm stuck in this module. I have been trying to use the Get data features in Power BI to import data from SQL Server, but I keep getting an error message, unable to connect, and the message below.. Details:…

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.
15 questions
asked 2025-02-27T19:52:35.14+00:00
Naomi Anumudu 20 Reputation points
commented 2025-02-28T12:38:30.88+00:00
Syed Saleem Peera 12,560 Reputation points Microsoft External Staff
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.
15 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,160 Reputation points Microsoft External Staff
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,494 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.
177 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,705 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.
15 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,494 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.
177 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,705 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.
15 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,260 Reputation points Microsoft External Staff
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.
15 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,494 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.
15 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,260 Reputation points Microsoft External Staff
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.
15 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 13,920 Reputation points Microsoft External Staff
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.
15 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.
715 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 30,186 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.
15 questions
asked 2024-06-26T20:03:12.53+00:00
Danielle 0 Reputation points
commented 2024-07-01T06:44:06.22+00:00
Anonymous
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.
15 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.
15 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,716 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.
15 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,260 Reputation points Microsoft External Staff
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.
15 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,260 Reputation points Microsoft External Staff