Re: Filtering a voter?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jon (Jon_at_discussions.microsoft.com)
Date: 01/02/05 

Date: Sun, 2 Jan 2005 08:27:01 -0800

Thanks, i'll get typing...

"Erland Sommarskog" wrote:

> Jon (Jon@discussions.microsoft.com) writes:
> > I'm a complete novice with SQl, I'm completely self taught I have not
> > studied computer programming at any level and I have had to bodge things
> > as I have gone along. A hobby in my spare time. I'm trying to learn. I
> > have tried to create data inserts, but have failed I tried with
> > http://vyaskn.tripod.com/code.htm#inserts and had no joy. I kept getting
> > errors with it.
> >
> > Is there any other way that I can create these INSERT statements?
>
> Type them!
>
> No, you don't have to include the entire database. Usually for this
> sort of question, three to six rows per table is enough to demonstrate
> the problem.
>
> Yes, it's a bit of a boring job, but if you don't do, someone else will
> have to do it, and you are the one who is asking for help. (A hint is
> you don't have include columns that are not relevant to the question. Not
> as long you ascertain that the code you post - CREATE TABLE + INSERT -
> demonstrates the problem you see.) Don't forget to include the expected
> results! (The expected results can be in a simple text table, as the
> results as such are not to be run.)
>
> > When I first started, I could not get some of my web forms to insert
> > into certain tables on my database and as a result I changed them all to
> > Nullable, the whole database is updated from forms on the web which I
> > control, so I'm not worried about that.
>
> It's always a good idea to have several lines of defense. One day you
> might be poke around in your web forms, and as a result you fail to
> insert the data data for a column. If the column is declared as NOT NULL,
> you discover the problem, before there is any damage to the database.
> The same applies to foreign-key constraints.
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>

Relevant Pages

  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)