SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Checking varchar data to see if it can be cast as decimal

  Hi, I have a varchar field. Most of the values in this field are numeric, and we need to update th…

  tarr94

  8 replies

  12 years ago

  By: ScottPletcher

• can you search linked servers for rmtuser?

  Hi SQL server central colleagues, I need to search through all our linked servers looking for speci…

  jb_sql_geek

  3 replies

  12 years ago

  By: jb_sql_geek

• IDENTITY_INSERT problem (doing something stupid?)

  Here's my script: SET IDENTITY_INSERT SecuritySettings ON INSERT INTO SecuritySettings SELECTSecu…

  ronmoses@gmail.com

  4 replies

  12 years ago

  By: ronmoses@gmail.com

• restore with modify datafiles

  I need to restore the databases since the datafile names are same in server so i need to modify th…

  ramyours2003

  1 replies

  12 years ago

  By: joshdbguy

• import 2010 excel spreadsheet

  We are trying to import 2010 excel spreadsheet(I believe it 32 bit). I created a siss package via t…

  mikejone

  4 replies

  12 years ago

  By: mikejone

• How to compare two string columns in SSRS?

  Hi Team, I have a requirement to compare two string columns in SSRS and provide the result as an ex…

  kish1234

  1 replies

  12 years ago

  By: doug.brown

• SSIS - For Each Loop

  I'm working with an existing SSIS ETL package to add custom logging that will write specific entrie…

  OTPS

  4 replies

  12 years ago

  By: Luis Cazares

• More then one complaint by same customer

  I'm newbie, trying my hands on SQL . working on to provide detail report where complaint register …

  kshatriya24

  3 replies

  12 years ago

  By: Luis Cazares

• Query to pull data from XML String stored in Nvarchar column

  Hi, I have a column with datatype nvarchar where we are storing XML string, e.g below <?xml vers…

  pujain

  1 replies

  12 years ago

  By: CKX

• Retrospectively Changing Collation of Table

  Hi Is it possible to change the collation of a specific table within a database retrospectively? Or…

  wak_no1

  2 replies

  12 years ago

  By: wak_no1

• Need Script to Run in USER DB

  A quick one for any T-SQL Gurus out there. I need this to always run in a user db. How do I get the…

  Super Cat

  4 replies

  12 years ago

  By: Ed Wagner

• Convert the column to money

  Hi, cast(round([YearlyProfit]-[MonthlyProfit],0)as int), cast(round(isnull(sum(SalesProfit]),0),0) …

  vigneshkumart50

  1 replies

  12 years ago

  By: djj

• DBCC ShrinkDatabase + Insert Query same time

  Hi, This is general one not specific to Database version(2k/2k5/2k8) DBCC ShrinkDatabase + Insert Q…

  yuvipoy

  8 replies

  12 years ago

  By: humbleDBA

• SQL server log folder

  My SQL server log folder is filling up so fast what could be causing this?The path is C:\Program Fi…

  kapfundestanley

  5 replies

  12 years ago

  By: Gail Shaw

• IFF with multiple conditions

  Hello Everyone, I have a number field. I would like to display the value as whole number if the va…

  kcha2004

  1 replies

  12 years ago

  By: mister.magoo