Viewing 15 posts - 11,116 through 11,130 (of 13,469 total)
Greg Snidow (5/11/2009)
I can't see why Lowell's solution does not work, unless everyone, regardless of whether or not they have a photo present, exists in the table selling_photo.
I'm with Greg,...
May 11, 2009 at 8:25 pm
this seemed to work for me, but i only had one table with no index:
select distinct object_name(syscolumns.id),
syscolumns.name As CalculatedColumn ,
syscomments.text as TheCalculation,
isnull(object_name(SYSINDEXKEYS.id),'No Index Using This CalculatedColumn') As IndexName
from...
May 11, 2009 at 5:26 pm
syscolumns has a iscomputed column...the calculation is stored in syscomments if you want to join to get that:
now to get the indexes, that i'm not sure yet....
select object_name(syscolumns.id),
syscolumns.name As CalculatedColumn...
May 11, 2009 at 5:05 pm
get the script "sp_generate_inserts" from Narayana Vyas Kondreddi at http://vyaskn.tripod.com
he's got a 200 and 2005 versions, and they generate INSERT INTO [YOURTABLE]....statements for you by simply passing it the tablename.
be...
May 11, 2009 at 11:11 am
using COLUMNS_UPDATED, you can't, i guess you'd have to write your trigger to do each column individually, if that's what you wanted to do:
IF (UPDATE(DESCRIP) )
BEGIN
[same code example]
END
IF (UPDATE(COLUMN2) )
BEGIN
[same...
May 11, 2009 at 9:04 am
the inner join would only show members with records int he detail table...you want a left outer join instead:
SELECT DISTINCT email
FROM Member usr
LEFT OUTER JOIN Selling_Photo pho
...
May 11, 2009 at 8:23 am
lleemon13 (5/11/2009)
May 11, 2009 at 8:20 am
yes you can.
Paul is right..if you take your backup .bak file, you can restore it on any SQL 2005 instance, but behind the scenes it will be upgraded to the...
May 11, 2009 at 7:53 am
enterprise? no, that would be illegal. standard and enterprise are all purchases, and often involve thousands of dollars in licensing.
developer edition costs 50 dollars on amazon.com, and allows you to...
May 11, 2009 at 7:42 am
ive always used the oracle driver from the client install, but the previous poster is right...you might need to install the driver first:
SET @provider = N'ORAOLEDB.Oracle' --optionally 'MSDAORA' to use...
May 11, 2009 at 7:01 am
behind the scenes, the length is set to -1 for the column in syscolumns. can you set the width to -1 instead of 8000?
May 11, 2009 at 6:58 am
raw text or RTF? editplus can do that easily to raw text,you just set a macro to search for a term to find the start, then make it select while...
May 10, 2009 at 3:20 pm
within a trigger, there is a couple of functions you can use you can use to determine if a column has changed:
IF (UPDATE(columnname) ) returns true or false, if you...
May 10, 2009 at 6:01 am
are the columns in the spreadsheet in the same order as the columns in the dataset?
what i mean is, if the spreadsheet has 10 columns today, and 14 columns tomorrow,
do...
May 10, 2009 at 5:31 am
not on the screens you were setting up; that set up the profile, where it is only one account.
if you want replys to any email to go to multiple persons,...
May 10, 2009 at 5:15 am
Viewing 15 posts - 11,116 through 11,130 (of 13,469 total)