Viewing 10 posts - 1 through 10 (of 10 total)
figured it out.. just have to look at sys.foreign_key_columns catalog view.
August 13, 2009 at 5:12 pm
currently i am building the recordset in OLE Source using T-SQL. I want to know if there is a way to do it in ssis itself. I am testing aggregate...
May 28, 2009 at 1:02 pm
select col1, col2, col3 from
group by col1, col2, col3
May 28, 2009 at 12:29 pm
Thanks gail..
select objectproperty(object_id(N),'TableHasIdentity')
April 28, 2009 at 3:19 pm
This is what I came up with..
if (select max(cast(is_identity as int)) from sys.columns where object_id = object_id(@tname))=1
then identity column exists
else identity column dont exists..
is there a better way?
April 28, 2009 at 3:15 pm
i figured it out.. simple update will work
declare @timeline table(
[month] varchar(8),
[enddate] varchar(8),
flag char(1)
)
update t1 set...
March 6, 2008 at 5:26 pm
my login does not have permission to run those commands on the server. I am not a member of the sysadmin role. thanks for the help. in the future, i will...
December 28, 2006 at 6:49 pm
i dont have permission to execute dropcleanbuffers or freeproccache
December 28, 2006 at 6:15 pm
even after updating statistics the numbers are not matching. The table has 75 columns and row size is 842 bytes. there are around 1,000,000 rows in the table. I have...
December 28, 2006 at 5:35 pm
Viewing 10 posts - 1 through 10 (of 10 total)