Questions tagged [source-code]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
333 views

Source code of View of Linked server sp_HelpText

How to use sp_helptext for view on the linked server ?
1
vote
1answer
184 views

PostGIS error building with `make` in ./extensions: make[1]: *** No rule to make target

Whenever I run make in extensions, I'm getting error. make for DIR in postgis postgis_tiger_geocoder postgis_topology address_standardizer; do \ echo "---- Making all in ${DIR}"; \ make -C "...
2
votes
1answer
86 views

PostGIS error building with `make` in ./extensions: nothing to be done for 'comments'

I'm using code I checked out from SVN. Whenever I run make in ./extensions/, I get make for DIR in postgis postgis_tiger_geocoder postgis_topology address_standardizer; do \ echo "---- Making ...
0
votes
0answers
85 views

How to selecting data from two queries using union?

I have three tables. I am trying to taking the data with two times interval after then subtracting from first two second for every possible row and getting the ledger report. Solution is given by: ...
1
vote
0answers
322 views

SQLite insertion with junction table

I need to write a transaction for SQLite, that adds a blog post and links it to content tags, and it seems to be a bit too complicated for me. Here's an example schema: CREATE TABLE blogpost( ...
0
votes
1answer
146 views

Can't find source code for building mysql

I'm trying to follow the instructions for building MySQL from source. They guide me to a link where I can download the latest GA. I end up at the downloads page, where I can download mysql-5.6.19-...
1
vote
1answer
191 views

Implementing a simple ERD in MySQL: is the implementation below 100% compliant with the ERD?

ERD Consider the following ERD: Tables From it, I derived the following tables: Company ------------------ c_id c_name ------------------ CompanyEmail ------------------ c_id e_id --...
0
votes
2answers
2k views

Is there a way to examine SQL Jobs for references to linked servers?

In preparation for migrating a server farm to the cloud, I am attempting to enumerate all the linked servers that have been defined over the years. I also need to find (and correct) the code that ...
6
votes
1answer
28k views

Show procedure code in MySQL

I've tried to show the SQL code of a stored procedure called add_pixel: mysql> SHOW PROCEDURE CODE add_pixel; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that ...