In my previous tutorial, we implemented to save Geolocation (latitude, longitude) in Geography data type column in Sql Server. Now, we will get the nearest N places from the current geo-location of user.
Tag: sql server
HTML5 Geo-Location, SQL Server Geography Data Type, Entity Framework and ASP.NET
In this article, we will implement to save current geo-location(latitude, longitude) of user in Sql Server Geography data type column using Entity framework and ASP.NET Web Form.
Saving SkyDrive Excel Survey Data To Sql Server Database with ASP.NET MVC
Run Your Custom Script Quickly with SSMS Tools Pack
Suppose you have to do a task repeatedly with different objects of database, for example, you have to generate code or stored procs of table in the specific format, you created your custom SQL script which takes table name and generate the code. But each time, you have to execute query and pass table name.
What’ll happen If you right click on the table and select your script to execute. It’ll save bunch of time as well as stop you getting irritated :) Let’s see how to do using SSMS Tools Pack.
Install sql server database with visual studio setup
Generally, It is required to install sql server database with visual studio setup. Here are the steps to install sql server database with setup using custom action.