constraints

RE: Checking on Backup - Quick Question

• by mccork

• MSSQLTips.com

• Reply

Those busy objects are MYSQL components (data, log and error files). Looks like you're trying to back up MYSQL database files whilst the Mysql service is still running.

2003-06-29

RE: Multi Row Insert?

• by kraks

• SQLServerCentral

• Reply

insert into tblCustPreference( custguid, name, ) SELECT x.custguid, x.name, FROM OPENXML (@xdoc, '*/cust/coldata',1) WITH ( custguid uniqueidentifier, name varchar(25), ) as x

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-28

RE: DBA in PHX

• by eljeffo

• SimpleTalk

• Reply

Steve, I'm not offended, and I use the forums daily. That won't stop. There are a few billion people on the planet, and all have different opinons, and each person thinks theirs is the best one. Those with similar opinions congregate, and those with different ones congregate elsewhere. No offense intended, and none taken. Jeff

2003-06-19

RE: Connecting to MySQL server

• by Brian Kelley

• MSSQLTips.com

• Reply

Use OPENQUERY. I don't believe the MyODBC driver exposes the proper interfaces for a 4-part naming convention. As an example: SELECT * FROM OPENQUERY(portal, 'SELECT * FROM nuke_users') K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

2003-05-29

RE: Is Steve Jones Really Steve Jones?

• by Nicholas-Wang

• MSSQLTips.com

• Reply

😀 hahaha... that guy is probably better known as the cool guy in "Mummy" and "Mummy Returns" (First movie far better than 2nd one, though the 2nd one shows a lot more of the "butt" of the first one 😉 }:))

2003-05-27

RE: Check Columns Exist Before Select

• by Crispin

• Builder.com

• Reply

Would it not be better to go through all the tables and add the column? This will save SQL the time and trouble (Read: Overhead) of having to work it out? How many tables are there? If there are lots, you could write a script wich will alter all of them by adding a column […]

2003-05-25

1 reads

RE: Thanks for taking the test!

• by powilliams

• Builder.com

• Reply

Good test. It has been a while since I've had to think some things through, but ultimately, I think it was too easy. After all, if I could ace it, it must be too easy. Thanks to all for putting it together. I can't wait for the next installment.

2003-05-22