Viewing 15 posts - 1,141 through 1,155 (of 11,678 total)
Small modification:
EXEC master.dbo.sp_msforeachdb 'USE [?];
SELECT t.name, c.name, ''?'' AS [database]
FROM sys.tablest
JOIN sys.columnsc ON t.[object_id] = c.[object_id]
WHEREt.[type] = ''U''
AND c.name LIKE ''PAtient_Something%'';';
January 19, 2015 at 1:31 pm
You linked two Boolean expressions together with AND, meaning both must return TRUE in order for the WHERE clause to return TRUE.
However, looking at the first parts already leads to...
January 19, 2015 at 1:28 pm
I have run against the same issue with filter tables in Excel. In the end I filtered them out just like you did.
Regarding your question about other kind of tables...
January 19, 2015 at 1:25 pm
There is no need to use caps. It's pretty annoying.
Something real quick I came up with:
EXEC master.dbo.sp_msforeachdb 'USE [?];
SELECT t.name, c.name
FROM sys.tablest
JOIN sys.columnsc ON t.[object_id] = c.[object_id]
WHEREt.[type] = ''U''
AND...
January 19, 2015 at 1:20 pm
GilaMonster (1/19/2015)
January 19, 2015 at 10:41 am
kevaburg (1/19/2015)
Koen Verbeeck (1/19/2015)
David Burrows (1/19/2015)
When I want to deploy I select Build/Configuration Manager...
January 19, 2015 at 10:41 am
David Burrows (1/19/2015)
When I want to deploy I select Build/Configuration Manager from the menu...
January 19, 2015 at 7:11 am
Grant Fritchey (1/19/2015)
Eirikur Eiriksson (1/19/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be...
January 19, 2015 at 5:57 am
What I would do:
* Read the flat file like you normally would, i.e. with a flat file source. You can use a for each loop container with a wildcard to...
January 19, 2015 at 2:21 am
I believe - but don't quote me on this - you get some MSDN subscriptions.
(Or you have to be a gold partner for this)
Sometimes when MS is working with a...
January 19, 2015 at 2:14 am
TomThomson (1/16/2015)
Koen Verbeeck (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.
The question of today wasn't bad...
January 19, 2015 at 12:30 am
The WHERE clause is for the SQL statement in the data set 🙂
Instead of using NULL in the filter, use "Nothing" instead.
January 19, 2015 at 12:10 am
Nice trivia, thanks.
January 16, 2015 at 1:18 am
It seems strange to me that adding a column would cause the table to be dropped. Did you use the ALTER TABLE statement?
In my opinion, the blank column issue could...
January 16, 2015 at 12:37 am
ChrisM@Work (1/15/2015)
Koen Verbeeck (1/15/2015)
ChrisM@Work (1/15/2015)
+ '
FROM employee m
LEFT JOIN shiftdetails b ON m.empno = b.empno
where b.shifttype = ''' + @shifttype +...
January 15, 2015 at 5:17 am
Viewing 15 posts - 1,141 through 1,155 (of 11,678 total)