SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Why is INSERT INTO faster than INSERT

  I had to test this myself so I created 2 small SP's that use the same SQL statement, they just load…

  hanrahan_tim

  4 replies

  14 years ago

  By: Gail Shaw

• query help

  hello friends I have a task in that i need to display the values as comma separated in column. her…

  surma.sql

  2 replies

  14 years ago

  By: RP_DBA

• [Err] 22003 - [SQL Server] Arithmetic overflow error converting numeric to data type numeric.

  Hi there, I hope your help. This is the error in my query: [Err] 22003 - [SQL Server] Arithmetic ov…

  cms9651

  7 replies

  14 years ago

  By: cms9651

• odbcping

  Hi, I got to know that odbcping has been depricated from SQL Server. Is there any equivalent for it…

  sreeram.rengarajan

  1 replies

  14 years ago

  By: Orlando Colamatteo

• Update BOL?

  I read on Buck Woody's blog that SQL Books Online is updated several times a year. The BOL downloa…

  dan-572483

  2 replies

  14 years ago

  By: Steve Jones - SSC Editor

• how to make a search proc for this tables and their conditions ?

  here iam having 5 tables for example i have declare 5 tables the @adforum table is used for …

  Sivaganesh Tamilvendhan

  10 replies

  14 years ago

  By: Lynn Pettis

• Removing non-alphabetic characters from a column

  I have a single column table C column is fname varchar(255) I want to remove dirty data ie anything…

  sj999

  4 replies

  14 years ago

  By: Jeff Moden

• Mirror Time Recorded - Time to send - infinite?

  Hi, what could be issues as below records for mirror server? It is showing time to send INFINITE Ti…

  SQL Galaxy

  2 replies

  14 years ago

  By: SQL Galaxy

• Outer join not working correctly

  In the words of David Gray, please forgive me if i have posted this in the wrong topic and have ups…

  cmc_dermo

  19 replies

  14 years ago

  By: ChrisM@Work

• Is it possible to move table to different DB without changing connection strings?

  Would it be possible to move a table to a new database, but still reference it on the old name? We …

  chammann

  4 replies

  14 years ago

  By: chammann

• Basic Design Question

  I'm trying to model the concept of "teams" of "players". Each team has exactly two players. Intuiti…

  BSavoie

  10 replies

  14 years ago

  By: Lokesh Vij

• "This file was created in a previous beta version of Excel 2007. Open the file with Excel 2007 to save it to the most recent version of the Excel 2007 file format before opening the file in Access 2007."

  Hi, I am using SSIS 2005. Got the source file in XLSX format. As 2007 format not supported in SSIS …

  sqlstud

  1 replies

  14 years ago

  By: Gail Shaw

• SSIS DATA FLOW

  Hi all, I'm new to sql server,so please help me to know about this. 1) whether the ssis package …

  sathiyan00

  3 replies

  14 years ago

  By: rhythmk

• Unable to zip the backup data

  Hi All, I am unable to zip the backup data. In my server i installed the 7z (zip software). …

  saidapurs

  11 replies

  14 years ago

  By: saidapurs

• SQL server will bring back the wrong search result when run the command line which includes I or i

  Hi, I’m using SQL server 2008R2, version number is 10.5, in Turkish. I have setup a database and us…

  bigantsoft

  1 replies

  14 years ago

  By: Jeff Moden