Improve company productivity with a Business Account.Sign Up

x
?
Solved

Sql Server 2012 table wont accept certain letters

Posted on 2014-02-25
5
Medium Priority
?
139 Views
Last Modified: 2014-03-08
I have a table in Sql Server 2012.  One of the fields in the table is a varchar(50)
This table has about 25,000 records in it and works just fine. Except that the field will not allow the letters SK to be the first two letters in the field. Anything else works fine, but when a word starting with "Sk" is entered, it times out and will not allow the data to be saved.
Any ideas?
0
Comment
Question by:LearningToProgram
5 Comments
 
LVL 84

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 750 total points
ID: 39887737
It may appear that way but I'm certain that isn't all there is to it because Sql Server just doesn't work that way.  Do you have any stored procedures working on the data?  Any filtering being done to it first?
0
 
LVL 93

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 750 total points
ID: 39887766
Or adding to Dave's comments, are you sure there aren't any constraints?
0
 
LVL 50

Expert Comment

by:Paul
ID: 39888051
What is the relevance of Excel to this question?

What is timing out exactly? (Excel?, a web form?)
0
 

Accepted Solution

by:
LearningToProgram earned 0 total points
ID: 39901877
There were no constraints, stored procedures or filters. I created a new table and moved the data over and that fixed it.
0
 

Author Closing Comment

by:LearningToProgram
ID: 39914435
There were no constraints, stored procedures or filters. I created a new table and moved the data over and that fixed it.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question