No problem 🙂

You can deploy projects with Powershell:

SSIS and PowerShell in SQL Server 2012

(first example, but it talks about deployment from filesystem to server. I think server to server should be possible...

You can query the system tables:

SELECT * FROM sys.columns

WHERE name LIKE '%_commodity_%'

or

SELECT * FROM INFORMATION_SCHEMA.columns

WHERE column_name LIKE '%_commodity_%'

Nice question, thanks!

At a SQL Server conference I was speaking at two weeks ago, I met one of the co-founders of lessthandot.com/[/url]. Later that day he asked me if I wanted to...

Revenant (11/28/2012)

---

For example - and it is one out of many -, when a result of an outer join is really big and the server runs out of disk space,...

Sean Lange (11/28/2012)

---

Actually this won't work. The second one here will find anything that contains a number. The first one will return only those contain nothing but a number. See...

There's no logical difference between NOT LIKE '%[^0-9]%' and LIKE '%[0-9]%'. Because the first one is a double negation, it will be the same when you leave all the negations...

sqlfriends (11/28/2012)

---

Thanks, and thanks for site link,...

Congrats for proving me wrong 😀

You put it in a SQL Server Agent job and schedule the job. In the schedule, you can specify to run it weekly, and select the days Monday through Friday.

^ is the negation. So %[^0-9.-]% means "every character that is not 0 through 9, a dot or the minus symbol".

LIKE (Transact-SQL)

I don't think you can.

You can't use the "USE database" statement in a stored procedure and you cannot qualify the schema with a database name in the CREATE SCHEMA statement.

Duplicate post. Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1389518-391-1.aspx

The only correct answer is 0.

There are 8 statements in the estimated execution plan, but no queries.

From BOL:

Query...