| Groups | Blog | Home |
sql server clients : Osql Help
osql /Usa /Pngsol -n /ic:\Query.qry /o c:\titles.TXT -- ******************************************************************* Andy S. MCSE NT/2000, MCDBA SQL 7/2000 andymcdba1@NOMORESPAM.yahoo.com Please remove NOMORESPAM before replying. Always keep your antivirus and Microsoft software up to date with the latest definitions and product updates. Be suspicious of every email attachment, I will never send or post anything other than the text of a http:// link nor post the link directly to a file for downloading. This posting is provided "as is" with no warranties and confers no rights. ******************************************************************* [quoted text, click to view] "Noorali Issani" <naissani@lycos.co.uk> wrote in message news:e21yyea5DHA.2008@TK2MSFTNGP10.phx.gbl... > Dear Professional > > I have used the following query > > osql /U sa /P ngsol /i c:\Query.qry /o c:\titles.TXT > > > That above query gave me the correct result in titles.Txt file but the > problem is that in the top I have received the following stuff which I wanna > remove it and how can I do this ? > > > 1> 2> 1> 2> 1> 2> > > > > ------------------------------------------------------------------------- -- > --- > ----------------------------------------------------------------------- > ----------------------------------------------------------------------- > ----------------------------------------------------------------------- > ----------------------------------------------------------------------- > ----------------------------------------------------------------------- > ----------------------------------------------------------------------- > ---------------------------------------------------- > > What I do ? > > Waiting for your reply > > Noor > >
Dear Professional
I have used the following query osql /U sa /P ngsol /i c:\Query.qry /o c:\titles.TXT That above query gave me the correct result in titles.Txt file but the problem is that in the top I have received the following stuff which I wanna remove it and how can I do this ? 1> 2> 1> 2> 1> 2> --------------------------------------------------------------------------- --- ----------------------------------------------------------------------- ----------------------------------------------------------------------- ----------------------------------------------------------------------- ----------------------------------------------------------------------- ----------------------------------------------------------------------- ----------------------------------------------------------------------- ---------------------------------------------------- What I do ? Waiting for your reply Noor
The only way you can return text without separators is to use a print
statement. Then you can use SET NOCOUNT ON to hide the number of rows affected. PRINT can be used with local variables, global variables and text. Otherwise, the separators are pretty much part of SQL statements. There is no SET statement I know to turn it off. -- ******************************************************************* Andy S. MCSE NT/2000, MCDBA SQL 7/2000 andymcdba1@NOMORESPAM.yahoo.com Please remove NOMORESPAM before replying. Always keep your antivirus and Microsoft software up to date with the latest definitions and product updates. Be suspicious of every email attachment, I will never send or post anything other than the text of a http:// link nor post the link directly to a file for downloading. This posting is provided "as is" with no warranties and confers no rights. ******************************************************************* [quoted text, click to view] "Noorali Issani" <naissani@lycos.co.uk> wrote in message news:%23OXpN6j5DHA.1040@TK2MSFTNGP10.phx.gbl... > thanks but how I remove this lines > > ------------------------------------------------------------------------- -- > --- > ----------------------------------------------------------------------- > ----------------------------------------------------------------------- > ----------------------------------------------------------------------- > ----------------------------------------------------------------------- > ----------------------------------------------------------------------- > ----------------------------------------------------------------------- > ---------------------------------------------------- > Waiting > > "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message > news:e$5Kg1b5DHA.2572@TK2MSFTNGP09.phx.gbl... > > You forgot the -n switch, that removes numbering. > > > > osql /Usa /Pngsol -n /ic:\Query.qry /o c:\titles.TXT > > > > -- > > ******************************************************************* > > Andy S. > > MCSE NT/2000, MCDBA SQL 7/2000 > > andymcdba1@NOMORESPAM.yahoo.com > > > > Please remove NOMORESPAM before replying. > > > > Always keep your antivirus and Microsoft software > > up to date with the latest definitions and product updates. > > Be suspicious of every email attachment, I will never send > > or post anything other than the text of a http:// link nor > > post the link directly to a file for downloading. > > > > This posting is provided "as is" with no warranties > > and confers no rights. > > > > ******************************************************************* > > "Noorali Issani" <naissani@lycos.co.uk> wrote in message > > news:e21yyea5DHA.2008@TK2MSFTNGP10.phx.gbl... > > > Dear Professional > > > > > > I have used the following query > > > > > > osql /U sa /P ngsol /i c:\Query.qry /o c:\titles.TXT > > > > > > > > > That above query gave me the correct result in titles.Txt file but the > > > problem is that in the top I have received the following stuff which I > > wanna > > > remove it and how can I do this ? > > > > > > > > > 1> 2> 1> 2> 1> 2> > > > > > > > > > > > > ------------------------------------------------------------------------ - > > -- > > > --- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > > ---------------------------------------------------- > > > > > > What I do ? > > > > > > Waiting for your reply > > > > > > Noor > > > > > > > > > > > >
thanks but how I remove this lines
--------------------------------------------------------------------------- --- ----------------------------------------------------------------------- ----------------------------------------------------------------------- ----------------------------------------------------------------------- ----------------------------------------------------------------------- ----------------------------------------------------------------------- ----------------------------------------------------------------------- ---------------------------------------------------- Waiting [quoted text, click to view] "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message news:e$5Kg1b5DHA.2572@TK2MSFTNGP09.phx.gbl... > You forgot the -n switch, that removes numbering. > > osql /Usa /Pngsol -n /ic:\Query.qry /o c:\titles.TXT > > -- > ******************************************************************* > Andy S. > MCSE NT/2000, MCDBA SQL 7/2000 > andymcdba1@NOMORESPAM.yahoo.com > > Please remove NOMORESPAM before replying. > > Always keep your antivirus and Microsoft software > up to date with the latest definitions and product updates. > Be suspicious of every email attachment, I will never send > or post anything other than the text of a http:// link nor > post the link directly to a file for downloading. > > This posting is provided "as is" with no warranties > and confers no rights. > > ******************************************************************* > "Noorali Issani" <naissani@lycos.co.uk> wrote in message > news:e21yyea5DHA.2008@TK2MSFTNGP10.phx.gbl... > > Dear Professional > > > > I have used the following query > > > > osql /U sa /P ngsol /i c:\Query.qry /o c:\titles.TXT > > > > > > That above query gave me the correct result in titles.Txt file but the > > problem is that in the top I have received the following stuff which I > wanna > > remove it and how can I do this ? > > > > > > 1> 2> 1> 2> 1> 2> > > > > > > > ------------------------------------------------------------------------- > -- > > --- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ---------------------------------------------------- > > > > What I do ? > > > > Waiting for your reply > > > > Noor > > > > > >
Nope, no switch I know of to hide lines.
You can use print to return certain variables, but the line separator is part of the results of a SQL statment. You can turn the count off and the line numbering off, but that's it. -- ******************************************************************* Andy S. MCSE NT/2000, MCDBA SQL 7/2000 andymcdba1@NOMORESPAM.yahoo.com Please remove NOMORESPAM before replying. Always keep your antivirus and Microsoft software up to date with the latest definitions and product updates. Be suspicious of every email attachment, I will never send or post anything other than the text of a http:// link nor post the link directly to a file for downloading. This posting is provided "as is" with no warranties and confers no rights. ******************************************************************* [quoted text, click to view] "Noorali Issani" <naissani@lycos.co.uk> wrote in message news:uUXpO9n5DHA.3548@TK2MSFTNGP11.phx.gbl... > Like there is command > osql /Usa /Pngsol -n /ic:\Query.qry /o c:\titles.TXT > > what I write for hidding lines. > > thanks in advance.. > > Noor > "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message > news:eRjdW3n5DHA.2748@TK2MSFTNGP09.phx.gbl... > > The only way you can return text without separators is to use a print > > statement. Then you can use SET NOCOUNT ON to hide the number of rows > > affected. PRINT can be used with local variables, global variables and > > text. > > > > Otherwise, the separators are pretty much part of SQL statements. There > is > > no SET statement I know to turn it off. > > > > -- > > ******************************************************************* > > Andy S. > > MCSE NT/2000, MCDBA SQL 7/2000 > > andymcdba1@NOMORESPAM.yahoo.com > > > > Please remove NOMORESPAM before replying. > > > > Always keep your antivirus and Microsoft software > > up to date with the latest definitions and product updates. > > Be suspicious of every email attachment, I will never send > > or post anything other than the text of a http:// link nor > > post the link directly to a file for downloading. > > > > This posting is provided "as is" with no warranties > > and confers no rights. > > > > ******************************************************************* > > "Noorali Issani" <naissani@lycos.co.uk> wrote in message > > news:%23OXpN6j5DHA.1040@TK2MSFTNGP10.phx.gbl... > > > thanks but how I remove this lines > > > > > > ------------------------------------------------------------------------ - > > -- > > > --- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > > ---------------------------------------------------- > > > Waiting > > > > > > "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message > > > news:e$5Kg1b5DHA.2572@TK2MSFTNGP09.phx.gbl... > > > > You forgot the -n switch, that removes numbering. > > > > > > > > osql /Usa /Pngsol -n /ic:\Query.qry /o c:\titles.TXT > > > > > > > > -- > > > > ******************************************************************* > > > > Andy S. > > > > MCSE NT/2000, MCDBA SQL 7/2000 > > > > andymcdba1@NOMORESPAM.yahoo.com > > > > > > > > Please remove NOMORESPAM before replying. > > > > > > > > Always keep your antivirus and Microsoft software > > > > up to date with the latest definitions and product updates. > > > > Be suspicious of every email attachment, I will never send > > > > or post anything other than the text of a http:// link nor > > > > post the link directly to a file for downloading. > > > > > > > > This posting is provided "as is" with no warranties > > > > and confers no rights. > > > > > > > > ******************************************************************* > > > > "Noorali Issani" <naissani@lycos.co.uk> wrote in message > > > > news:e21yyea5DHA.2008@TK2MSFTNGP10.phx.gbl... > > > > > Dear Professional > > > > > > > > > > I have used the following query > > > > > > > > > > osql /U sa /P ngsol /i c:\Query.qry /o c:\titles.TXT > > > > > > > > > > > > > > > That above query gave me the correct result in titles.Txt file but > > the > > > > > problem is that in the top I have received the following stuff which > I > > > > wanna > > > > > remove it and how can I do this ? > > > > > > > > > > > > > > > 1> 2> 1> 2> 1> 2> > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------ > > - > > > > -- > > > > > --- > > > > > ----------------------------------------------------------------------- > > > > > ----------------------------------------------------------------------- > > > > > ----------------------------------------------------------------------- > > > > > ----------------------------------------------------------------------- > > > > > ----------------------------------------------------------------------- > > > > > ----------------------------------------------------------------------- > > > > > ---------------------------------------------------- > > > > > > > > > > What I do ? > > > > > > > > > > Waiting for your reply > > > > > > > > > > Noor > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Like there is command
osql /Usa /Pngsol -n /ic:\Query.qry /o c:\titles.TXT what I write for hidding lines. thanks in advance.. Noor [quoted text, click to view] "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message news:eRjdW3n5DHA.2748@TK2MSFTNGP09.phx.gbl... > The only way you can return text without separators is to use a print > statement. Then you can use SET NOCOUNT ON to hide the number of rows > affected. PRINT can be used with local variables, global variables and > text. > > Otherwise, the separators are pretty much part of SQL statements. There is > no SET statement I know to turn it off. > > -- > ******************************************************************* > Andy S. > MCSE NT/2000, MCDBA SQL 7/2000 > andymcdba1@NOMORESPAM.yahoo.com > > Please remove NOMORESPAM before replying. > > Always keep your antivirus and Microsoft software > up to date with the latest definitions and product updates. > Be suspicious of every email attachment, I will never send > or post anything other than the text of a http:// link nor > post the link directly to a file for downloading. > > This posting is provided "as is" with no warranties > and confers no rights. > > ******************************************************************* > "Noorali Issani" <naissani@lycos.co.uk> wrote in message > news:%23OXpN6j5DHA.1040@TK2MSFTNGP10.phx.gbl... > > thanks but how I remove this lines > > > ------------------------------------------------------------------------- > -- > > --- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ----------------------------------------------------------------------- > > ---------------------------------------------------- > > Waiting > > > > "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message > > news:e$5Kg1b5DHA.2572@TK2MSFTNGP09.phx.gbl... > > > You forgot the -n switch, that removes numbering. > > > > > > osql /Usa /Pngsol -n /ic:\Query.qry /o c:\titles.TXT > > > > > > -- > > > ******************************************************************* > > > Andy S. > > > MCSE NT/2000, MCDBA SQL 7/2000 > > > andymcdba1@NOMORESPAM.yahoo.com > > > > > > Please remove NOMORESPAM before replying. > > > > > > Always keep your antivirus and Microsoft software > > > up to date with the latest definitions and product updates. > > > Be suspicious of every email attachment, I will never send > > > or post anything other than the text of a http:// link nor > > > post the link directly to a file for downloading. > > > > > > This posting is provided "as is" with no warranties > > > and confers no rights. > > > > > > ******************************************************************* > > > "Noorali Issani" <naissani@lycos.co.uk> wrote in message > > > news:e21yyea5DHA.2008@TK2MSFTNGP10.phx.gbl... > > > > Dear Professional > > > > > > > > I have used the following query > > > > > > > > osql /U sa /P ngsol /i c:\Query.qry /o c:\titles.TXT > > > > > > > > > > > > That above query gave me the correct result in titles.Txt file but > the > > > > problem is that in the top I have received the following stuff which I > > > wanna > > > > remove it and how can I do this ? > > > > > > > > > > > > 1> 2> 1> 2> 1> 2> > > > > > > > > > > > > > > > > ------------------------------------------------------------------------ > - > > > -- > > > > --- > > > > ----------------------------------------------------------------------- > > > > ----------------------------------------------------------------------- > > > > ----------------------------------------------------------------------- > > > > ----------------------------------------------------------------------- > > > > ----------------------------------------------------------------------- > > > > ----------------------------------------------------------------------- > > > > ---------------------------------------------------- > > > > > > > > What I do ? > > > > > > > > Waiting for your reply > > > > > > > > Noor > > > > > > > > > > > > > > > > > > > >
How about /h-1?
osql /SMyServer\Instance /Q"set nocount on select * from sysobjects where name = 'sysobjects'" /E /h-1 Also, the lines are dashes which indicate comments, so the fact that they exist in the output should not prevent that output from being used as input to another osql command. Cindy Gross, MCDBA, MCSE http://cindygross.tripod.com This posting is provided "AS IS" with no warranties, and confers no rights.
Okie but I just wanna share one thing from you, might be u will help me in
this regard. I wanna take the back up of tables via this procedure and might be after that I will use this script for restoration purpose so the lines are creating a problem so please let me know any idea what I have to do for this... waiting for your reply Noor [quoted text, click to view] "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message news:O3w1Qzp5DHA.2496@TK2MSFTNGP09.phx.gbl... > Nope, no switch I know of to hide lines. > > You can use print to return certain variables, but the line separator is > part of the results of a SQL statment. You can turn the count off and the > line numbering off, but that's it. > > -- > ******************************************************************* > Andy S. > MCSE NT/2000, MCDBA SQL 7/2000 > andymcdba1@NOMORESPAM.yahoo.com > > Please remove NOMORESPAM before replying. > > Always keep your antivirus and Microsoft software > up to date with the latest definitions and product updates. > Be suspicious of every email attachment, I will never send > or post anything other than the text of a http:// link nor > post the link directly to a file for downloading. > > This posting is provided "as is" with no warranties > and confers no rights. > > ******************************************************************* > "Noorali Issani" <naissani@lycos.co.uk> wrote in message > news:uUXpO9n5DHA.3548@TK2MSFTNGP11.phx.gbl... > > Like there is command > > osql /Usa /Pngsol -n /ic:\Query.qry /o c:\titles.TXT > > > > what I write for hidding lines. > > > > thanks in advance.. > > > > Noor > > "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message > > news:eRjdW3n5DHA.2748@TK2MSFTNGP09.phx.gbl... > > > The only way you can return text without separators is to use a print > > > statement. Then you can use SET NOCOUNT ON to hide the number of rows > > > affected. PRINT can be used with local variables, global variables and > > > text. > > > > > > Otherwise, the separators are pretty much part of SQL statements. There > > is > > > no SET statement I know to turn it off. > > > > > > -- > > > ******************************************************************* > > > Andy S. > > > MCSE NT/2000, MCDBA SQL 7/2000 > > > andymcdba1@NOMORESPAM.yahoo.com > > > > > > Please remove NOMORESPAM before replying. > > > > > > Always keep your antivirus and Microsoft software > > > up to date with the latest definitions and product updates. > > > Be suspicious of every email attachment, I will never send > > > or post anything other than the text of a http:// link nor > > > post the link directly to a file for downloading. > > > > > > This posting is provided "as is" with no warranties > > > and confers no rights. > > > > > > ******************************************************************* > > > "Noorali Issani" <naissani@lycos.co.uk> wrote in message > > > news:%23OXpN6j5DHA.1040@TK2MSFTNGP10.phx.gbl... > > > > thanks but how I remove this lines > > > > > > > > ------------------------------------------------------------------------ > - > > > -- > > > > --- > > > > ----------------------------------------------------------------------- > > > > ----------------------------------------------------------------------- > > > > ----------------------------------------------------------------------- > > > > ----------------------------------------------------------------------- > > > > ----------------------------------------------------------------------- > > > > ----------------------------------------------------------------------- > > > > ---------------------------------------------------- > > > > Waiting > > > > > > > > "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message > > > > news:e$5Kg1b5DHA.2572@TK2MSFTNGP09.phx.gbl... > > > > > You forgot the -n switch, that removes numbering. > > > > > > > > > > osql /Usa /Pngsol -n /ic:\Query.qry /o c:\titles.TXT > > > > > > > > > > -- > > > > > ******************************************************************* > > > > > Andy S. > > > > > MCSE NT/2000, MCDBA SQL 7/2000 > > > > > andymcdba1@NOMORESPAM.yahoo.com > > > > > > > > > > Please remove NOMORESPAM before replying. > > > > > > > > > > Always keep your antivirus and Microsoft software > > > > > up to date with the latest definitions and product updates. > > > > > Be suspicious of every email attachment, I will never send > > > > > or post anything other than the text of a http:// link nor > > > > > post the link directly to a file for downloading. > > > > > > > > > > This posting is provided "as is" with no warranties > > > > > and confers no rights. > > > > > > > > > > ******************************************************************* > > > > > "Noorali Issani" <naissani@lycos.co.uk> wrote in message > > > > > news:e21yyea5DHA.2008@TK2MSFTNGP10.phx.gbl... > > > > > > Dear Professional > > > > > > > > > > > > I have used the following query > > > > > > > > > > > > osql /U sa /P ngsol /i c:\Query.qry /o c:\titles.TXT > > > > > > > > > > > > > > > > > > That above query gave me the correct result in titles.Txt file > but > > > the > > > > > > problem is that in the top I have received the following stuff > which > > I > > > > > wanna > > > > > > remove it and how can I do this ? > > > > > > > > > > > > > > > > > > 1> 2> 1> 2> 1> 2> > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------ > > > - > > > > > -- > > > > > > --- > > > > > > > > ----------------------------------------------------------------------- > > > > > > > > ----------------------------------------------------------------------- > > > > > > > > ----------------------------------------------------------------------- > > > > > > > > ----------------------------------------------------------------------- > > > > > > > > ----------------------------------------------------------------------- > > > > > > > > ----------------------------------------------------------------------- > > > > > > ---------------------------------------------------- > > > > > > > > > > > > What I do ? > > > > > > > > > > > > Waiting for your reply > > > > > > > > > > > > Noor > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Thank you Noorali and Cindy, I appreciate it. Should've looked at the
switches more closely. /h-1 will help me too. -- ******************************************************************* Andy S. MCSE NT/2000, MCDBA SQL 7/2000 andymcdba1@NOMORESPAM.yahoo.com Please remove NOMORESPAM before replying. Always keep your antivirus and Microsoft software up to date with the latest definitions and product updates. Be suspicious of every email attachment, I will never send or post anything other than the text of a http:// link nor post the link directly to a file for downloading. This posting is provided "as is" with no warranties and confers no rights. ******************************************************************* [quoted text, click to view] "Cindy Gross (MSFT)" <cgross@online.microsoft.com> wrote in message news:KeY6rv05DHA.3496@cpmsftngxa07.phx.gbl... > How about /h-1? > > osql /SMyServer\Instance /Q"set nocount on select * from sysobjects where > name = 'sysobjects'" /E /h-1 > > Also, the lines are dashes which indicate comments, so the fact that they > exist in the output should not prevent that output from being used as input > to another osql command. > > > Cindy Gross, MCDBA, MCSE > http://cindygross.tripod.com > This posting is provided "AS IS" with no warranties, and confers no rights. >
ya that's excellent
[quoted text, click to view] "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message news:exAbpiZ6DHA.2628@TK2MSFTNGP10.phx.gbl... > Thank you Noorali and Cindy, I appreciate it. Should've looked at the > switches more closely. /h-1 will help me too. > > -- > ******************************************************************* > Andy S. > MCSE NT/2000, MCDBA SQL 7/2000 > andymcdba1@NOMORESPAM.yahoo.com > > Please remove NOMORESPAM before replying. > > Always keep your antivirus and Microsoft software > up to date with the latest definitions and product updates. > Be suspicious of every email attachment, I will never send > or post anything other than the text of a http:// link nor > post the link directly to a file for downloading. > > This posting is provided "as is" with no warranties > and confers no rights. > > ******************************************************************* > "Cindy Gross (MSFT)" <cgross@online.microsoft.com> wrote in message > news:KeY6rv05DHA.3496@cpmsftngxa07.phx.gbl... > > How about /h-1? > > > > osql /SMyServer\Instance /Q"set nocount on select * from sysobjects where > > name = 'sysobjects'" /E /h-1 > > > > Also, the lines are dashes which indicate comments, so the fact that they > > exist in the output should not prevent that output from being used as > input > > to another osql command. > > > > > > Cindy Gross, MCDBA, MCSE > > http://cindygross.tripod.com > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > > >
Solve that problem but now I have one more issue which would be last issue I
think so, the problem is that after executing the osql command the result is saving into one file like this... insert into [occupation] (O_Alias,O_IsActive,O_DMLUserID,O_DmlDate,O_DmlOperation ) values ('Software Engineer',1,5,getdate(),'C') insert into [occupation] (O_Alias,O_IsActive,O_DMLUserID,O_DmlDate,O_DmlOperation ) values ('Administrator',1,5,getdate(),'C') In the above insert query u are seeing there is space b/w Software Enginner and when I import that data so it also insert spaces so is it possible while executing the procedure in the command line so I have removed that space and result look like that insert into [occupation] (O_Alias,O_IsActive,O_DMLUserID,O_DmlDate,O_DmlOperation ) values ('Software Engineer',1,5,getdate(),'C') insert into [occupation] (O_Alias,O_IsActive,O_DMLUserID,O_DmlDate,O_DmlOperation ) values ('Administrator',1,5,getdate(),'C') Is it possible ? Anxiously waiting for you reply Noor [quoted text, click to view] "Noorali Issani" <naissani@lycos.co.uk> wrote in message news:emWr8nK7DHA.2644@TK2MSFTNGP11.phx.gbl... > ya that's excellent > > > "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message > news:exAbpiZ6DHA.2628@TK2MSFTNGP10.phx.gbl... > > Thank you Noorali and Cindy, I appreciate it. Should've looked at the > > switches more closely. /h-1 will help me too. > > > > -- > > ******************************************************************* > > Andy S. > > MCSE NT/2000, MCDBA SQL 7/2000 > > andymcdba1@NOMORESPAM.yahoo.com > > > > Please remove NOMORESPAM before replying. > > > > Always keep your antivirus and Microsoft software > > up to date with the latest definitions and product updates. > > Be suspicious of every email attachment, I will never send > > or post anything other than the text of a http:// link nor > > post the link directly to a file for downloading. > > > > This posting is provided "as is" with no warranties > > and confers no rights. > > > > ******************************************************************* > > "Cindy Gross (MSFT)" <cgross@online.microsoft.com> wrote in message > > news:KeY6rv05DHA.3496@cpmsftngxa07.phx.gbl... > > > How about /h-1? > > > > > > osql /SMyServer\Instance /Q"set nocount on select * from sysobjects > where > > > name = 'sysobjects'" /E /h-1 > > > > > > Also, the lines are dashes which indicate comments, so the fact that > they > > > exist in the output should not prevent that output from being used as > > input > > > to another osql command. > > > > > > > > > Cindy Gross, MCDBA, MCSE > > > http://cindygross.tripod.com > > > This posting is provided "AS IS" with no warranties, and confers no > > rights. > > > > > > > > >
One more question, I want to append the record into text file instead of
overwritting.. I am using this query, what I write for appending into that file. osql /Usa /Pngs -n /ic:\Query.qry /o c:\titles.TXT /h-1 Waiting for your reply [quoted text, click to view] "Noorali Issani" <naissani@lycos.co.uk> wrote in message news:eDaOQmU7DHA.2064@TK2MSFTNGP11.phx.gbl... > Solve that problem but now I have one more issue which would be last issue I > think so, the problem is that after executing the osql command the result is > saving into one file like this... > > insert into [occupation] > (O_Alias,O_IsActive,O_DMLUserID,O_DmlDate,O_DmlOperation ) values > ('Software > Engineer',1,5,getdate(),'C') > insert into [occupation] > (O_Alias,O_IsActive,O_DMLUserID,O_DmlDate,O_DmlOperation ) values > ('Administrator',1,5,getdate(),'C') > > In the above insert query u are seeing there is space b/w Software Enginner > and when I import that data so it also insert spaces so is it possible while > executing the procedure in the command line so I have removed that space and > result look like that > > insert into [occupation] > (O_Alias,O_IsActive,O_DMLUserID,O_DmlDate,O_DmlOperation ) values > ('Software Engineer',1,5,getdate(),'C') > insert into [occupation] > (O_Alias,O_IsActive,O_DMLUserID,O_DmlDate,O_DmlOperation ) values > ('Administrator',1,5,getdate(),'C') > > Is it possible ? > > Anxiously waiting for you reply > > Noor > > "Noorali Issani" <naissani@lycos.co.uk> wrote in message > news:emWr8nK7DHA.2644@TK2MSFTNGP11.phx.gbl... > > ya that's excellent > > > > > > "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message > > news:exAbpiZ6DHA.2628@TK2MSFTNGP10.phx.gbl... > > > Thank you Noorali and Cindy, I appreciate it. Should've looked at the > > > switches more closely. /h-1 will help me too. > > > > > > -- > > > ******************************************************************* > > > Andy S. > > > MCSE NT/2000, MCDBA SQL 7/2000 > > > andymcdba1@NOMORESPAM.yahoo.com > > > > > > Please remove NOMORESPAM before replying. > > > > > > Always keep your antivirus and Microsoft software > > > up to date with the latest definitions and product updates. > > > Be suspicious of every email attachment, I will never send > > > or post anything other than the text of a http:// link nor > > > post the link directly to a file for downloading. > > > > > > This posting is provided "as is" with no warranties > > > and confers no rights. > > > > > > ******************************************************************* > > > "Cindy Gross (MSFT)" <cgross@online.microsoft.com> wrote in message > > > news:KeY6rv05DHA.3496@cpmsftngxa07.phx.gbl... > > > > How about /h-1? > > > > > > > > osql /SMyServer\Instance /Q"set nocount on select * from sysobjects > > where > > > > name = 'sysobjects'" /E /h-1 > > > > > > > > Also, the lines are dashes which indicate comments, so the fact that > > they > > > > exist in the output should not prevent that output from being used as > > > input > > > > to another osql command. > > > > > > > > > > > > Cindy Gross, MCDBA, MCSE > > > > http://cindygross.tripod.com > > > > This posting is provided "AS IS" with no warranties, and confers no > > > rights. > > > > > > > > > > > > > > > >
Noorali Issani (naissani@lycos.co.uk) writes:
[quoted text, click to view] > One more question, I want to append the record into text file instead of > overwritting.. I am using this query, what I write for appending into that > file. > > osql /Usa /Pngs -n /ic:\Query.qry /o c:\titles.TXT /h-1 You can use >> for this. >> is a meta-character in the command-line mode, so this is not an OSQL option. E.g: osql /Usa /Pngs -n /ic:\Query.qry /h-1 >> c:\titles.TXT -- Erland Sommarskog, SQL Server MVP, sommar@algonet.se Books Online for SQL Server SP3 at
Don't see what you're looking for? Try a search.
|
March 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |