General

• Topics

  Started by

  Posts

  Last post

• Conversion failed when converting the varchar value 'XX' to data type int.

  Initialley when I was tryed to insert values in one of the table, during insert I was getting this …

  MO-622821

  7 replies

  17 years, 1 month ago

  By: Ed B

• [SQL-DMO]You must use SQL Server 2005 management tools to connect to this server.

  Sorry I am new to SQL server environment, some of my question might be very simple for you guys…. A…

  MO-622821

  1 replies

  17 years, 1 month ago

  By: Lynn Pettis

• How to connect from SQL Server 2000 to a password protected Access database

  Hi, We developed a process that populates, where we can, an Access Back End database (a govt housin…

  esther.agun

  1 replies

  17 years, 1 month ago

  By: Steve Jones - SSC Editor

• Cursor ends when I don't want it too

  Hello all I have the following cursor below (I have to admit I am not that strong with error handli…

  Edward Shaw

  2 replies

  17 years, 1 month ago

  By: Edward Shaw

• Updating the rows with Identity values

  Can any one plz let me know how can i generate a identity values on existing table for emaple I hav…

  virgo

  6 replies

  17 years, 1 month ago

  By: Jeff Moden

• Excel - Copy and Paste Macros

  I have a user who wishes to copy a range of data from one spreadsheet and paste it into another. H…

  S Hodkinson

  3 replies

  17 years, 1 month ago

  By: S Hodkinson

• Different data with same query in SQL and access

  Hello, I have one table in the database that I query using a simple query: select * from member Whe…

  ivanl-717247

  11 replies

  17 years, 2 months ago

  By: ivanl-717247

• specify netword card/default gateway to use for computer/instance search

  Our developers in .NET 3.0 are trying to get a listing of all active computers and the SQL instance…

  Frankie-464050

  1 replies

  17 years, 2 months ago

  By: Matt Miller (4)

• Sending Emails using SQL Server 2000

  i am not able to use sp xp_sendmail for sending emails. what all settings are requried for sending …

  anisha.bhardwaj19

  1 replies

  17 years, 2 months ago

  By: RBarryYoung

• SQL QUERY HELP - CASE Statement

  I couold use some help with a case statement. I need a query that takes rows of data and makes the…

  rconley

  3 replies

  17 years, 2 months ago

  By: rconley

• Write to text file from a stored procedure

  I have a stored procedure that is executed by a user, by running a crystal report - and I want the …

  delessio

  5 replies

  17 years, 2 months ago

  By: Girish Bhat

• Copy XLS (LOCAL) to SQL (Remote) table without link server or BCP or .NET code

  I have a XLS file on local machine and would like to copy all the columns to a new SQL table on the…

  iitt2007

  1 replies

  17 years, 2 months ago

  By: Lowell

• One-to-many join using separate fields for values?

  Hi everyone I am fairly new to sql but trying to learn fast. I must say, the threads I have read s…

  pedrosmith

  4 replies

  17 years, 2 months ago

  By: SQLZ

• Training Programmers: Accessing Base Tables or Stored Procs

  I'm re-training our mainframe programmers in SQL Server and database theory: they're taking a cours…

  Wayne West

  30 replies

  17 years, 2 months ago

  By: Jeff Moden

• SELECT 'HAVING' issue

  This has got to be one of the dumber questions I've asked but I have a @tmpTable that I'm trying to…

  Christopher Klein

  2 replies

  17 years, 2 months ago

  By: Christopher Klein