Showing posts with label programming. Show all posts
Showing posts with label programming. Show all posts

Tuesday, March 27, 2012

Easy Start

Hello All, I am trying to get started with SQL programming and don't know
where to begin.
I would like to use Visual Studio.Net and access a "local database". For
example, something simple like a "member database" for a volunteer
organization.
My first concern is how and what to install so I can create tables and
update them. My next concern (will be) how I would distribute or install th
e
program along with whatever SQL engine is used by the end-user.
Is there any documentation available that describes this for someone
starting at the beginning (me) ?
TIA for any help you can provide.
STIPPYz.STIPPYz wrote:
> Hello All, I am trying to get started with SQL programming and don't know
> where to begin.
> I would like to use Visual Studio.Net and access a "local database". For
> example, something simple like a "member database" for a volunteer
> organization.
> My first concern is how and what to install so I can create tables and
> update them. My next concern (will be) how I would distribute or install
the
> program along with whatever SQL engine is used by the end-user.
> Is there any documentation available that describes this for someone
> starting at the beginning (me) ?
> TIA for any help you can provide.
> STIPPYz.
SQL Server Express may suit your requirements. It's available as a free
download and is free to distribute within the terms of the licence:
http://www.microsoft.com/sql/editio...ss/default.mspx
Lots more information is linked from the above page, including all the
technical documentation. If you've never developed databases before
however I suggest you invest in some books or courses.
David Portas
SQL Server MVP
--|||That sounds like exactly what I am looking for !
I have developed database applications using tables in Paradox format and
was programming in Borland C++ Builder, but I am trying to transition to
VS.net and keep stumbling over db issues. Thanks for the link, I'm going to
start working on it right away......... 8-)
STIPPYz
"David Portas" wrote:

> STIPPYz wrote:
> SQL Server Express may suit your requirements. It's available as a free
> download and is free to distribute within the terms of the licence:
> http://www.microsoft.com/sql/editio...ss/default.mspx
> Lots more information is linked from the above page, including all the
> technical documentation. If you've never developed databases before
> however I suggest you invest in some books or courses.
> --
> David Portas
> SQL Server MVP
> --
>

Thursday, March 22, 2012

Easy Landscape Printing in SSRS -- No programming required.

I had the same headaches as a lot of you. Check out my post on my blog
here:
http://binaryswitch.blogspot.com/2005/09/easy-landscape-printing-in-sql-server.html
This also solves the problem of printing directly out of the web
browser.While this takes care of the obvious printing problems, it doesn't take of
many others.
for instance, if you set the report layout properties to legal (8.5 x14) in
VS.NET, none of this is translated on the server-side. we still need to
change the layout properties in the print button dialog (and usually preview,
just to make sure things are well)
rob
"Mark Milley - BinarySwitch" wrote:
> I had the same headaches as a lot of you. Check out my post on my blog
> here:
> http://binaryswitch.blogspot.com/2005/09/easy-landscape-printing-in-sql-server.html
>
> This also solves the problem of printing directly out of the web
> browser.
>