Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 137
  • Last Modified:

Sql Server 2012 table wont accept certain letters

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
LearningToProgram
Asked:
LearningToProgram
3 Solutions
 
Dave BaldwinFixer of ProblemsCommented:
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
 
Patrick MatthewsCommented:
Or adding to Dave's comments, are you sure there aren't any constraints?
0
 
PortletPaulCommented:
What is the relevance of Excel to this question?

What is timing out exactly? (Excel?, a web form?)
0
 
LearningToProgramAuthor Commented:
There were no constraints, stored procedures or filters. I created a new table and moved the data over and that fixed it.
0
 
LearningToProgramAuthor Commented:
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now