L command for help sql2008 database to generate a json file-CodePudding

Have such a command? One great god know to help give directions,

I want to read data from a SQL 2008 database, and then generate a json file types, regularly

CodePudding user response:

The old version should be can not, write a script to implement

CodePudding user response:

reference 1st floor SuperDay response:

the old version should be can not, let's write a script to implement

Small white a, what all can't, can you tell me the teacher available scripts? Under the study

CodePudding user response:

This there is no specific research, should have such resources on the network, look for them

CodePudding user response:

reference SuperDay reply: 3/f

this, there is no specific research on the network should have such resources, find out

For 2 days, find useful Java implementation, but the Java also don't know anything, today to learn Java a day also didn't understand, good hard ah,

CodePudding user response:

What are you want to learn or to complete task?

CodePudding user response:

Is Microsoft SQL server, with Java?
Microsoft's SQLCLR, only you think, can't do without you,
It is ok to write a SQLCLR function, very simple,
You can refer to: https://blog.csdn.net/yenange/article/details/47659385

Microsoft's MSDN documentation, you can check it,
Written in c #,

CodePudding user response:

refer to 6th floor gypsy song response:

is Microsoft SQL server, using Java?
Microsoft's SQLCLR, only you think, can't do without you,
It is ok to write a SQLCLR function, very simple,
You can refer to: https://blog.csdn.net/yenange/article/details/47659385

Microsoft's MSDN documentation, you can check it,
Written in c #,

Thanks for a great god, and I go to learn, confusion for 2 days, it is a small white, more do not know where to start,

CodePudding user response:

refer to 7th floor mind wander reply:

Quote: refer to the sixth floor of gypsy song response:

Is Microsoft SQL server, with Java?
Microsoft's SQLCLR, only you think, can't do without you,
It is ok to write a SQLCLR function, very simple,
You can refer to: https://blog.csdn.net/yenange/article/details/47659385

Microsoft's MSDN documentation, you can check it,
Written in c #,

Thanks for a great god, and I go to learn, lost for 2 days, it is a small white, more do not know where to start,

What good confused?
If you have a certain foundation, c #, is four hours can fix things,

If you don't c #, install sqlserver2017 directly, can convert directly, do not need to use anything,

CodePudding user response:

refer to 6th floor gypsy song response:

To see is the webmaster, you must be very severe, learn from you, I won't c #, I just learn a period of time the front, now want to have a try their app, met with reading the database, the problem need to be a json file, just stuck in here for several days, can help others say Java conversion, I have no direction, learn Java a day also didn't understand, I'll try according to what you have said,

CodePudding user response:

Oh, it is as you say, this kind of situation,
If you want to get a json, the.net (c #) and Java,
But the App is usually request a WebApi interface, provide data by WebApi interface,
In the back-end language [the.net (c #) or Java] write WebApi is allowed, but not to learn three things, under the two

Suggest you play a little basis, first to learn Java, android, if you do can share MyEclipse development environment,
No backend based learning App directly, a little beyond the,
At least can do a simple web site and write a simple WebApi,
Of course, you don't learn the back-end can also, but the App is no the function of data interaction,

CodePudding user response:

2008 estimate is no SQLCLR, either you upgrade or opportunistic practice write SQL is dead, let it generates a json string, but if you want to gm's certainly not

CodePudding user response:

11 references SuperDay response:

2008 estimate is no a SQLCLR, either you upgrade or opportunistic practice write SQL is dead, let it generates a json string, but if you want to gm's certainly not

I upgrade SQL, but the system also want to upgrade, very difficult... Little by little

CodePudding user response:

references to the tenth floor gypsy song response:

Install sql2017, need 2012 system, reinstall the operating system, a good hard... Bit by bit in English

CodePudding user response:

refer to the 13th floor mind wander reply:

Quote: reference to the tenth floor gypsy song response:

Install sql2017, need 2012 system, reinstall the operating system, a good hard... Bit by bit in English.

Your computer, Win10 can ah,
If the server, recommend Windows server2019,

Of course, if you like Linux, Linux version of SQL server can also be installed

CodePudding user response:

reference 14 floor gypsy song reply:

Tao of second-hand computer and server are himself, the server is old, HpML350 also don't know can you install high version of the operating system, 11 holidays, anyway I try,

CodePudding user response:

I think it is not difficult to ah, it is ok to write a more general SQL

CodePudding user response:

reference 16 floor SuperDay response:

I think it is not difficult to ah, it is ok to write a more general SQL

Small white one, can you help to write a? Or have a learning source? Thank you for your higher-ups

CodePudding user response:

refer to 17th floor mind wander reply:

Quote: refer to the 16th floor SuperDay response:

I think it is not difficult to ah, it is ok to write a more general SQL

Small white one, can you help to write a? Or have a learning source? Thank you big coffee

I always is not provide the source code, can only provide train of thought, if you want to dynamically generated, through access to the data dictionary, can generate SQL execution after can produce json; If it is static is simple, it is good to write SQL death directly, need to, I give you write a simple demo

CodePudding user response:

But it is very simple, in fact, you can write: is the select string, write the field name in, for example: select '" name ":" | name from the TAB like this

CodePudding user response:

Demo to my study, to find some ideas, thank you for your great coffee

references the 19th floor SuperDay response:

but very simple, actually you can write: is the select string, and write the field name in, for example: select "" name" : "| name from the TAB that

CodePudding user response:

Well, writing is dead, it is very simple, if the data dictionary is estimated that more than your knowledge, that I didn't move