Viewing 15 posts - 2,686 through 2,700 (of 3,738 total)
raaz66 (7/15/2011)
how to export database from oracle10g to sql server2008
I have used DTS (in the past) and SSIS to migrate date from Oracle to SQL Server.
The largest was only about...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 7:08 am
Subrata Bauri (7/15/2011)
GilaMonster (7/15/2011)
I will add a Column Like Entry No. and define it as Primary Key in the Table. I will increment the value of this Column at...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 7:01 am
I just tested a DDL Rollback on a Create Table Statement and I was able to Rollback the Transaction.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 6:54 am
GilaMonster (7/15/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 6:21 am
GilaMonster (7/15/2011)
Welsh Corgi (7/15/2011)
Do DDL statements always give you an implicit commit, or can you get an implicit rollback?
That question is tagged Oracle and the answers are Oracle-specific. Can't draw...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 6:17 am
Just to add to what was already said you can go into add/remove programs and looking for Microsoft SQL Server 2008 (Server) and several other options.
But if you see the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 6:12 am
Jayanth_Kurup (7/15/2011)
Correct. I proposed identity column as primary key only to uniquely identify each row in the table.So the identity column itself will never have duplicates.
Yes the Identity value...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 5:52 am
I believe that you are refering to the following issue:
SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 5:46 am
Jayanth_Kurup (7/15/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 5:35 am
Do DDL statements always give you an implicit commit, or can you get an implicit rollback?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 5:24 am
Subrata Bauri (7/15/2011)
Dear Sir,
Why not Dear Ma'am? 😀
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 5:14 am
Subrata Bauri (7/15/2011)
I just want to know why does SQL Server allow duplicate value. What is thepurpose behind it ?
duplicate value may create some issues.
In most cases it is undesirable...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 5:12 am
Check and update your Data:
SELECT PiData.Date, PiData.Assoc_Name, PiAssoc.MgrName, PiData.Func_Name, PiData.Total_Proc,
PiData.Prod_Hrs, PiData.Paid_Hrs, Total_Proc/Prod_Hrs AS PPH, PiFunc.PPH_Goal,
PiData.Prod_Hrs/PiData.Paid_Hrs AS PTP, PiFunc.PTP_Goal
FROM tbl_PI_Functions AS PiFunc
FULL OUTER JOIN tbl_PI_Data AS PiData ON PiFunc.Func_Name...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2011 at 4:13 am
You may want to double check the steps?
http://msdn.microsoft.com/en-us/library/ms186354.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 14, 2011 at 9:45 am
I forgot to mention that I resolved this issue. I got so many responses that I could not keep track of them. 🙂
Regards,
WC
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 13, 2011 at 4:31 pm
Viewing 15 posts - 2,686 through 2,700 (of 3,738 total)