help docs for osql.exe parameters

Where can I find help files (.CHM) or other docs on the use of the various
osql.exe command line parameters ?BOL ?
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"John Grandy" <johnagrandy-at-yahoo-dot-com> schrieb im Newsbeitrag
news:udO%236FGbFHA.3932@.TK2MSFTNGP12.phx.gbl...
> Where can I find help files (.CHM) or other docs on the use of the various
> osql.exe command line parameters ?
>|||http://msdn.microsoft.com/library/d...br />
1wxl.asp
"John Grandy" wrote:

> Where can I find help files (.CHM) or other docs on the use of the various
> osql.exe command line parameters ?
>
>|||osql /?
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:u8oRuNGbFHA.3032@.TK2MSFTNGP10.phx.gbl...
> BOL ?
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "John Grandy" <johnagrandy-at-yahoo-dot-com> schrieb im Newsbeitrag
> news:udO%236FGbFHA.3932@.TK2MSFTNGP12.phx.gbl...
>|||Hi Mike, and thanks for the response.
Yes, osql -? gives the list of parameters, but isn't there some way to
interactively get help on each parameter?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23GhhXlGbFHA.3144@.TK2MSFTNGP14.phx.gbl...
> osql /?
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in message news:u8oRuNGbFHA.3032@.TK2MSFTNGP10.phx.gbl...
>|||In addition to the copy of the Books Online in MSDN that Cris linked to, you
can download a local copy from:
http://www.microsoft.com/downloads/...&displaylang=en
Alan Brewer [MSFT]
Content Architect
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.|||at the command prompt type:
osql /?
"John Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:udO%236FGbFHA.3932@.TK2MSFTNGP12.phx.gbl...
> Where can I find help files (.CHM) or other docs on the use of the various
> osql.exe command line parameters ?
>|||Not from the SQL Server command prompt utilities like osql. The GUI tools
have their F1 help linked into topics in the Books Online, but not the
command prompt utilities. You get the short list from the utility itself if
you use the /? switch, and you get the more in-depth help from the Books
Online osql reference topic, either online in the MSDN Library or your local
copy.
Alan Brewer [MSFT]
Content Architect
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.

Help : ASP var at SQL line

Hi,

I try to insert the date parameter on SQL line.
The date parameter is on ASP var declares.

I'm working with the page that have listbox, and gridview bound to msaccess.
when the user select thelistbox with other value, the page will reload.
while the page reload on server, it carry the variable that should insert on sql line,
for displaying the difference gridview records result.
So I have dynamic gridview records base on my listbox.

But, ... the page doesn't load well from the beginning. Doesn't work at all !!

I declare this at the page load.

Dim StartProjectAsString ="1/1/1996"

Sub ProjectListBox_SelectedIndexChanged(ByVal senderAsObject,ByVal eAs EventArgs)Handles PYear.SelectedIndexChanged
StartProject = PYear.SelectedValue.ToString
EndSub

The object "Pyear" is listbox :

<asp:ListBoxID="PYear"runat="server"Rows="12"CssClass="tb01"SelectionMode="Single"AutoPostBack="True">
<asp:ListItemValue="1/1/1991">1991-1995</asp:ListItem>
<asp:ListItemValue="1/1/1996"Selected="True">1996-2000</asp:ListItem>
<asp:ListItemValue="1/1/2001">2001-2005</asp:ListItem>
<asp:ListItemValue="1/1/2006">2006-2010</asp:ListItem>
<asp:ListItemValue="1/1/2011">2011-2015</asp:ListItem>
</asp:ListBox>

And the datasource for bound to gridview is

<asp:AccessDataSourceID="AccessDataSource1"runat="server"DataFile="~/App_Data/general.mdb"
SelectCommand='SELECT TBL_PROJECT.NAMEPROJECT AS Name, TBL_PROJECT.STARTPROJECT AS Start, TBL_PROJECT.ENDPROJECT AS Finish, TBL_PROJECT.JOBNO AS JobNo, TBL_PROJECT.CLIENT AS Client, TBL_PROJECT.BUILDING AS Building, TBL_PROJECT.CODEPROJECT AS Code, TBL_PROJECT.IDPROJECT AS IDPROJECT FROM TBL_PROJECT WHERE TBL_PROJECT.STARTPROJECT >= DateValue("<%=StartProject%>") And TBL_PROJECT.STARTPROJECT < DateValue("1/1/2001");'>
</asp:AccessDataSource>

