General

• Topics

  Started by

  Posts

  Last post

• Connect from SQLserver2000 to Other DataBase server

  Hi guys, Please I need help in this issue. is that possible to connect from SQLserver 2000 to other…

  fad_fbi

  1 replies

  16 years, 2 months ago

  By: spaghettidba

• HELP: Select within select (looping through records)

  I have a situation that I don't know how to solve using either t-sql or just select/join statements…

  tlocke-632908

  5 replies

  16 years, 2 months ago

  By: GSquared

• Accessing Excel File

  Does anyone know how to get SQL Server to read, via opendatasource, an Excel file contain…

  DaveO

  6 replies

  16 years, 2 months ago

  By: Helical Johan

• Query for format a date time value

  Hi how can I format a date in to following format " dd-MMM-yyyy HH:mm:ss " Regards Rajesh V R

  rajesh.vr

  9 replies

  16 years, 2 months ago

  By: arun.sas

• SQL query writing

  I teach computer classes at a State Penitentiary and have a student that has been doing some great …

  ldcycler

  2 replies

  16 years, 2 months ago

  By: steveb.

• Drop SQL Server Registration

  Infrastructure have dropped one of our old servers which held a redundant database. However, right…

  S Hodkinson

  6 replies

  16 years, 2 months ago

  By: S Hodkinson

• replace values of rows and update with preset value

  I need an sql Update command that will arrange row to be serially arrange from a value I am specif…

  musasuleman

  2 replies

  16 years, 2 months ago

  By: Lamprey13

• Working with Image data types.

  Hi, I am new to working with images and I have created a view that is being used in a Microsoft mai…

  rwturner

  1 replies

  16 years, 2 months ago

  By: Elliott Whitlow

• Check table in use

  Hi All, How do i check whether the table is in use. i need to check if the table is in use, i need…

  shankartup

  4 replies

  16 years, 2 months ago

  By: Steve Jones - SSC Editor

• Null values in table

  Hi, I want to concatenate fields from a table into a combo box. I entered the following SQL Select …

  inliten

  4 replies

  16 years, 2 months ago

  By: inliten

• character type problem using bcp command

  I am using bcp command to download data from sql server. In sql server database there is data in ot…

  sachin.chavan

  2 replies

  16 years, 2 months ago

  By: Jeff Moden

• Problem with PSEXEC when calling a remote DOS Bat file.

  I posted this Q on General on Programming, but no reply so I'm posting here. I'm not an expert in b…

  Jayakumar Krishnan

  3 replies

  16 years, 2 months ago

  By: Lynn Pettis

• Unused Space in Tables

  We've got the usual problem of having loads of unused space in tables. This isn't causing performa…

  MrTim

  8 replies

  16 years, 2 months ago

  By: Suresh B.

• How can i set the postion of a row to the first of other rows

  Hi i had a requirement. I have to select a number of rows from a table. From these rows i need to s…

  rajesh.vr

  2 replies

  16 years, 2 months ago

  By: rajesh.vr

• What is the Sql update command for a range values(numbers) in a row

  What is the Sql update command for a range values(numbers) in a row . I want to update each row wit…

  musasuleman

  7 replies

  16 years, 2 months ago

  By: musasuleman