SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• help need in dynamic sql

  Hi, I am trying the bulk insert concept using the below link. http://blog.sqlauthority.com/2008/02/…

  KGJ-Dev

  7 replies

  11 years, 11 months ago

  By: KGJ-Dev

• Can't understand why some data is repeated

  Hi Everyone, I am trying to eliminate repeated data in my results, towards which end I am using the…

  david.dartnell

  8 replies

  11 years, 11 months ago

  By: Greg Edwards-268690

• SSIS + Procedure

  Hello guys, I have this procedure: create proc [dbo].[BulkPROC] (@table nvarchar(255), @dateimport …

  LOVER OF SQL

  11 replies

  11 years, 11 months ago

  By: LOVER OF SQL

• Create a table using script

  Hi, I have a create table script as .txt file. How can i create table using that script through sql…

  vinodhkumargv

  7 replies

  11 years, 11 months ago

  By: SQLCJ

• FK Constraint WITH CHECK causes parent delete trigger to fail

  Unless I misunderstand (which is entirely possible), when creating a FK constraint, the WITH CHECK/…

  souLTower

  2 replies

  11 years, 11 months ago

  By: Grant Fritchey

• Msg 8179, Level 16, State 2, Procedure sp_prepare, Line 1

  Hi while executing the profiler data getting the below error. declare @P1 int set @P1=3768 exec sp_…

  yuvipoy

  2 replies

  11 years, 11 months ago

  By: Ed Wagner

• sp_prepexec results in different and bad execution plan

  Hi, We massively imported 1.5 million rows in the ab_abcontact table a couple of weeks ago. Since t…

  FIJITechnologies

  1 replies

  11 years, 11 months ago

  By: Grant Fritchey

• Sum the column values

  Hi, I have this query where I do certain conversions and on top of this how can I sum the column va…

  vigneshkumart50

  3 replies

  11 years, 11 months ago

  By: Neil Burton

• How to find seed and increment for an identity column of a user type table

  I am using SQL Server 2008 R2. I created a type such as create type myTest as table (myCnt int id…

  mcginn

  4 replies

  11 years, 11 months ago

  By: zardoz1956

• Need some help - Float column type, force two decimal numbers

  Hi, I have the following values in a Float column 266.5 280.98 127.558 How do I set the precision i…

  gpascanu

  3 replies

  11 years, 11 months ago

  By: gpascanu

• SQL Server on domain or workgroup

  Hi Friends, I have very limited knowledge on this topic. I have worked and working on SQL servers o…

  DKG-967908

  4 replies

  11 years, 11 months ago

  By: EdVassie

• format LUNs with 64 k chunks for sql server

  Do we need to consider any parameters before we format LUNs with 64 k chunks for sql server? Is it …

  Mani-584606

  3 replies

  11 years, 11 months ago

  By: Mani-584606

• update stock table

  ordered quantity 7 I have a table that im trying to write an update query that will work down the r…

  CookieMonster

  1 replies

  11 years, 11 months ago

  By: SilentMike

• PagePID of DBCC IND('database','table',0)

  Hi I'm looking through the output of DBCC IND. The second column is PagePID, the page number in th…

  david.gugg

  4 replies

  11 years, 11 months ago

  By: david.gugg

• Need Query for Groups and Islands Problem

  Hi There, I'm having a table which have the data about the service activation and expiry day of cus…

  vignesh.ms

  2 replies

  11 years, 11 months ago

  By: g.britton