Viewing 15 posts - 2,281 through 2,295 (of 2,894 total)
http://msdn.microsoft.com/en-us/library/ms190215.aspx
You will find disadvantages at the bottom of article...
August 9, 2011 at 5:17 am
I have an advice:
Could you please check out the link at the bottom of my signature. You will find the information about how to setup your question in the way...
August 9, 2011 at 4:45 am
What this one to do with T-SQL?
Do you want to rename files?
Jscript, VBScript, DOS Batch
or best choice:
PowerShell
T-SQL is the language to manipulate with data in the relational...
August 8, 2011 at 6:17 am
You have two ways to terminate the group of batches:
1. Raise error with severity of 20:
raiserror('Error Here!', 20, -1) with log
But you will need to be logged in as...
August 8, 2011 at 3:06 am
Same effect, I prefer first one as it shows more clearly that you are locking table which you are inserting to.
August 5, 2011 at 8:14 am
SELECT RIGHT('000'+CAST(CAST(MyField * 100.0 AS INT) AS VARCHAR(4)),4)
August 5, 2011 at 8:10 am
It's very eay in sql2000 and I will be more than happy to help you write a query to do this if you will provide a ddl and sample data...
August 5, 2011 at 7:13 am
Gianluca Sartori (8/5/2011)
I had to look at the name, address, city and many other things to detect duplicates and it was a lot of trial and error.
Many algorithms had to...
August 5, 2011 at 4:02 am
If you are talking about table where you are going to store personal details, then you shouldn't even think creating and validation the person names due to the following possible...
August 5, 2011 at 3:29 am
Sorry, I should have advise you about this setting straight away...
But, I'm happy that your problem is finally soved. Good Luck!
August 4, 2011 at 1:56 pm
Try to use
SET ANSI_WARNINGS OFF
August 4, 2011 at 1:30 pm
Good Luck!
August 4, 2011 at 1:27 pm
Can you please provide the DDL for all tables involved and full code you have?
It's hard to guess where it may fail. However the error is quite exact: somedata...
August 4, 2011 at 10:55 am
In your case it's very simple:
SELECT 'aagarwa', 'i3.gt.qc', 'i3.India.Gurgaon', 'QTP_CSA Quest_i3_to_MS'
If you need more relevant answer, please use the link in my signature. You will find some information there which...
August 4, 2011 at 10:39 am
You get an Oracle error, it is nothing to do with SQL Server.
Can you execute this query successfully in Oracle itself?
Do you have up-to-date OracleOledb driver?
August 4, 2011 at 9:56 am
Viewing 15 posts - 2,281 through 2,295 (of 2,894 total)