SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Loop Query of Data

  Hi, I am having trouble getting my head around a problem. I am trying to retrieve info from a sing…

  tony riordan

  4 replies

  17 years, 7 months ago

  By: tony riordan

• Trigger causing locks on table

  Hello, I tried to implement an insert trigger on an order entry label and for some reason it impose…

  Karim Hemani

  6 replies

  17 years, 7 months ago

  By: Karim Hemani

• Comparing Time Stamps

  The application my db is tied to allows the user to select times for filtering the data (for exampl…

  Mark Harley

  1 replies

  17 years, 7 months ago

  By: Mark Harley

• Adding a column to a table

  I have a temp table (in a stored procedure) of grouped data that I need to add a column to. The ta…

  Mark Harley

  11 replies

  17 years, 7 months ago

  By: Brandie Tarvin

• change dts package

  I've got a simple dts package that imports a single data value from a text file into a single colum…

  jeffreym

  2 replies

  17 years, 7 months ago

  By: jeffreym

• Connect to remote SQL 2005 db

  My host recently moved my sites and dbs across to a new Win 2003 Server and SQL 2005 server. I can …

  Stephen Doyle

  8 replies

  17 years, 7 months ago

  By: Vidhya Sagar

• Exam 70-228....to be discontinued...?

  Greetings all, [first post here] I am a newbie studying towards the 70-228 exam. I already have the…

  Ads-520531

  1 replies

  17 years, 7 months ago

  By: Steve Jones - SSC Editor

• Creating A Row Number

  I need assistance with creating a column in my table that shows a row number. The reason for this i…

  Salvatore B. Conti Jr.

  3 replies

  17 years, 7 months ago

  By: Simon E Doubt

• I/O error bad page id when attempting to select * into tableA from tableB

  In an attempt to fix table problems on a SQL Server 2000 production database I ran the following: s…

  rlgaskin

  2 replies

  17 years, 7 months ago

  By: rlgaskin

• Database Connection error

  Hi, I want to make a database connection using the "create new database connection" wizard. But I k…

  soenita.sattoe

  2 replies

  17 years, 7 months ago

  By: Vidhya Sagar

• Making a copy of a SQL Server database

  Hello, Could someone please give me any hints on how I can make a duplicate copy of an entire SQL S…

  Karim Hemani

  2 replies

  17 years, 7 months ago

  By: Vidhya Sagar

• SQL Select query from 2 table Parent /child and retrieve 1 record for each parent

  I have looked for a solution to this problem for hours in google. I want to use sql select and ret…

  PGRAY-542347

  11 replies

  17 years, 7 months ago

  By: PGRAY-542347

• Incorrect syntax for CASE but looks good to me

  Hi experts, What is wrong with this piece of code. Parsing says incorrect syntax but it looks right…

  rightfield

  4 replies

  17 years, 7 months ago

  By: rightfield

• I want to create a new Transaction Log file

  One of my databases has a rather large Log file ~12GB compared to data ~1.5GB. Before I started man…

  xintanaka

  7 replies

  17 years, 7 months ago

  By: xintanaka

• Lookup data from another table

  Hi Guys, I have a 3 tables: stage3 which has this layout: Stage3ldint Stage1ldint Issueldint Iss…

  Steve Wilson-461924

  4 replies

  17 years, 7 months ago

  By: Steve Wilson-461924