• Using a table variable as input in a stored procedure

    Have just run into a problem. Currently our web service has been adding data to our SQL server 2008 tables by building a dynamic SQL INSERT command. It has started failing because of the data coming in. It contains a single quote in the name data ex. O' Brien. I am looking to pass the tables from...

    ToddN200031,175 pointsBadges:
  • Powerbuilder and Word OLE

    How do I insert pictures in picture content control in Word during runtime from PB (if I have 5 predefined picture content controls already saved in a Word template?

    HariharanAthmaraman5 pointsBadges:
  • Privera software

    I'm an IT beginner and I want to learn more about Privera software. Can someone point me in the right direction?

    ki7uf8tz65 pointsBadges:
  • QR Code barcodes in .NET

    How could I generate barcodes not in black and white, but still it could be scanned, it this possible?

    Alice34570 pointsBadges:
  • Why is my textbox always showing zero’s after the decimal point? (Visual Basic)

    I have a text box to where a user will insert text like 1234567. My intentions is to have that textbox add the comma's and decimal points once the focus has left it. However the results I am getting is 1,234,567.00 and not 12,345.67. Here is my code: Private Sub toothchart_TextChanged(ByVal sender...

    TryingHard125 pointsBadges:
  • Lost Toolbar

    I unchecked all of the toolbars (by mistake) in the "Customize" menu and now I can't find a location to Right-Click on to bring up the customize menu so I can restore the Standard menu. Any suggestions?

    ChuckWagon5 pointsBadges:
  • Insert data to DB2 database using VB and SQL stored procedure

    I have spent a few days trying to find a solution using Google. Has anyone had luck with this problem? Simply put we are trying to send data from our web service to our I-Series. We need to do this via a SQL stored procedure. When we do the insert dynamically it works as long as there are no single...

    ToddN200031,175 pointsBadges:
  • Dynamic vs. Stored Procedure table inserts

    I just finished making some code changes to get around a problem. I changed my code from doing a dynamic insert to using a stored procedure. Originally it was 20 lines of code for the dynamic process. Doing it the stored procedure way, by the time you defined all the parms it was 107 lines of vb...

    ToddN200031,175 pointsBadges:
  • Windows Forms and SQL Server 2008 database

    Now, I have created two different things: A local database and a Windows form. With the Windows form (In Server Explorer), I added the database's connection. How can I begin querying it using LING-to-SQL? Thanks!

    ITKE376,195 pointsBadges:
  • Dreamweaver Firefox PHP

    PHP codes in calculator?

    Sjoseph5 pointsBadges:
  • SSRS reports in SQL Server 2012?

    I’ve been working with SQL Server 2008 R2 in conjunction with Visual Studio 2008 and 2010. I just installed SQL Server 2012 and have SQL Server Data Tools running. Now I’m trying to create SSRS reports in SQL Server 2008 R2, but I can't find them in Programs. I realize that common advice is to...

    ITKE376,195 pointsBadges:
  • How to read transaction log in SQL Server 2014?

    I need access to the read transaction log file in SQL Server 2014 for auditing purposes. In the past, I’ve used a third party log reader, but we’re looking to cut costs. I’m familiar with CDC, but that only allows access to data changes and I also need access to schema. Is there an improved...

    ITKE376,195 pointsBadges:
  • How to view transaction logs in SQL Server 2014?

    Hi, I have SQL Server 2014 CTP 1 installed and I can’t figure out how to view all transaction logs.Does anyone know where I can find them? I’ve looked at datasheets and documentation on MS website but I couldn’t find anything.

    ITKE376,195 pointsBadges:
  • I keep receiving an error in SQL Management Studio

    When I'm trying to create several users in SQL Management Studio, I first create them under the server name, followed by the database. However, when I'm trying to log on, I keep getting this error message: A connection was successfully established with the server, but then an error occurred during...

    ITKE376,195 pointsBadges:
  • Does SQL Server 2008 R2 Express have Intellisense?

    Is Intellisense available in SQL Server 2008 R2 Express Management Studio? It seems like it should be there. Is it inactive or am I doing something foolish?

    ITKE376,195 pointsBadges:
  • Comments in Excel using VBA with archived info included

    To whom it may concern,I am currently trying to get very specific cells in a spreadsheet to pull up the previous weeks worth of information (date from the past 5 days at least) and to show up in a comment on very specific cells so that the people in my department do not have to look up the...

    jgarces5 pointsBadges:
  • Connecting a SQL Server database with Visual Basic 6.0

    What code would I need to connect a SQL Server database with Visual Basic 6?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connecting a SQL Server database with Visual C++ and .NET

    How can I connect a SQL Server database with Visual C++ and .NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to schedule SQL query to run in Microsoft SQL Server

    I have a query that I want to automatically schedule to run daily. How do I do this?

    House5 pointsBadges:

    I have a .dbf file from my dental software (FOXDENT V7.0B) MS DOS program that allows the printing of a standard 1994 American Dental Association form. HIPAA is now requiring the 2006 format- Mostly the government and Medicaid forms. Can anyone help me with this conversion as this software has...

    Cephid5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.