Join Now
|
Login
home
login
join now
.NET pattern framework
javascript + jquery patterns
database pattern framework
products and pricing
.NET design patterns
javascript design patterns
javascript tutorial
sql + database tutorial
connection strings
visual studio shortcuts
c# coding standards
html color codes
all references
explore
questions
ask question
tags
users
contact us
training courses
schedule
registration
about us
training and education for professional developers
login
join now
Home
Questions
Tags
SQL Server
Tagged with:
SQL Server
6
records found
date
active
views
answers
votes
SQL Server: How do I truncate (not round) decimal places?
I am writing a stored procedure in SQL Server 2008 R2. I am struggling with rounding / truncating a decimal value. For example the value 9.567 gets rounded up to 9.57, but that is not what I need. In my ...
Feb 23, 2013
by
Craig Johnston
128
96.7
SQL Server
Round
Truncate
Views
323
Answers
0
Votes
0
Answer
Code
Follow
0
Appropriate datatype for Latitude and Longitude in SQL Server
I need to store Latitude and Longitude data in SQL Server. The data comes from Google in the following format: xxx.xxxxxx. I was thinking of using DECIMAL(9,6). Is this accurate enough for ...
Jul 14, 2011
by
Craig Johnston
128
96.7
Last:
Aug 26, 2011
by
Tarriq Ferrose Khan
80
96.3
SQL Server
Latitude
Longitude
GeoLocation
Views
2.4K
Answers
1
Votes
0
Answer
Code
Follow
0
Question about C# and SQL Server certification
I have a question for the community: I am primarily working with C# and MS SQL Server and would like to know which professional certifications are going to be the most valuable to me. Thanks. ...
Sep 16, 2010
by
Anuj Aggarwal
50
50
C#
SQL Server
Certification
Views
1.1K
Answers
0
Votes
0
Answer
Code
Follow
0
Attaching SQL Server in Design Pattern Framework
I attached both the ASPNETDB.mdf and Action.mdf to my local SQLServer instance and modified the Web.config for Host.WCF.ActionServer and App.Config for DataObjects\App.Config but I get this error when I click ...
Aug 05, 2010
by
Sunit Joshi
50
50
Last:
Aug 05, 2010
by
Dan McMillan
750
99.9
Design Pattern Framework
SQL Server
Views
2.5K
Answers
1
Votes
0
Answer
Code
Follow
0
Sql Server Timeout expired
Greetings, How I can change the Sql Server timeout to keep me out the following error System.Data.SqlClient.SqlException was unhandled by user code Class=11 ErrorCode=-2146232060
Apr 28, 2010
by
Rafael Huapaya
50
50
Last:
Apr 28, 2010
by
Redha Reghioua
330
99.8
SQL Server
TimeOut
Views
3.1K
Answers
1
Votes
0
Answer
Code
Follow
0
Dynamic LINQ solution?
In our app we have a situation where the users can select from numerous criteria and get back a subset of a large number of documents. Also, supported are pagination and sort order. Criteria may incl
Feb 24, 2010
by
Craig Johnston
128
96.7
Last:
Feb 26, 2010
by
Aaron Burton
254
99.5
LINQ to SQL
LINQ to Entities
SQL Server
Views
3.7K
Answers
1
Votes
2
Answer
Code
Follow
0
15
30
50
Per Page
return to top