Viewing 15 posts - 61 through 75 (of 104 total)
GilaMonster (3/5/2009)
No worries. Please in future explain the entire problem up front.What are you still having a problem with?
Ya sure I will,
now the problem is,
in the below code, instead of...
March 5, 2009 at 2:16 am
GilaMonster (3/5/2009)
If you'd mentioned anywhere that this was an Access table, I wouldn't have spent 30 min finding that util, finding the page and suggesting is as an option.
Hi Gail,
I...
March 5, 2009 at 1:41 am
Michael Valentine Jones (3/4/2009)
You should start by thinking through what you actually want, and then asking that question, instead...
March 4, 2009 at 11:19 pm
GilaMonster (3/4/2009)
Santhosh (3/4/2009)
but the requirement is1. to compare two tables
If all you're trying to do is compare two tables, have you considered using the tablediff utility that comes with...
March 4, 2009 at 10:48 pm
Hi,
Here is the full code that I have written till now,
ALTER PROCEDURE USP_Compare_Gen
@table1 SYSNAME,
@table2 SYSNAME,
@memo1 VARCHAR(100) = '' --have to declare an ARRAY variable or something like that
/*,
@memo2 VARCHAR(100) =...
March 4, 2009 at 6:42 am
Hi,
I have a sproc usp_compare
exec usp_compare table1,table2, c1,c2 --,c3,c4,c5
inside sproc I have
alter proc usp_compare_temp
@t1 sysname,
@t2 sysname, --please ignore this for now
@c1 varchar(100),
@c2 varchar(100)
--is it possible to declare array...
March 4, 2009 at 5:17 am
Mangal Pardeshi (3/4/2009)
Santhosh (3/4/2009)
but the requirement is
1. to compare two tables
2. in these two tables there are 50 columns
3. 1 or 2 or 3(max) columns are...
March 4, 2009 at 4:22 am
Thanks Flo and Gail,
but the requirement is
1. to compare two tables
2. in these two tables there are 50 columns
3. 1 or 2 or 3(max) columns are of type NTEXT
4....
March 4, 2009 at 3:11 am
florian.reischl (3/4/2009)
Oups... did not yet get my breakfast...Thanks and sorry
Flo
Its ok Flo,
that gave me a chance to think a little.. 😎
March 4, 2009 at 2:55 am
florian.reischl (3/4/2009)
DECLARE @excluded_columns TABLE (name SYSNAME)
DECLARE @table_name SYSNAME
DECLARE @columns NVARCHAR(MAX)
SET @table_name = 'Person.Contact'
-- Excluded columns
INSERT INTO @excluded_columns VALUES ('Suffix')
INSERT INTO @excluded_columns VALUES ('rowguid')
SET @columns = ''
SELECT @columns =...
March 4, 2009 at 2:42 am
Yes, it works..
Thanks again.
March 3, 2009 at 4:10 am
srikant maurya (3/2/2009)
Use below sql statment ,select * from information_schema.columns where charindex(' ',column_name)>0
Thanks....it worked
March 2, 2009 at 11:47 pm
dharaneeswar_reddy (3/2/2009)
this may help u ...plzzzz try this. it is working
select * from information_schema.columns where column_name like '% %' and table_name like '%give the table name>%'
Hi, Thanks
but this won't...
March 2, 2009 at 11:18 pm
Hi
In Linked Server(Access database)
Can we know which columns are having ntext data type?
(when i went through the sproc sp_columns_ex i came to know that
MEMO data type of Access...
February 12, 2009 at 3:44 am
Chris Morris (2/12/2009)
IF OBJECT_ID('tempdb..#Worksheets') IS NOT NULL
DROP TABLE #Worksheets
CREATE TABLE #Worksheets (TABLE_CAT varchar(30), TABLE_SCHEM VARCHAR(30), TABLE_NAME VARCHAR(50), TABLE_TYPE VARCHAR(20), REMARKS VARCHAR(30))
INSERT INTO #Worksheets
EXEC...
February 12, 2009 at 3:36 am
Viewing 15 posts - 61 through 75 (of 104 total)