861 0
How to update table variable in stored procedure from another user defined function in sql?

Scenario : User defined function return one table. If that table contains at least one row,one column in the table variable from another sp should get updated.

Should I use cross join on UDF to update table variable?

sql

...
Type
Question
796 1
There is error while executing stored procedure

Getting error in SQL server stored procedure when executing it:

...
Type
Question
585 1
What is SQL Query to get dates between two dates?

Hello, I have one more question related to SQL query, in which I would like to know how can I get all dates between two dates using SQL Query. For example, I have start date = 10/02/2022 and end date = 14/02/2022, then query must return dates 11/02/2022, 12/02/2022 and 13/02/2022.

I am using SQL Server for this, but I think SQL query will remain the same for oracle or MySQL too.

...
Type
Question
543 0
Import data from Excel to SQL Server
In this article, I have provided step by step procedure to import excel in SQL Server database using SSMS or using SQL Query.
Type
Article
448 0
Difference between SQL and NoSQL (SQL vs NoSQL)
In this article, I have provided details of what is difference between SQL and NoSQL or you can say providing details of SQL vs NoSQL.
Type
Article

372 2
How to convert nvarchar column to datetime in SQL Server?

Hello, I am using nvarchar column to store datetime as string, but I would like to convert this column from nvarchar into datetime in sql server. How can I do it.

Current time format is '2019-01-29 14:55:50'

...
Type
Question
369 2
How to check if Columns exits in SQL Server table?

Hello, I am still learning SQL and SQL Server, so I would like to know how can I verify or check if a column exists in the database table using SQL Query in SQL Server?

...
Type
Question
256 0
Remove all whitespace from string in SQL Server
In this article, I have provided working examples to remove all spaces from a string in SQL Server.
Type
Article
206 0
Delete (Drop) Database in SQL Server
In this article, I have provided step by step procedure to delete or drop database in sql server using SSMS or using drop database using SQL query.
Type
Article
159 1
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

Page 8 of 9