Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. Anu Rhea

Anu Rhea

Community Learner
Share
17Questions
17Answers
23.6KViews on questions

What to do when a subquery returns more than 1 row?

If subquery returns more than 1 row- (SELECT courses FROM wp_category WHERE CatID =401) OR (SELECT meta_value FROM wp_postmeta WHERE post_id IN (SELECT courses FROM wp_category WHERE CatID =401) AND meta_key ='post_id' ) This is a condition, but you need n values. This should work: ( ID IN ( (SELECT courses FROM…

SQL Server

Answered Mar 16, 2023 · 1.3K Views Read answer →

What is embedding machine learning?

The embedding machine learning or NLP is actually a technique mapping from words to vectors which you can do better analysis or relating, for example, "toyota" or "honda" can be hardly related in words, but in vector space it can be set to very close according to some measure, also you can strengthen the relationship…

Data Science

Answered Feb 13, 2023 · 922 Views Read answer →

What is javascript mvc canvas?

MVC canvas has been covered in so many places so there shouldn't be much to reiterate here. Essentially you want your object graph, helpers, and logic to be contained in the model tier. The views will be the screens that get pushed out to fill the dynamic part of the page (and may contain a light amount of logic and…

Java

Answered Oct 13, 2022 · 955 Views Read answer →

Is DuckDuckGo Legit or a Scam Why would someone trust It?

There is no proof yet that DuckDuckGo operates as advertised. (There never is, on the web.) However, that is the wrong question. DuckDuckGo is very clear in its privacy policy. DuckDuckGo says it doesn't track you, it doesn't send your searches to other sites, by default it does not use any cookies, it does not…

SQL Server

Answered Dec 10, 2021 · 1.5K Views Read answer →

How to clear the console in Java

To clear the console in java, use the given code: public static void clearScreen() { System.out.print(""); System.out.flush(); }The will help you to clear the screen.

Python

Answered Jul 23, 2021 · 1.0K Views Read answer →

How do I get back some deleted records?

Is your database in full recovery mode? If yes, are you doing transaction log backups? If yes, do you have a backup utility like Quest LiteSpeed, Red Gate SQL Backup in undelete sql server , or Idera SQLSafe? If yes, those utilities can undelete objects from backup files (including the fulls and transaction logs) -…

SQL Server

Answered Jul 19, 2021 · 1.0K Views Read answer →

How to Reset IDENTITY value?

You can reset the identity column in SQL server by DBCC CHECKIDENT('tableName', RESEED, 0)So next time you insert into TableName, the identity value inserted will be 1. When you delete rows from the table, it will not reset the Identity value, but it will keep increasing it. Just like what happened in your case. Now…

SQL Server

Answered Jul 19, 2021 · 3.5K Views Read answer →

How can I solve Writing select result to a csv file?

Use BCP utility to solve SQL server export to CSV bcp "SELECT Col1,Col2,Col3 FROM MyDatabase.dbo.MyTable" queryout "D:MyTable.csv" -c -t , -S SERVERNAME -T The -c argument specifies character output, as opposed to SQL's native binary format; this defaults to tab-separated values, but -t , changes the field terminator…

SQL Server

Answered Jul 19, 2021 · 1.0K Views Read answer →

How to resolve “Network-related or instance-specific error" while establishing a connection to a SQL Server on a remote computer on the home network.

By default named instances are bound with dynamic ports and the SQL Browser service is the one that redirects the client connections to named instances. For this to happen you need to ensure the following: Ensure SQL Browser service is running Create a rule in windows firewall (where SQL Service and SQL Browser…

SQL Server

Answered Jul 12, 2021 · 1.4K Views Read answer →

More members from the SQL Server community

Learners asking and answering questions on the same topics — follow their questions and join in.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.