Skip to main content

Errors in SQL (MySQL or SQL Server or SQLite)

 

 Brief

Contains all the errors occurred for me while working with SQL Server or MySQL or SQLite.

  1. Can a table have the foreign key reference of more than one table and data along it? Answer -> Yes
  2. SQL Server Invalid version: 15 (Microsoft.SqlServer.Smo)
    Ans -> Using SSMS version 18.0 instead of 17.0 seems to be working.

    You can download it from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017


Labels:

Comments

Post a Comment

Popular posts from this blog

All the require docs of job seekers (java docs, testing docs, study materials, genuine consultancy link)

# JUST_FOR  JAVA LOVERS : CORE & ADVANCED JAVA Notes ! Core Java and Advanced Java Notes! . Link 1 :-  https://www.dropbox.com/s/t…/1--%20Core%20Java%28TOC%29.pdf… Link 2 :-  https://www.dropbox.com/s/0ahi8r…/9--%20Advanced%20Java.pdf… _________________________________ 1.  https://drive.google.com/…/0BxJrew1xg5ZLZjdabnVUUkswalk/view 2. https://drive.google.com/…/0BxJrew1xg5ZLVHVSQ0tiU1VmVXM/view 3. https://drive.google.com/…/0BxJrew1xg5ZLdS1JUTAxMWtTcEU/view 4. https://drive.google.com/…/0BxJrew1xg5ZLY1M5bGp2Ym5lZUk/view 5. https://drive.google.com/…/0BxJrew1xg5ZLck13Rndpd1ZlcEU/view 6.  https://drive.google.com/…/0BxJrew1xg5ZLb2xodlhOTEVzLTA/view --------------------- Spring --------------------- https://drive.google.com/…/0BxJrew1xg5ZLQ3VaQnlja3N1Mkk/view https://drive.google.com/…/0BxJrew1xg5ZLTXNVLUdOR0xmTzQ/view https://drive.google.com/…/0BxJrew1xg5ZLWU9PUmVKUUYtMjQ/view ---------------------- Hibernate ---------------------...
Post a Comment
Read more

Use your mobile phone as web cam to your pc/laptop

 Brief  This thing started when I had an interview😮 with one of the company in Nepal and my laptop camera quality was so bad that I was asked to turn off 😥 it which made me to think to buy a webcam for my laptop and I realized if the webcam be attached to my laptop using USB cable or WIFI then why we cannot use my phone. This is how it started. I have tested it and using this app called iVCam since then it worked very well as well with teams, zoom and other streaming app as well. We need to download these 2 stuffs only: The mobile app. The PC client software. Install these two software on your individual mobile and pc and then you are good to go.Mobile phone will ask for the permissions, and allow all the permission it ask for. There are two by which we can connect your mobile phone as web cam and they are:  A) WIFI: Connect your laptop and mobile to the same wifi network. Open app in both mobile and laptop/pc. It will automatically connect to the mobile camera....
Post a Comment
Read more

Terminology used in CPU, GPU, APU, RAM or Hardisk(HDD or SSD)

 Brief We will discuss the terminology used in the CPU, RAM or Hardisk(HDD or SSD). CPU GPU Si RAM Virtual Memory (From the  also called Page File,  Single Stick Dual Stick Single Channel Dual Channel Single Slot Dual Slot RAM Disk RAM Caching Note - More size, more frequency, more channel, and less latency is best for RAM but it depends upon your laptop, if your laptop mother board only supports 2400MHz frequency then buying more than that frequency of RAM is not good idea because your RAM will work at 2400MHz frequency only. If you want to use the High Frequency RAM then use the technique of RAM Disk and RAM Caching. Hardisk References & Recommendations 🔥 High Speed RAM 🔥 Does Memory Frequency Matter? 🔥Desktop vs Laptop 🔥 Hindi
Post a Comment
Read more