Viewing 15 posts - 61 through 75 (of 390 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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
June 17, 2014 at 4:41 am
Thanks for question.It reminds me the trick to delete the duplicate records in a table 🙂
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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 🙂
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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 ?
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
June 16, 2014 at 4:27 am
Nicely framed QotD. Thanks Andy.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
June 16, 2014 at 4:06 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'
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
June 13, 2014 at 4:41 am
Thanks for question Steve.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
June 13, 2014 at 2:12 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='+...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
June 13, 2014 at 1:58 am
Thanks for question.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
June 12, 2014 at 4:02 am
Viewing 15 posts - 61 through 75 (of 390 total)