SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• using temp tables good Idea

  I am basically new to t-sql 2005 and have the following temp table questions: 1. I am wondering wha…

  jazzstein

  4 replies

  15 years, 7 months ago

  By: Jeff Moden

• View email body when it's in HTML format

  Anyone know if there's a way to view the body of a sent email, when it's in HTML format? I looked a…

  SQLDCH

  2 replies

  15 years, 7 months ago

  By: SQLDCH

• SQL 2005 query

  split column field value 2:1 or 25:13 as 2 1 or 25 and 13. 😀

  rudiger.nambiraj

  12 replies

  15 years, 7 months ago

  By: battery_acid_h

• Stored procedure with optional parameter

  hi. i am making a stored procedure where i pass 3 parameters and a column is checked for those para…

  mohitkumarsingh

  7 replies

  15 years, 7 months ago

  By: Florian Reischl

• new to sql server 2005

  I have several sqls scripts that I would like to combine. I would like to know how to calculate the…

  dianerstein

  5 replies

  15 years, 7 months ago

  By: Fraggle-805517

• Sql 2005 Update Script Question

  Hello all, I'm relatively new the SQL and really know some of the basics. My question is: I have a…

  Baronage12

  5 replies

  15 years, 7 months ago

  By: Baronage12

• A Giant Hurdle blocks my Giant Leap! (MSDE 2000)

  Hello Friends… Before going into why I am writing this, first I want to confess one thing. I am not…

  sprabhakaran.karuppaih

  6 replies

  15 years, 7 months ago

  By: Gail Shaw

• ADP File - Change SQL Connection string

  I have inherited an old MS Access ADP file and need to change the connection string from an old SQL…

  Colin Betteley

  2 replies

  15 years, 7 months ago

  By: Colin Betteley

• SQL instance and SQL AGENT icons

  Anyone know of a good link describing the different icons and what they mean? I have been looking a…

  jason.stephens

  8 replies

  15 years, 7 months ago

  By: Hawkeye_DBA

• history forecast data

  I have been told to find the forecast in history (i.e i took report that ran in last october and …

  itskumar2004

  2 replies

  15 years, 7 months ago

  By: itskumar2004

• A dumb question about Distinct - I posted this in the wrong forum earlier by mistake

  I have a table called DGUsers. This table has a primary key of UserID. I have another table called …

  meichner

  7 replies

  15 years, 7 months ago

  By: meichner

• Msg 7303: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)"

  I've been using the following stored procedure to pull data into a table from an Excel workbook gen…

  tmummert

  4 replies

  15 years, 7 months ago

  By: Rabia Cinar Yuksel

• Stored Procedure email

  Having a table as DETAILS with 7 columns which get automatically inserting or updating thru an XML …

  jaype-365633

  3 replies

  15 years, 7 months ago

  By: rashid.hussain

• Stored Proc returning invalid data

  select tup.intemployeeid,vuser.vcrFirstName+' '+vuser.vcrLastName as EmplName,dteallocatedon,intall…

  saurabh.kumar

  1 replies

  15 years, 7 months ago

  By: Gail Shaw

• server 2005 express - can't find solution explorer

  I'm very new to this, so sorry if this is a silly question. I have a technical query about SQL Serv…

  cranmer.mark

  4 replies

  15 years, 7 months ago

  By: Ron McCullough