SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• How to create a trigger in the SQL table

  Hi I am an amateur starting to learn in SQL. Your gently consultation would be my profound thanks! …

  sathaporn

  2 replies

  15 years, 3 months ago

  By: Gail Shaw

• Limiting resultset to match column with only certain values

  Hi, I'm trying the following query in sql server: There is a person table where each person has…

  scfead1

  9 replies

  15 years, 3 months ago

  By: jennings_susan

• SQLSERVER Architecture

  Please let me know SQL SERVER 2005 architecture overview and Memory Architecture...

  Alone

  2 replies

  15 years, 3 months ago

  By: Grant Fritchey

• Do scripted Cascading Deletes NOT actual register in Foreign Keys?

  I have a script that includes this chunk... IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE obj…

  blandry

  3 replies

  15 years, 3 months ago

  By: blandry

• Using PIVOT

  Hi All, I have a query where PIVOT is used often. So i tried to understand it by working it on some…

  malavika.ramanathan

  2 replies

  15 years, 3 months ago

  By: malavika.ramanathan

• No catalog entry found for partition ID....

  I'm getting this error (on a sql server 2005 database, using code which has been working fine on 20…

  alex-746374

  20 replies

  15 years, 3 months ago

  By: henrik.litsne

• Understanding the logic from creating,inserting, and updating a table

  Here is the scenario I am trying to learn. I have three tables: 1)customer table cust_name nchar (5…

  Shadow.2802

  1 replies

  15 years, 3 months ago

  By: Shadow.2802

• detect change in a database

  Hi I need to find out what tables in a database changed after an operation how wouls I do this? que…

  Rob 8503

  4 replies

  15 years, 3 months ago

  By: SQLRNNR

• Newbie needs help with joining multiple tables

  What I am trying to do is populate data into column (trcd,transferamt) by doing an update to the #…

  Shadow.2802

  3 replies

  15 years, 3 months ago

  By: Shadow.2802

• How to Specify Length of Output Column in SELECT Stmt?

  hi experts, This is 2005. I want my report to contain everything on just 1 line, so I need to trum …

  dbaforever

  6 replies

  15 years, 3 months ago

  By: Jeff Moden

• Processing Cash sales

  I have a project which contains an order fulfillment module, which handles both cash and credit tra…

  goodguy

  2 replies

  15 years, 3 months ago

  By: goodguy

• Using SQLCMD, How to Specify Column Length for Output?

  hi experts, This is 2005. This code generates a report - works fine. But I want to reduce the colum…

  dbaforever

  1 replies

  15 years, 3 months ago

  By: Jeff Moden

• I want to get the alert message when the sqlserver restarted.

  I want to get the alert message when the sqlserver restarted. How to configure this?

  charipg

  4 replies

  15 years, 3 months ago

  By: charipg

• Incorrect syntax near '('.

  This has me puzzled. I have SQL 2005 SP3 on my laptop, and on a server. If I run this on my laptop,…

  homebrew01

  4 replies

  15 years, 3 months ago

  By: SQLRNNR

• SQLCMD Gives Error Must declare the scalar variable

  hi experts, This is 2005. I'm trying to run a Select stmt via sqlcmd, to generate a simple report. …

  dbaforever

  4 replies

  15 years, 3 months ago

  By: Adam Gojdas