SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Best way to do same.

  create table main(fileNo Integer) insert into main values(1) insert into main values(2) insert into…

  surindersinghthakur

  4 replies

  13 years ago

  By: Gail Shaw

• Result of dynamic sql with parameteres into a variable

  Edit 25.4.2013::: Problem was solved, but I have question about view, my last reply... thx for resp…

  tony28

  26 replies

  13 years ago

  By: Orlando Colamatteo

• Reg:History of maintenance plan

  Hi, i went to maintenance plan s and want to view the history of that plan. when i opened…

  m.rajesh.uk

  2 replies

  13 years ago

  By: Noetic DBA

• Order issues

  Hello! I am importing data from a source system running IBM iSeries. I use OPENQUERY to query the s…

  Clark Bones

  1 replies

  13 years ago

  By: aaron.reese

• Truncate Log Script

  Hi Buddies, I got a Script for Truncate Logs... Please SUGGEST how to make this runnable **********…

  OnlyOneRJ

  3 replies

  13 years ago

  By: Gail Shaw

• Really Challenging Query: Break out average value across months

  Racking my brain on this one. I have the following table AccountID DataDate DataValue 1 …

  clary.david

  8 replies

  13 years ago

  By: ChrisM@Work

• How to track table schema changes

  Hi, I have a development database and some developer are use this one. I need to track the new tab…

  purushottam2

  2 replies

  13 years ago

  By: Mark Cowne

• Error converting varchar to numeric only in where clause

  Hi experts... I have a problem with one of my SQL Server query's... First of all, we are in SQL Ser…

  tom.wauters

  23 replies

  13 years ago

  By: ChrisM@Work

• concerns using linked server -security.

  We are designing of an application that using backend SQL database. When records are inserted into …

  sqlfriend

  3 replies

  13 years ago

  By: Mansfield

• Resizing the log file in Simple recovery mode

  Hi - A brief description of the problem and how it came to be..... We have a nightly data load into…

  PearlJammer1

  1 replies

  13 years ago

  By: Neeraj Dwivedi

• Sql Books

  I have series of following books but i have not gone through those books yet. I am planning on read…

  SqlServerLover

  5 replies

  13 years ago

  By: kapil_kk

• read txt file

  hello all. i use this T-Sql for reading txt file: select * from OpenDataSource( 'Microsoft.ACE.OLED…

  elham_azizi_62

  4 replies

  13 years ago

  By: Steve JP

• convert xml into csv

  I'm looking for an easy way to either convert xml to csv. I've tried using the SSIS xml source pack…

  ericwenger1

  4 replies

  13 years ago

  By: ericwenger1

• using NOLOCK in views

  I've done a lot of reading on using WITH NOLOCK and understand the pitfalls. We have a situation w…

  john (dba)

  4 replies

  13 years ago

  By: Evil Kraig F

• WHILE loop to relieve contention in an update

  We have a situation where the business requires some ETL to be done throughout the day on a product…

  Jared

  5 replies

  13 years ago

  By: Jared