Viewing 15 posts - 61 through 75 (of 389 total)
Again it seems a disputed question :blink:
Seems the language of question can be verified again.However I have seen that Andy has posted his QotD very well but somehow he missed...
June 18, 2014 at 1:28 am
BWFC (6/17/2014)
rhythmk (6/17/2014)
BWFC (6/17/2014)
rhythmk (6/17/2014)
Thanks for question.It reminds me the trick to delete the duplicate records in a table 🙂
Could you enlighten me on that please? It sounds very...
June 18, 2014 at 1:06 am
sugnu iu (6/17/2014)
dev environment
So are you ok with dropping a table having 90 million records from any environment ? Think of the scenario when you are working on some urgent...
June 17, 2014 at 11:55 pm
Koen Verbeeck (6/17/2014)
rhythmk (6/17/2014)
Koen Verbeeck (6/17/2014)
You can use INFORMATION_SCHEMA.columns for the same purpose. Filter on the table and check if the column exists.It is applicable to both.
And that is...
June 17, 2014 at 5:32 am
Koen Verbeeck (6/17/2014)
You can use INFORMATION_SCHEMA.columns for the same purpose. Filter on the table and check if the column exists.
It is applicable to both.
June 17, 2014 at 4:50 am
BWFC (6/17/2014)
rhythmk (6/17/2014)
Thanks for question.It reminds me the trick to delete the duplicate records in a table 🙂Could you enlighten me on that please? It sounds very useful.
Here you...
June 17, 2014 at 4:41 am
Thanks for question.It reminds me the trick to delete the duplicate records in a table 🙂
June 17, 2014 at 12:58 am
I went to Source OLEDB, Advanced Editor and Input and Output parameters.
hmm...that's what Koen replied earlier 🙂
June 17, 2014 at 12:20 am
ramrajan (6/16/2014)
DONE
What is this ? :unsure:
Can you please let us know what was the issue and what you have DONE ?
June 16, 2014 at 5:19 am
I am getting below warning message while executing the package and eding up loading half of the data nd failing the package.
Truncation may occur due to retrieving data from database...
June 16, 2014 at 4:27 am
SELECT @sql = ‘bcp “select * from MM_DEV_T_D2_P..app_case” queryout E:\files\files\1.txt -c -t’+’”|”‘+’ -T -S @@servername’
Try below.
SELECT @sql = 'bcp "select * from MM_DEV_T_D2_P..app_case" queryout E:\files\files\1.txt -T -c'
June 13, 2014 at 4:41 am
sekhar.kandregula (6/13/2014)
Hi ,set @cmd='bcp "SELECT * from #temp1 where case_id='+ QUOTENAME(@RecLoc, '''') +'" out e:\Files\file5\1.txt -c -t, -T -S'+ @@servername
Try below.
set @cmd='bcp "SELECT * from #temp1 where case_id='+...
June 13, 2014 at 1:58 am
Viewing 15 posts - 61 through 75 (of 389 total)