HI Experts,
I have same table structures in two database and one master table which contains Table id, Table name,primary key, data type of primary key. i have to comapare
Tables in both tha database and as per result i have to do insert,update or delete.
for that i have written query :
DECLARE @rowcount_maste rtable FLOAT
SET @rowcount_maste rtable = (select count(*) from...
aviansh
Last Activity: Dec 14 '07, 02:47 AM
Joined: Dec 4 '07
Location:
-
How to use value of a variable in defining data type
-
Can anyone help on thhis ? -
How to write loop in Sql server 2005
Hi Experts,
I have two database in same server I.e. D1 and D2. D1 has one table T1 and D2 has one table T2. T1 and T2 is having same table structure and same columns. But D1 is online database and D2 is offline database.D1 will be updating regularly but for D2 I have to update once in day. In T1 and T2 we have column Time_created (it will capture the time when data is created) and Time_modified (it will capture the time when data is... -
Thanks Deepu..It's working fine.Leave a comment:
-
How to fetch data from other data base
Hi Experts,
I am using sql server 2005. I have two database in same server i.e. DB1 and DB2. DB1 contains table1 and DB2 contains table2.
i have to run a sql query in DB2 to fetch data from table1 and to update in table2.
Please suggest.
Thanks in advance.
No activity results to display
Leave a comment: