Just a bit before systems analysts became architects.

BillyTheKidney

Hi, I have a Sql Server 2008 database on a website and need to develop a web service using JSON to call from remote devices for running stored procedures. Does anyone have any sample code of a web service running a sp with input parameters, producing a JSON result set that I can have a look at? Thanks

Anthony

Thanks for the input, appreciated. The old SQL Server 7/2000 version generates the old VB/ASP code for calling a stored proc, though I haven't got round to changing it for the 2005/8 version as yet. I would be interested to see your code generation software.

BillyTheKidney

Hi, I need some feedback on some code generation software I'm in the process of re-developing for SQL Server (2005/2008). Its called SSCodeGen (for 2005/2008) and the new version (8.3) is now up at www.RaisinTech.com/SSCodeGen.exe, It will - Generate the 4 standard (A/I/U/D) stored procedures for a table (text/image field not currently handled) - Generate the execute statements for a stored procedure (slightly more complete than that generated from SS Man Studio) - Generate the sql for S/I/U/D statements for one or 2 tables on the database. Obviously it is free, and it doesn't require installation, you can just download and run. There is a version for SQL Server 7/2000 at http://users.quista.net/thealey/. Any comments appreciated

BillyTheKidney

The keyboard. Making sure there were no errors on the punched cards before sending them off to the computer room was a real chore.

BillyTheKidney

Hi, Using .netframework 2.0, I can see the My.Computer.Info.OSPlatform information for the XP I am using, i.e. "Win32NT", and and the .OSversion i.e. "5.1.2600.131072". As I don't have a Vista pc, can anyone tell me what the My.Computer.Info.OSPlatform string would be if I was running Vista? If the same as above, what would the version no. be like? Thanks for your help

BillyTheKidney