5731 2
How to solve error "save changes is not permitted" in sql server?

I am using SQL server 2012 and when trying to edit design of already saved table, i am getting this error

Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option prevent saving changes that require the table to be re-created.

Here is the image of the error

...

Type
Question
8505 3
Getting error 'A transport-level error has occurred when receiving results from the server.'

When I am trying to Load page of my clients web application, which has shared connection string, I am getting the below error

A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

...

Type
Question
9560 2
SQL server 2012 - Error: attempted to read or write protected memory

When I am trying to Edit my tables on my newly installed SQL server management studio, I am getting the error below

Exception has been thrown by the target of an invocation. (mscorlib)
 Additional information:
   Attempted to read or write protected memory. This is often an indication that 
   other memory is corrupt. (Microsoft.VisualStudio.OLE.Interop)

Here is the image of the error

...

Type
Question
2897 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
12769 2
Where can I download SQL server 2016 express full?

Hi, I have searched on google about links to download complete sql server express 2016 full version but i wasn't able to find it, as previous version of SQL Server Express were available in both web and full downloads, so can anyone provide me link(s) to download full sql server express 2016(preferred) or 2017 edition or 2019 Express.

Need complete offline installer, thanks

...
Type
Question

3904 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
2437 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
8005 1
how to select row where Id is not equal to in SQL?

I want to select rows from a table where Id is not equal to 4, How to achieve it using SQL query?

Something like in C# .Where(a=>a.Id != 4).ToList() ?

Or in SQL like Select * Where Id != 4?

Thanks

...
Type
Question
2358 2
How to access the substring from the string in sql?

I need to access substring from a string using SQL, how can i achieve it in SQL server?

Suppose my string in "Hello World in C" and i want "World" from it, how can i do that using SQL query?

...
Type
Question
3064 1
select values from one table and avg of column from another?

I have Two Tables, from one table I want to select all column but from the second table I want to fetch only one column with average value using avg function with related id 

How can I achieve this using SQL query?

...
Type
Question

Page 10 of 11