5328 0
Common Table Expressions (CTE) in Sql server
In this article, I have explained what is Common Table Expression (CTE), Advantages of using CTE and Recursive CTE in SQL using SQL server based example.
Type
Article
5293 0
SQL Server Management Studio (SSMS) Versions
In this article, I have provided list of all SQL Server management studio (SSMS) versions release by Microsoft until now with it's download links.
Type
Article
5194 1
Get sum from three table and selected data using SQL

Hello, I am trying to get Sum of three columns from three different table and get results table using SQL.

Suppose here are my tables

Table 1: raw_item_fcst

sql-table-fetch-data-from-three-tables-min.png


Table 2. Raw_item

table-2-min.png

Table 3 . inventory_data

table-3-min.png

I try to write query to fetch data from these tables using subquery , Here is my sub query

...
Type
Question
5039 0
SQL Comments (Comment in SQL Query)
In this article, I have provided example to add comment in SQL Query for SQL Server, MySQL, SQL Comment in Postgres
Type
Article
4970 1
How to enable full text search on SQL Server database?

I have already created SQL Server database, but when I am trying to run a query that requires full-text search enabled database, it is not working and throwing error

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblLocation' because it is not full-text indexed.

So, how can I enable full-text index to remove above error?

...
Type
Question

4857 0
Understanding SQL server COALESCE() with example (ISNULL comparison included)
In this article, I am going to provide you complete details of SQL server COALESCE function with example & will compare it with ISNULL.
Type
Article
4394 1
How to fix "SQL server configuration manager cannot connect to wmi provider" error?
In this article, I am going to provide your easy way to fix SQL server configuration manager cannot connect to wmi provider error.
Type
Article
4343 2
Check if table exists then delete it in SQL Server

I am checking this article, which allow you to drop all tables of SQL Server database, but I just want to delete a specific table of the database, so how can I do it?

to check if table exists then drop it completely from the database, without risking any other DB table in SQL Server.

...
Type
Question
4285 2
Error Code: 1175 - You are using safe update mode

When I am trying to execute this query in MySQL Workbench 'DELETE FROM Job;', I am getting below error 

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.

So, how can I resolve this error, why I cannot Execute the simple delete query?

...
Type
Question
4277 4
SUM and JOIN 2 columns with different tables but it duplicates results

Trying to SUM and JOIN 2 columns with different tables but it duplicates results, here is my query

...
Type
Question

Page 5 of 11