I went Here or there and it didnt work.
I hate Stack Exchange.This post DOES meet quality stanrads When i try to chat is asking for stupid reputation.I am going to spam this website with links to gop.com and wnbc.com UNTIL Stack Exchange idiots learn from this and disable repuation and let evey...
i want pass bunch of Update queries in the form of array to pl/pgsql function as parameter and there i need to execute those sql update queries. is it possible.please help me to get out of this.
So, I've got a db instance on my local machine (\dev) and I want to connect to it from a server (let's call it redgate - running sql compare of course) on the network. How can I connect to my local machine? I've got the instance running with TCP enabled and named pipes, and I have no firewall running on my local machine (I live inside a intranet, why do I need firewalls, seriously)
What would be good reasons Redgate can't talk to the local db on my machine when it can talk to the instance on other servers? And I think I just figured it out ...
connecting to \\cole's machine and not \\cole's machine\dev ... I win a cookie if that's it, right?
You don't need agent and browser. Without advertising the SQL Server instance, you can still reach it
On an elevated command prompt, run this netstat -a -n -b -p TCP and check the SQL Server port
From the remote server, try telnet COLE 1433 or whatever the portnum was, and assuming your machine was named COLE
It's also more than likely you forgot to enable TCP IP for remote connections. Start->Microsoft SQL Server 2008/2012->Configuration Tools->SQL Server Configuration Manager
Under SQL Server Network Configuration->Protocols for MSSQLSERVER and on the right, TCP/IP: Disabled
The answer here is "it's complicated." You can actually go quite far with a procedural language (including pl/java) but you are never going to get quite the flexibility you can get with C. What is fundamentally missing is being able to do proper indexing support in PL/Java. For quite a bit mor...
I am a flipping idiot. I was running my VM in NAT mode because they haven't laid network drops yet and it's only been 2 wweeks I've been without a netdrop
@JackDouglas What pl/java basically does is allow you to wrap Java code inside the stored procedure framework. I could probably explain that better. Clarifying it
We are running SQL Server 2008 R2 SP1 as publisher & distributor, and SQL Server 2005 SP3 as subscriber. The replication of schema changes is activated, and the replication has been running for years, including frequent schema changes (new column, new constraints, etc).
The following instructio...
Dont use MySQL, a relational database is not used for the solution of this type of problem. Use a document or NoSQL database such as MongoDB or possibly RavenDB on windows.
Don't just throw such a sentence here. Such sentences aren't used to answer this type of question but to sell something. Use explanation on DBA.SE. — dezso8 secs ago
Having an issue with FKs, I googled the issue and got pointed to an answer on DBA.SE! Awesome! The answer is exactly what I needed. Go to upvote and get message "You can't vote for your own post."
Let me start by saying that I know that there is gamification in receiving tag-badges. Users* want the badges to show they have skills in certain areas.
I am active the sql tags and I have seen an increase in what I would call bad tagging. Examples of bad tagging, include adding select, MySQL e...
@bluefeet well you've got to understand that gamification is what moves some of us. It's just human behavior. Although he just adds stupid tags, it's not very harmful to just see yourself over another guy.
He's just creating a list where he's the first one :-).
@Marian But the point of the tags is to be helpful for users in finding solutions. The mysql-error-1064 tag is completely pointless and most of the errors are too localized questions anyway. I would guess that 95% of those errors are syntax issues that will not help anyone
This is discussed a little bit here as well.
The tag mysql-error-1064 is on almost 1000 questions at this point. It is also useless.
The error code in question is about the most generic error you can get - "There is an error in your syntax"!
If you need help, searching using this tag is usele...
I'm getting the error
'socketServer.Form1' does not contain a definition for 'Dispatcher' and no extension method 'Dispatcher' accepting a first argument of type 'socketServer.Form1' could be found
From
private void tbAux_SelectionChanged(object sender, EventArgs e)
{
this.Dispatcher....
Okay, so here's the create statement for one of the tables I'm working on for a class project:
---This query will create all the rows for the Vendor table for my small independent bookstore.
---The Vendor address and zip code attributes can be null due to the fact that we do not
---necessarily ...
@bluefeet I didn't say it's useful. That particular error I'd even remove as I never saw it helpful. I just said he's behaving like he wants something more than easy points. He also wants easy badges.
@JNK I don't take life too seriously, so I'd build a new tag each day. And if I'd be one of SO's programmers I'd mix people's images and points randomly :-).
I'm having a verry strange problem. I am certain I have done nothing wrong in this line of code:
INSERT INTO
oc_address
(`cust_id`, `firstname`, `lastname`, `address_1`, `city`, `postcode`, `country_id`)
SELECT
(`cust_id`, `first_name`, `last_name`, `address`, `city`, `posta...
@PaddyCarroll please add some more substance to this answer, or I'll consider it a comment and convert it for you. "Don't do that" isn't an answer unless it also includes a "Do this instead" and you don't explain ANYTHING about why he should choose one implementation over another. — JNK4 hours ago
I'm getting the following error when I try to fire off a query to join 3 tables using mysql:
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group INNER JOIN mahara.group_member as group_...
I want to generate the following data set for use with DataTables. For the filtering and sorting to work properly, using JOINS instead of subqueries is difficult, if not impossible (as far as I can tell).
Applicant Name, Position, Interviewer, Interview 1 Score, Interview 2 Score, Demo. Score, ...
room topic changed to Vote to ellipsis: A place for quick chats about retags, questions that need to die etc. For general bollocks, see "the heap" http://chat.stackexchange.com/rooms/179/the-heap (no tags)
just so you know what i get to deal with ... i stumble across crap like this on a daily basis
select
distinct
ltrim(a.t_item) as ParentItem,
ltrim(a.t_dsca) as ParentDescription,
(select ltrim(t_revi) from edm
where t_indt = (select max(t_indt) from edm where ltrim(t_eitm) = ltrim(a.t_item))--@item)
and ltrim(t_eitm) = ltrim(a.t_item)) as ParentRevision,
max(t_indt) as ParentEffectiveDate
from
itm a
join
edm b
on ltrim(a.t_item) = ltrim(b.t_eitm)
where
ltrim(t_item) = in (select * from Split(@ItemList,',')) --@item
group by a.t_item, a.t_dsca
i want pass bunch of Update queries in the form of array to pl/pgsql function as parameter and there i need to execute those sql update queries. is it possible.please help me to get out of this.
The answer here is "it's complicated." You can actually go quite far with a procedural language (including pl/java) but you are never going to get quite the flexibility you can get with C. What is fundamentally missing is being able to do proper indexing support in PL/Java. For quite a bit mor...
We are running SQL Server 2008 R2 SP1 as publisher & distributor, and SQL Server 2005 SP3 as subscriber. The replication of schema changes is activated, and the replication has been running for years, including frequent schema changes (new column, new constraints, etc).
The following instructio...
Dont use MySQL, a relational database is not used for the solution of this type of problem. Use a document or NoSQL database such as MongoDB or possibly RavenDB on windows.
Error
SQL query:
CREATE TABLE RscCompView(
RscCompViewID int( 11 ) NOT NULL AUTO_INCREMENT ,
RscCompID int( 11 ) DEFAULT '0' NOT NULL ,
req_dateTIMESTAMP( 14 ) ,
PRIMARY KEY ( RscCompViewID ) ,
KEY req_date( req_date ) ,
KEY RscCompID( RscCompID )
);
MySQL said: Documentation
1064 - You h...
This is discussed a little bit here as well.
The tag mysql-error-1064 is on almost 1000 questions at this point. It is also useless.
The error code in question is about the most generic error you can get - "There is an error in your syntax"!
If you need help, searching using this tag is usele...
I'm getting the error
'socketServer.Form1' does not contain a definition for 'Dispatcher' and no extension method 'Dispatcher' accepting a first argument of type 'socketServer.Form1' could be found
From
private void tbAux_SelectionChanged(object sender, EventArgs e)
{
this.Dispatcher....
Okay, so here's the create statement for one of the tables I'm working on for a class project:
---This query will create all the rows for the Vendor table for my small independent bookstore.
---The Vendor address and zip code attributes can be null due to the fact that we do not
---necessarily ...
I'm having a verry strange problem. I am certain I have done nothing wrong in this line of code:
INSERT INTO
oc_address
(`cust_id`, `firstname`, `lastname`, `address_1`, `city`, `postcode`, `country_id`)
SELECT
(`cust_id`, `first_name`, `last_name`, `address`, `city`, `posta...
Creating and traverse by using n Primary Key and n foreign keys and relations? on oracle 11g
I'm trying to extract the City from an Address Field in a MS SQL DataBase
I'm getting the following error when I try to fire off a query to join 3 tables using mysql:
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group INNER JOIN mahara.group_member as group_...
I want to generate the following data set for use with DataTables. For the filtering and sorting to work properly, using JOINS instead of subqueries is difficult, if not impossible (as far as I can tell).
Applicant Name, Position, Interviewer, Interview 1 Score, Interview 2 Score, Demo. Score, ...
