PCI

Technical Article

RE: tsql

  • Reply

...Do While Number > 0 Number = 12 Dim cmdEnter As New SqlCommand("PaymentSchedule", GlobalConnection) cmdEnter.CommandType = CommandType.StoredProcedure cmdEnter.Parameters.Add("@UserID", 208466) cmdEnter.Parameters.Add("@SPaymentAmount", Double.Parse(txtSpaymentAmount.Text)) cmdEnter.Parameters.Add("@SPaymentDate", txtPaymentDate.Text) Enter = cmdEnter.ExecuteNonQuery() Loop ... Use indentation so that you can see better:Number = 12 Do While Number > 0  Dim cmdEnter As New SqlCommand("PaymentSchedule", GlobalConnection)  cmdEnter.CommandType = CommandType.StoredProcedure  cmdEnter.Parameters.Add("@UserID", 208466)  cmdEnter.Parameters.Add("@SPaymentAmount", Double.Parse(txtSpaymentAmount.Text)) […]

2005-04-21

Technical Article

RE: Import/Export SQL Server database to Oracle.

  • Reply

Thanks for the replies. But I got the reply from the Microsoft Community and they gave the following link: http://support.microsoft.com/?id=247750 Go to this link to know more about the double quotes problem. Though the article says about SQL Server 7, but it persists with SQL Server 2000 too.

You rated this post out of 5. Change rating

2005-02-24

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers