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:
...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....
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
...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
...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
...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 ?
...
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
...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.
...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.
...