So, I've found the source of all the data I need in my database, but it is in a JSON file.
MSSQL cannot read JSON and the entire internet seems devoted to telling me how brilliant and easy JSON is and then giving me 20 pages of code to deal with it.
I don't have time to implement a JSON parse in C or anything like that.
I just need to put this perfectly simple bit of data into a database.
Can you help? [more inside]
posted by Just this guy, y'know
on Jun 27, 2013 -
Ok, I have an application that is using a back end of MS Access...I have another application that needs to get some of the data in the Access db but it is only SQL compatible.
So...how do I set up an ODBC connection that will pull data from the Access db and write it out to a SQL db? This data needs to be updated hourly...
Thanks for your assistance!
posted by keep it tight
on Mar 14, 2013 -
SQL - How to get an accurate count of the rows potentially affected by an UPDATE statement, or best practices for performing updates? [more inside]
posted by odinsdream
on Feb 9, 2010 -
MS SQL Pros, I need your help! What's causing MS SQL 2005 to import records so slowly? It's a persistent problem across all databases that just developed yesterday. Details inside... [more inside]
posted by antonymous
on Oct 20, 2009 -
Currently Microsoft-only, but wanting to change our software soon to support Oracle as well. What are we getting ourselves into? [more inside]
posted by relucent
on Jun 5, 2009 -
I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head? [more inside]
posted by cbrody
on Mar 10, 2009 -
I need to import a database into MS SQL but I do not want to end up with a transaction log as large as the database. What's the best way to do the import? [more inside]
posted by odinsdream
on May 29, 2008 -
After working in a mostly LAMP (Linux, Apache, MySQL, PHP) environment the last few years, I need to make a quick switch to WISA (Windows, IIS, MS SQL, ASP). [more inside]
posted by gringoese
on May 18, 2008 -
Help me understand MSSQL logs... At least enough to do what I need to do. [more inside]
posted by eas98
on Mar 28, 2008 -
How do you use a single authentication system for different kind of servers, systems, and workstations? [more inside]
posted by remi
on Jan 11, 2008 -
I have a set of dates/times in a MS SQL table that lack a timezone offset. I want to convert them to UTC, but I have to be mindful of Daylight Time for each of these dates (they're in the future). How can I convert them to UTC correctly? [more inside]
posted by dw
on Nov 13, 2007 -
I have Visual Studio 2005 Professional. I installed VS2k5Pro with all of the options except the sample databases on my WinXP box, but now I can't figure out how to access the Enterprise Manager - replacement ... Enterprise Management Studio, or even find out if that app is included with the version I have. Any suggestions?
posted by SpecialK
on Aug 1, 2007 -
Is there a way of mapping a Virtual Drive letter or a share to an MSSQL database? [more inside]
posted by seanyboy
on Jan 30, 2007 -
Attention SQL gurus
. This has me completely stumped. How can I find the index (position) of a row in a table without querying the entire set? [more inside]
posted by Civil_Disobedient
on Sep 3, 2006 -