SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• updating a table from one database to identical database on other server

  I need help in creating a script for updating two tables called "table1" & "table2" from datab…

  Mayraj Khan

  8 replies

  18 years, 10 months ago

  By: Clive Strong

• empty string

  what's the syntax for checking for empty string in a SQL statement? Len(VarcharCol)>1 gave an …

  smknox

  7 replies

  18 years, 10 months ago

  By: smknox

• Generating a new column as column(i)-column(i-1) values

  Hi, I would appreciate your help on this: I am trying to generate a new Field2 from Field1 so that …

  Ned-357880

  2 replies

  18 years, 10 months ago

  By: Lowell

• Automating Procedures to execute

  I am trying to figure out if there is a way for me to write a script or something to that nature th…

  Chad-357551

  3 replies

  18 years, 10 months ago

  By: Jasmine D. Adamson

• SQLH2 - Access to the registry key is denied

  Hello, I am running SQLH2 version 2.02 and am trying to report on 18 servers; 10 are disp…

  Peter Geppert

  5 replies

  18 years, 10 months ago

  By: Peter Geppert

• Datepart argument of DateAdd

  Is it possible to allow the datepart argument of the DateAdd function to be passed into a stored pr…

  W F

  1 replies

  18 years, 10 months ago

  By: Aaron Ingold

• Calc the size of a table(s) in a database

  If I have a database with a list of tables is there a way to calculate the size of each table indiv…

  johnsmith-357033

  2 replies

  18 years, 10 months ago

  By: Greg Milner

• Left of a comma

  I have a field in a table that is a last name, first name (ID), I can parse this out in EXCEL in my…

  Richard Sabbara

  2 replies

  18 years, 10 months ago

  By: Ken McKelvey

• Merging two fields together

  I have two fields from an AS400 which i want to merge when i extract the data using Data Transforma…

  Jonah-356166

  6 replies

  18 years, 10 months ago

  By: Dan Murray

• Is it Possible to use '' if 0'' and '' Set '' in a view

  Hi Is it possible to use set or if keywords in a view Thanks  

  Vandy

  3 replies

  18 years, 10 months ago

  By: Vandy

• dts package reading text doc

  Hi, Currently, I am doing a vb programming that reads a text file and put the data into a specified…

  isay

  1 replies

  18 years, 10 months ago

  By: Greg Charles

• Count rows in DB,with Table name,SpaceUsed, Update Statistic

  Hi ! Can any one help me as a newbie ASAP Pl. I need some simple code or SP to do the task,cou…

  Kashif A

  1 replies

  18 years, 10 months ago

  By: Dinakar Nethi-176633

• Search entire database for date fields

  I have a database that i need to create a script to search it for date fields, I am looking fo…

  Jeff Turl

  13 replies

  18 years, 10 months ago

  By: John Mitchell-245523

• sql server express edition

  As SQL Server Express Edition doesnt include ssis is there another way of using the features that w…

  Christopher Mark

  1 replies

  18 years, 10 months ago

  By: SwePeso

• Adding a known variable in Stored Procedure

  I'm using a stored procedure to insert equipment fault records into a table that I would like to mo…

  Jeff MacVicar

  4 replies

  18 years, 10 months ago

  By: Jeff MacVicar