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
...
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?
...Hello, I need to check my last month records in SQL server management studio, and I would like to know how can I get record of only last month from a table using SQL query, I have DateCreated column to check when the row was added in the table.
For example, as It's may,2018 and I would like to run a Query to get April,2018 records using sql server query.
If possible, I would also like to know, how to get last 30 days(not month) records in SQL server query.
Currently, I am using SQL server 2012.
...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?
...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:
...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
...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
...