SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Connection String for Network SQL Server

  Let me warn you I am new to SQL Server and network admin. I know I need to learn, but I don't even …

  tdhall_75233

  5 replies

  15 years, 5 months ago

  By: A. Harmon

• number of rows returned different when applying joins

  HI, I have two tables emp1,emp2 both having field as id.Both have 6 rows already present. When i wr…

  shyam.oec

  6 replies

  15 years, 5 months ago

  By: shyam.oec

• Help querying a many-to-many

  Previous posts have given me a very nicely populated many-to-many linked table, but now I am runnin…

  mstevens92

  4 replies

  15 years, 5 months ago

  By: mstevens92

• how to restore backup from sql 2000 (32-bit) to sql 2008 (64-bit)

  I am having a SQl-2000 over a win-2003 SBS. Now I am having new server win-2008 & SQL-2008 sta…

  balrajmk

  4 replies

  15 years, 5 months ago

  By: Perry Whittle

• SQLServer 2008 Install on Windows 2008 Server Info Needed

  Hi Folks having installed SQLServer2005 on a Windows 2003 server,, I was able to find some document…

  JC-3113

  1 replies

  15 years, 5 months ago

  By: JC-3113

• Installation of AdventureWorks Sample Database

  I was installing the AdventureWorks Sample Database and noticed something interesting: The installe…

  Like2SQL

  1 replies

  15 years, 5 months ago

  By: PaulB-TheOneAndOnly

• crosstab SQL Server 2000

  I have two tables with a one-to-many relationship: Patient and Followups. I would like a SELECT to …

  orca

  14 replies

  15 years, 5 months ago

  By: LutzM

• Speed difference with or without FK

  is it important to query optimizer if there is FK between two tables or not? for ex. table A (a_id,…

  endo64

  13 replies

  15 years, 5 months ago

  By: Paul White

• Is this query a join?

  Hi , i have two tables emp1,emp2 with id field in both tables. when i wright this query " select em…

  shyam.oec

  3 replies

  15 years, 5 months ago

  By: SQLRNNR

• Trigger to send an email when ever a table is updated

  hi all i want to monitor a table for any changes (update, create , delete) and send an email when e…

  dopydb

  25 replies

  15 years, 5 months ago

  By: Jeff Moden

• SQL Query

  Could someone look at the query below and tell me why it would produce the results that I included …

  ronaldkrex

  2 replies

  15 years, 5 months ago

  By: LutzM

• Only one row for each fldVaraID

  Hi I have this SQL query SELECT dbo.tblVara.fldKategori, dbo.tbVara.fldVaraID, dbo.tblVara.fld…

  fiaolle

  6 replies

  15 years, 5 months ago

  By: fiaolle

• Do System Databases Ever Get Corrupted? And if so, what to do ?

  I have a quick question: Has anybody ever encountered the problem of system databases being corrupt…

  Like2SQL

  1 replies

  15 years, 5 months ago

  By: Gail Shaw

• Error Code 0x80070002

  ok. I hope you guys can handle my pain in the rear questions. I am new to the server side of things…

  Perissos

  3 replies

  15 years, 5 months ago

  By: Perissos

• Help with Datediff function

  Hi Everyone, I have a table called "PaymentsSchedule" as below: IDSequenceScheduleDateAmount…

  kam7395

  4 replies

  15 years, 5 months ago

  By: divyanth