SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Create Columns using Row Data

  Hi Guys, I need to find a way where I can dynamically create columns for the data rows. I need to c…

  Ghanta

  4 replies

  14 years, 5 months ago

  By: Ben Teraberry

• Update Trigger for changes to the Primary Key

  We use cascading updates for changes to the Primary Key of an important table in our system and the…

  ted_oconnor

  8 replies

  14 years, 5 months ago

  By: ted_oconnor

• Using initial query results to build sub query

  I'm not sure if my subject described this well, but here's the question: Looking a registered produ…

  mcooper008

  10 replies

  14 years, 5 months ago

  By: mcooper008

• problem with stored procedure

  Hi All, Iam having clientlist table which contains clients username and the clientversions details.…

  rams.prsk

  10 replies

  14 years, 5 months ago

  By: Evil Kraig F

• check constraint before insert

  Hi, is there a way to check constraints before the INSERT INTO command is executed? I would like in…

  info 58414

  4 replies

  14 years, 5 months ago

  By: spaghettidba

• DB Size Space Used vs. sp_spaceused for each table

  Hi, When right clicking on a database in SSMS and obtataining "space used = size - space available"…

  Lexa

  1 replies

  14 years, 5 months ago

  By: Lexa

• Service Broker - Executing stored Proc on another database.

  Ive been asked to customise a COTS product and dont want to turn on service broker on that db but i…

  wesley.boyd

  2 replies

  14 years, 5 months ago

  By: wesley.boyd

• Evaluating PIN codes

  Hey I'm having a really stupid moment. I have a column that contains PIN codes (4 digits, alphanume…

  spleenlessstu

  6 replies

  14 years, 5 months ago

  By: ChrisM@Work

• SQL 2008 - Procedure execution cost in CPU

  Hi Team, I got a request from one developer. On SQL 2008 SP1, he needs to find out CPU usage in % o…

  chetanr.jain

  6 replies

  14 years, 5 months ago

  By: Devendrakumar

• How to check Table Column In like

  I wan to check Table Column in where Clause like where Table.Column like 'Table.Column%'

  Bipinkumar Yadav

  4 replies

  14 years, 5 months ago

  By: Bipinkumar Yadav

• sql query

  declare @t1 TABLE(id int,region varchar(10),Lamt decimal(20,3)) insert into @t1 values(1,'x',10.12)…

  subbu1

  7 replies

  14 years, 5 months ago

  By: adil.hussain755

• How can we set output variable to null

  Hello Everyone, Please help me. I want to create a procedure which will take output parameter nulla…

  vishal_mca2005

  2 replies

  14 years, 5 months ago

  By: vishal_mca2005

• OPEN QUERY INSERT INTO Syntax Error, SELECT INTO Works Fine

  I'm dynamically generating an OPEN Query Statement (DB2) and generating the Account_Numbers from a …

  Welsh Corgi

  3 replies

  14 years, 5 months ago

  By: spaghettidba

• Access 2010 to SQL 2008 R2 ODBC Error

  Hi All, I'm have a database using Access 2010 as a front end and Microsoft SQL 2008 R2 as a back en…

  RollyPolli

  10 replies

  14 years, 5 months ago

  By: RollyPolli

• HOW TO CHECK THE SOURCE OF THE DATABASE BACKUP FILES

  Hi, I have a situation whereby i have SQL Backup files being dumped to one of my Drives and filling…

  FTdenali

  3 replies

  14 years, 5 months ago

  By: Devendrakumar