SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Insert Image into MS SQČ 2000 not 2005

  Hi, I have tried inserted Image with type .bmp to SQL 2000 into field with type image. but with IN…

  gorenak

  1 replies

  14 years, 10 months ago

  By: gorenak

• table naming conventions

  Does it make any sense to name tables such that similar tables sort together? I'm thinking of code …

  smknox

  8 replies

  14 years, 10 months ago

  By: Naked Ape

• Need Help With an UPDATE Statement

  Can someone please help me out? I have a table called TempTotal with columns LotNumber and ShipQty.…

  ducksql@gmail.com

  4 replies

  14 years, 11 months ago

  By: WayneS

• Send mail using Sql server express 2005

  Hello I am using following procedure to send mail using sql server express 2005. Procedure is exec…

  nidhivarshney82

  2 replies

  14 years, 11 months ago

  By: Nice Marmot

• SP with two dataset to table

  Hello everyone, My very first post... and I've look everywhere, I have the impression it can't be d…

  MiguelSQL

  4 replies

  14 years, 11 months ago

  By: MiguelSQL

• Importing .txt, .csv or .xlsx files into Database using SSIS

  Hi, I have few .txt and .csv file which I want to import into database "DB1". I'm using SSIS to do …

  NoviceJatt

  2 replies

  14 years, 11 months ago

  By: Arjun SreeVastsva

• get count from count query

  I have this query which I am using for an asp report app I made: SELECT somecolumn COUNT(somecolumn…

  audracmckay

  13 replies

  14 years, 11 months ago

  By: Andrew Terwiel-314315

• OPENQUERY - Is there any way to...

  Hi experts, Is there any way to write a function such that it can dynamically return a string that …

  rightfield

  6 replies

  14 years, 11 months ago

  By: lightng

• Using REPLACE on non-display characters

  Hi I am having a few challenges using the REPLACE command. Basically I have a column called ADDR_L…

  insert_name_here

  2 replies

  14 years, 11 months ago

  By: insert_name_here

• Importing Selected Columns from CSV to SQL 2008

  Hi I'm new to Database. I have a CSV file with 20-25 columns and want to import only selected colum…

  NoviceJatt

  1 replies

  14 years, 11 months ago

  By: Greg Snidow

• splitting column into three

  Is it possible to strip out DESTINATION field into three one COL should show all LCL, NDC and SCF s…

  NEAL-464478

  2 replies

  14 years, 11 months ago

  By: Duncan Pryde

• [DTS] How to delete all rows in destination before import into ms-access

  Hi everyone, Hi gurus i have one question to asking all of you I try to export data from sql server…

  Tanin Nateglud

  1 replies

  14 years, 11 months ago

  By: PaulB-TheOneAndOnly

• Export DTS output into excel file

  Dear all, I would to get advice from you all about this scenarion: I need to design a DTS package a…

  golden-1131024

  2 replies

  14 years, 12 months ago

  By: mark.pleasance

• Sub-query with Case..When..Else (SQL Server 2000)

  I have a stored procedure with a sub-query which uses Case..When..Else as follows: CREATE PROCEDURE…

  HairyBob

  2 replies

  15 years ago

  By: HairyBob

• how to get sql server 2000 evaluation edition

  Hi all, This is gaurav.I am just entering in the world of sql server.I want to start with sql serve…

  gauravjoshi.kec

  1 replies

  15 years ago

  By: Elliott Whitlow