SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Check for key violation before insert

  I know this is a really common issue, but the solution escapes me /*** What I'm trying to do here …

  Tom Currier

  1 replies

  19 years ago

  By: CK Bhatia

• search all fields

  I'd like to search all the columns in a table. something like: select ID, name from nametable wher…

  Michael Miller-334399

  1 replies

  19 years ago

  By: CK Bhatia

• inconsistant view

  I have a view which combines 3 tables JobsAllocated, MainJob, and Persons plus several other incide…

  Gerard Pilon

  2 replies

  19 years ago

  By: Vladan

• error: 40 connecting with sql server 2000

  Hi I am getting this really annoying error that I cant resolve. I have created a website that acce…

  chris barber

  2 replies

  19 years ago

  By: vadba

• insert into...

  THANKS ANYWAY

  LORNA POLLARD

  4 replies

  19 years ago

  By: Jeff Moden

• DERIVED TABLE???QUERY?????

  OK...I am trying to create something that would be a derived table I guess. The query is: SELECT&nb…

  LORNA POLLARD

  9 replies

  19 years ago

  By: LORNA POLLARD

• using Time on a SQL server database?

  can anyone help me please, I need to set up a field on my database to store hours and minutes with …

  mick burden

  5 replies

  19 years ago

  By: Ian Yates

• Passing in an array as Parameter to a Stored Procedure

  Can any one help me with a sample code, which can take an array of elements as one of it's paramet…

  swathi-324373

  4 replies

  19 years ago

  By: swathi-324373

• SELECT Statements with multiple sets of criteria

  I need to to come up with a select statement that uses multiple sets of criteria.  For example…

  Mark Harley

  2 replies

  19 years ago

  By: Mark Harley

• Getting the e-mail address out of a string.

  Hi guys! My brain is fried to the point where I can't even seem to tie my own shoe laces.  Hel…

  Justyna

  4 replies

  19 years ago

  By: Justyna

• Setting up SQL 2000 w\ eye on 2005

  I have a machine (two actually, same situation) coming in this summer that will be a dedicated SQL …

  Tom Murphy-232891

  2 replies

  19 years ago

  By: Tom Murphy-232891

• Conversion Military Grid Reference System (MGRS) to latitude and Longitude

  I need to convert the MGRS to longitude and latitude coordinates. Does anyone know how to do that i…

  jthill

  1 replies

  19 years ago

  By: Jeff Gray

• Restoring Database in v8.0

  Greetings, Please help me to resolve problem with restoring DB in v8.0: my backup file is more then…

  Viktor Zelenko

  1 replies

  19 years ago

  By: David Scotland-132255

• Accessing a remote SQL Server via HTTP

  I've got a VB 6 app that uses primarily ADO with SQL Server 2000 stored procs for data access. …

  Jim Dalrymple

  4 replies

  19 years ago

  By: Jim Dalrymple

• Help need to identify if a table exists

  I want to check if a table exists in a database. I tried to use SELECT name FROM sysobjects WHERE x…

  Sujata-334280

  1 replies

  19 years ago

  By: sree-226516