SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Need help with script alter and drop

  Guys I need a little bit support on this: My question is related to the following table: In the ta…

  alper18_b

  1 replies

  14 years, 4 months ago

  By: Brandie Tarvin

• SQL Mail Server with outlook pop3,smtp

  Good Day I am new to a company and was given a pet project to set up the sql mail server to send em…

  hansandersenyu

  9 replies

  14 years, 4 months ago

  By: Elliott Whitlow

• xp_sendmail max length for message

  What is the maximum length (chars)for the message using xp_sendmail. TIA Jim

  jim.rasmussen

  2 replies

  14 years, 4 months ago

  By: Meet George Jetson

• Database Up

  LocalServer i am created one database Name Sample.This Database includes Tables,Storedprocedure .I…

  sureshmca611

  1 replies

  14 years, 5 months ago

  By: MyDoggieJessie

• Find average of last three months

  I generate a report of our average sales by product group for the last 3 months. I have been using…

  vavfam

  1 replies

  14 years, 5 months ago

  By: GSquared

• help for sql

  I have these tables inv :invid(auot),invno(int),invdate(DateTime),invamt(currency),acctid(int) pay:…

  raj.lath-932078

  7 replies

  14 years, 5 months ago

  By: raj.lath-932078

• Inserting into multiple tables

  Hello, I need to insert into two tables. '1_id' is primary key auto generated and inserted into…

  rluke

  7 replies

  14 years, 5 months ago

  By: LutzM

• Who is in the building? Query

  Hello-- A request has come down to me where a manager would like to know, at any given time, a list…

  timothyriley01

  3 replies

  14 years, 6 months ago

  By: Ken McKelvey

• what size should i set on the comment column

  Hi everyone I need to create a table with a column that store comments from the user. I have no ide…

  dlam 18073

  18 replies

  14 years, 6 months ago

  By: Ben Miller

• Selecting a Value of the Order Within a Group

  I have a table of transactions that includes student ids and dates. I need to select all records fr…

  dkrumholz

  10 replies

  14 years, 6 months ago

  By: ChrisM@Work

• Get Parameter Name

  Hi all How to get the parameter name of the stored procedure in the table. Thanks Warm Regards, Sha…

  Shakti Singh Dulawat

  9 replies

  14 years, 6 months ago

  By: Jeff Moden

• Constraint based on the value of a different field

  I am a first time poster and fairly new to SQL development, so I will attempt to be as clear as pos…

  steven.bird

  1 replies

  14 years, 6 months ago

  By: LutzM

• insert data into SQL tables on different servers

  I have four fields in a table (this table gets reimported when a new item has to be added to tables…

  barb0822

  1 replies

  14 years, 6 months ago

  By: Lowell

• Verifying Backups and status

  I was trying to run this... and discovered my version (8.0.7) didn't like it SELECT B.name as Data…

  Vertigo44

  5 replies

  14 years, 6 months ago

  By: Vertigo44

• Assign a transaction number to separate instances of daily employee sign-in/sign-out transacations.

  I have several records of the same employee with multiple sign-ins (and sign-outs for each day. I h…

  fergusoj

  9 replies

  14 years, 6 months ago

  By: GSquared