SQL

Most Viewed first Recent First
4436 0
Convert Month Number to Month Name in SQL
In this article, I have mentioned, how we can convert month number to month name in sql server, mysql and oracle database.
Type
Article
4297 0
SQL Server Management Studio (SSMS) Alternatives (Mac, Windows, Linux)
In this article, I have mentioned SQL Server management studio (SSMS) alternatives for windows, mac and Linux, which you can try to use.
Type
Article
4041 0
Free SQL Server Reporting Tools
In this article, I have provided list of free SQL server reporting tools with their features, so you can easily which sql server reporting tool will be good for your company.
Type
Article
4002 0
Import data from Excel to SQL Server
In this article, I have provided step by step procedure to import excel in SQL Server database using SSMS or using SQL Query.
Type
Article
3915 0
Download and Install SQL Server Management Studio (Step by Step)
In this article, I have mentioned how you can download and install SQL Server management studio (SSMS) in your local pc and how to use SSMS.
Type
Article

3863 0
TRIM(), LTRIM(), RTRIM() Functions in SQL Server
In this article, I have discussed about SQL Server TRIM(), LTRIM(), RTRIM() Functions in SQL Server with example
Type
Article
3804 0
Convert Int To String (varchar) in SQL Server
In this article, I have mentioned how we can convert Int to string (varchar) in SQL Server using examples
Type
Article
3787 0
Get Date From Datetime in SQL Server
In this article, I have mentioned how to get date from datetime in sql server using various examples.
Type
Article
3766 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
3743 0
How to Edit More than 200 rows in SQL Server
In this article, I have mentioned how we can increase limit to edit more than 200 rows in sql server using SSMS.
Type
Article

Page 7 of 11