606 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
sql sql-server avg-function
599 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
sql sub-string from string split string in sql sql-split-string-by-delimiter
563 0
Understanding SQL server COALESCE() with example (ISNULL comparison included)
In this article, I am going to provide you complete details of SQL server COALESCE function with example & will compare it with ISNULL.
Type
Article
SQL sql server coalesce example sqlserver isnull
549 0
SQL server connection string examples in C# & XML
In this article, I have provided various examples of SQL server connection string in C#, ASP.NET Web.Config file in XML format and MySQL connection string in C#.
Type
Article
C# SQL-server-connection-string sql-server-connection-string-c# sql-server-connection-string-integrated-security c#-database-connection
541 1
How to get the records of last month using sql query in SQL server?

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.

...
Type
Question
SQL SQL server tsql get last month records

479 0
How to check sql server version? (Various ways explained)
In this short article, I am going to provide you various possible ways to check which SQL server version you are using.
Type
Article
SQL sql server version check database version in sql
479 0
Creating SQL Server maintenance plan (Step by step procedure)
In this article, I am going to explain, how can we easily create SQL server maintenance plan by following this step by step procedure and how often we should plan it.
Type
Article
SQL sql server maintenance plan sql server maintenance plan
460 3
How should i display first 10 records at a time in sql (paging in SQL)?

How should i display 1st 10 records, then next 10 records then next 10 records in sql (paging in SQL)? 

And how should i display the same thing in view using see more link?

...
Type
Question
Sql Mvc paging in sql server
458 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
SQL sql server error save changes is not permitted unable to modify table in sql server
445 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

Page 3 of 5