2432 0
How to Create database in sql server management studio (With Insert/Delete)
In this article, I have provided step by step details with images about how to create a database in sql server using SQL Server management studio easily.
Type
Article
2419 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
2417 2
How to retrieve an int from Stored Procedure and not an objectResult using EF ???

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

...
Type
Question
2417 2
how to take back up of all sql server databases?

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.

 

...
Type
Question
2371 1
Error "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication." in SQL server

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

...
Type
Question

2236 2
How to count the occurrence of specific word inside a string in sql server 2008?

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.

...
Type
Question
2223 0
SQL Server Management Studio (SSMS) Versions
In this article, I have provided list of all SQL Server management studio (SSMS) versions release by Microsoft until now with it's download links.
Type
Article
2183 2
Check if table exists then delete it in SQL Server

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.

...
Type
Question
2123 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
1996 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

Page 6 of 10