Viewing 15 posts - 2,266 through 2,280 (of 3,500 total)
This is one way of parsing out the tweets... it's not perfect, but it's closer than you are now.
DECLARE @TextString VARCHAR(1000) = 'got me a text file with tweets in...
September 22, 2015 at 3:00 pm
Welcome to SSC,
A few things...
You should get more responses if you post to a new thread instead of a prehistoric one.
For a newbie, nice post,...
September 22, 2015 at 2:47 pm
Access databases (.mdb at least, not totally sure about .accdb) were notorious for corrupting if you didn't treat them nicely. I wouldn't trust an .mdb for anything that required...
September 22, 2015 at 2:23 pm
Can you post a sample of what you're trying to parse out? Munge the data if necessary... Just helps to see what you're dealing with.
September 22, 2015 at 2:05 pm
If you right-click on the parameter that you want to allow nulls and view the properties, you can specify that the parameter can allow nulls.
If you are basing your dataset...
September 22, 2015 at 2:02 pm
If you're importing from an .MDB file, use the Jet 4.0, not the ACCDB nightmare. The Jet one actually works.
September 22, 2015 at 12:14 pm
Check the server collation value. It could be case-sensitive.
http://blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/
http://stackoverflow.com/questions/14270993/case-sensitive-variable-names-in-sql-server
September 21, 2015 at 4:45 pm
Christopher Adamson's Star Schema: The Complete Reference is really good. It's database agnostic, but he does a really good job of explaining concepts like Slowly Changing Dimensions and how to...
September 21, 2015 at 4:30 pm
IBM's version (for want of a better word) of SSIS.
September 21, 2015 at 2:56 pm
Eric,
I go to the user group meetings the vast majority of the time. Hard to argue with free training where you can ask questions. =)
Maybe my problem is that talent...
September 21, 2015 at 2:48 pm
Apologies for baiting a troll, but one thing that would scare me about using Access/Jet for any important database is data security. I worked in healthcare for a while,...
September 21, 2015 at 2:19 pm
John,
Good point. The hard part for me is the "can't get a job without experience, can't get experience without a job" conundrum.
I did write one not terribly complex database...
September 21, 2015 at 2:10 pm
what database engine are you writing against? HeidiSQL?
September 20, 2015 at 11:30 pm
"If i try to run it against the database server using Heidi sql."
Is this a SQL Server database?
If you're using SQL Server, I would look here... just because it's a...
September 20, 2015 at 11:10 pm
Viewing 15 posts - 2,266 through 2,280 (of 3,500 total)