422 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
364 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
346 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
323 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
297 1
How to open sql server configuration manager in windows 10?

I am using SQL server Express 2012 in my new windows 10 laptop, now I need to open SQL server configuration manager in windows 10? Where can I find it in Windows 10, in Windows 7, it was easier to navigate and check it in All Programs -> SQL server 2012 -> SQL server configuration manager, but in Windows 10 I cannot find it.

Where can I find it in windows 10? I tried to check in All programs but wasn't able to find it.

Thanks

...
Type
Question
SQL sql server configuration manager in windows 10

281 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
243 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#
197 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
107 2
How to count the occurrence of specific word inside a string in sql server 2008?

Hi. Suppose, I have for example this string field in my sql database  "never say never"  and I want to count how many times "never" appear in the string in sql server 2008, so how I can check that.

Thanks.

...
Type
Question
SQL count the occurrence of specific word
68 0
Database Threats and how to Prevent them

I am tasked with security of the systems database, as the previous operation lacked securtiy and left gaping holes in the system. The Systems information was leaked, and clients refords were leaked as well as workers salaries. I need to find One technique or strategy to prevent this information loss, and propose how we will prevent this in future. I am relitivly new to DBMS, can you please help me.

...
Type
Question
DBMS SQL

Page 4 of 5