4114 0
How to Create database in sql server management studio (With Insert/Delete)
In this article, I have provided step by step details with images about how to create a database in sql server using SQL Server management studio easily.
Type
Article
4007 2
Relational Algebra and Relational Calculus

I am new to Database systems and I don't really have the best lecturer and we are learning about Relational algebra and relational calculus, not many videos or help online. 

Please can someone assist me with this topic as i would like to get further knowledge 

...
Type
Question
4000 2
Cannot connect to WMI Provider SQL server configuration manager error

I am trying to open SQL server configuration manager, after following this question "How to open sql server configuration manager in windows 10?" and steps to show it on Start menu, but when opening configuration manager getting error pop-up with message

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid namespace

...

Type
Question
3956 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
3872 1
How to reset the column value using sql and knockout js in MVC?

If, we assign the rank to the column
Ex:
Name.   .   .    .   .      . Rank
A.                        .   .   .  1
B                                     2
C                            .   .   . 3

When the user adds the data, the rank is saved in DB(database).

How to update the rank in DB, when user delete the data using knockout?

On click of delete, there is one function called
Remove row
And in that function table row<tr> is removed using knockout.

Example: if we delete row B its order will be, -1 as deleted item will have rank/order -1 and order/rank of c will be 2

Is, there any alternative way to reset the column value in SQL or something else? 

Please, suggest me

Thank you

...
Type
Question

3853 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
3737 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
3620 0
Get month and year in sql server from date
In this article, I have mentioned how we can get month and year in sql server from datetime or date value.
Type
Article
3559 0
Convert Month Number to Month Name in SQL
In this article, I have mentioned, how we can convert month number to month name in sql server, mysql and oracle database.
Type
Article
3435 0
Import an SQL file in MySQL (Using CMD or Powershell)
In this article, I mentioned how we can Import an SQL file in MySQL (Using CMD or Powershell or using MySQL Workbench) easily and quickly.
Type
Article

Page 6 of 11