742 1
"SqlException: MSDTC on server is unavailable" error in C# Code

One of my projects was working properly, and then I shifted it into another pc, now same code, throws the below error for some SQL queries.

SqlException: MSDTC on server is unavailable.

...

Type
Question
SQL C# ASP.NET
725 0
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
SQL SQL server sql server configuration manager cannot connect to wmi provider
681 1
Error while Updating or Deleting data using RowNum in Oracle 11g

Hi, how can I use "ROWNUM" to delete a specific row? just ROWNUM only not ROW_NUMBER() or ROWID

I can select specific row using ROWNUM but I cannot use it in DELETE or UPDATE operation.

Sample Query in Select Statement:

...
Type
Question
ORACLE ORACLE 11G
646 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
asp.net-mvc sql knockout-js
636 1
Pseudo code in SQL

I have to write a pseudocode program to read the two sample files, calculate and print the final mark for each subject, as well as the average final mark per student.

Document the code well using comments.

The final mark is calculated as 25% of the year mark, 25% of the prac mark and 50% of the exam mark.

Assume the records of the two files are arranged in Student number (S-no) sequence. Note that some students have more subjects than others….

 

I was tasked with the above program and im not sure how to express this in pseudo code.

 

...
Type
Question
SQL Pseudo

628 1
Query doesn't work with AVG function, how to use AVG in SQL?

I am trying to run the below query which works fine without AVG function, but when using AVG it doesn't work, here is the query

...
Type
Question
SQL AVG function not working avg in sql
617 1
How to find missing date between two dates in sql table.

I would like to know a sql query to find all missing dates between two dates , suppose my sql table is as below

ID

Date

1

2018-1-10

2

2018-1-12

3

2018-1-13

4

2018-1-15

5

2018-1-17

6

2018-1-18

7

2018-1-20

8

2018-1-21

 

I need to run sql query which will return missing dates from date column like  ‘2018-1-11’ , ‘2018-1-14’.

 

...
Type
Question
sql date sql-server
569 1
Sum of two column values from two different tables

I want sum of two column values from two different tables, how can I do it using SQL?

Suppose, these are my two tables, Table 1

...
Type
Question
sql sql server
454 2
Can i have example of declare table and temp table in sql ? and how the update operation can be used on it ?

Can i have example of declare table and temp table in sql ? and how the update operation can be used on it with real life scenario ?

 

...
Type
Question
sql c#
450 1
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
dbms calculus algebra

Page 4 of 5