It will return the error page regarding the ASP : StartProject.
If I change the variable with the string "1/1/1996" :

'SELECT TBL_PROJECT.NAMEPROJECT AS Name, TBL_PROJECT.STARTPROJECT AS Start, TBL_PROJECT.ENDPROJECT AS Finish, TBL_PROJECT.JOBNO AS JobNo, TBL_PROJECT.CLIENT AS Client, TBL_PROJECT.BUILDING AS Building, TBL_PROJECT.CODEPROJECT AS Code, TBL_PROJECT.IDPROJECT AS IDPROJECT FROM TBL_PROJECT WHERE TBL_PROJECT.STARTPROJECT >= DateValue("1/1/1996") And TBL_PROJECT.STARTPROJECT < DateValue("1/1/2001");

it will work fine, but I will miss my dynamic gridview, right ?

So, please ... help me ...

Thank you ...

The answer :

http://forums.asp.net/t/1110547.aspx

Help - syncronizing forms in Access 2000

regular access db - usually use sub-forms or tabs - this time I want seperate forms - have linked fields - but can't final code line in "open form" button command. Any suggestions welcome. Denny :(but can't final code line in "open form" button command

Can you explain this a little better. You might want to bullet point exactly what you want. If you want to just populate two forms on the open, you need to just scroll down on properties of main form until you get to the open propety. You'll want to set the properties of the parent form first, then the second. I have no idea if this is what you are trying to do.

Help - MS SQL 7.0 Enterprise Manager Error

Please, Take al ook at this picture attached and the name of the server.
There is one "zig-zag" vertical line inserted right before the server name.
What does it mean?
Thanks.
eddieRE:
Please, Take a look at this picture attached and the name of the server.
There is one "zig-zag" vertical line inserted right before the server name.

Q1 What does it mean? Thanks. eddie

A1 Symbols in that area of EM generally refer to connection / service status, (the "zig-zag" refers to the current EM connection status).

Help

There is a data in the following table
Account No. Stat. No. Line. No.
1 4 5
1 2 3
1 6 4
2 5 6
2 3 7
2 4 8
3 9 1
3 8 2
3 5 4
1 0 84
2 5 7
3 6 6
1 56 9
1 41 8
2 41 8
Now I want the data of top 2 records of each Account No. like this
Account No. Stat. No. Line No.
1 4 5
1 2 3
2 5 6
2 3 7
3 9 1
3 8 2
Can any body let me know any query
Thanks
NOOR
On Tue, 25 May 2004 19:23:23 +0500, Noorali Issani wrote:

>There is a data in the following table
>Account No. Stat. No. Line. No.
> 1 4 5
> 1 2 3
> 1 6 4
> 2 5 6
> 2 3 7
> 2 4 8
> 3 9 1
> 3 8 2
> 3 5 4
> 1 0 84
> 2 5 7
> 3 6 6
> 1 56 9
> 1 41 8
> 2 41 8
>Now I want the data of top 2 records of each Account No. like this
>Account No. Stat. No. Line No.
> 1 4 5
> 1 2 3
> 2 5 6
> 2 3 7
> 3 9 1
> 3 8 2
>Can any body let me know any query
>Thanks
>NOOR
>
Hi Noor,
The short anwer to that woud be 'no'.
Tables in a relational database have no innate ordering. Asking for the
"top 2 rows" (or: first 2 rows) can only be done if you specify some sort
order by which to determine which 2 rows are "first".
If you can tell me *how* (what criteria) SQL Server should decide which 2
rows to return, than I can probably tell you how (which statements) to
write the query.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||A database stores information in the natural order, and this order depends
on the data files. However, when we try to retrieve this information, we
need to provide some business logic for the same.
What I understand from your posting, is that you want to retrieve only the
top 2 rows for each Account Number as they appear in the database. There is
no other business logic for that. Doing this will be very difficult as
there is no way to know what is in top 2. If you can design a business
logic behind the retrieval of this, I could better assist you.
Let me know about the logic and will talk later.
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.