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?
...Hi,
im trying to set data from my project (mvc.net,c#) by web service and im using a store Procedure to set the data.
after setting i should recive an int id of the record that was created.
my problem is that the SP returns an objectResult when i run it from my project but when i execute it in SQL it returns int...
How to retrieve an int from Stored Procedure using EF ???
I am using SQL server 2012 right, and I would like to know how can I take back up of all MS SQL server databases using a single script? or you can explain me a simple method.
...
I was trying to run my amazon RDS account using MS SQL server management studio, and was able to login succesfully but when using that values in web.config and loading page in browser, I am getting error as below
"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."
How Can I resolve this issue, here is my Connection string
...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 checking this article, which allow you to drop all tables of SQL Server database, but I just want to delete a specific table of the database, so how can I do it?
to check if table exists then drop it completely from the database, without risking any other DB table in SQL Server.
...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
...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:
...