Development

• Topics

  Started by

  Posts

  Last post

• What to Use Select or Set to Assign the values to Variable?

  Hi everybody, I am working on speed up the procedure and it has lot of calculation, i just wanted t…

  patelmohamad

  3 replies

  13 years, 11 months ago

  By: patelmohamad

• MERGE Functions on SQL 2005 ( Compatibility )

  I have the following script : insert into GODWIN_SalesOrderBOMs ( GODWIN_SalesOrderBOMs.SalesOrd…

  SteveEClarke

  4 replies

  13 years, 11 months ago

  By: tfifield

• Extracting date from text string

  I am trying to pull out the date '08/10/2011 from the below text column into a seperate field - 'Yo…

  pjsweat

  3 replies

  13 years, 11 months ago

  By: palash.gorai

• how to find Ram memory occupied by sql server

  Hi, I want to know how much RAM memory is using for sql server while running any job or insertin…

  vaithi.saran846

  16 replies

  13 years, 11 months ago

  By: spaghettidba

• Call ssis package from service broker queue

  Hi, i want execute ssis package from service broker queue.how can i call ssis package. plz let me …

  mupparaju78

  1 replies

  13 years, 11 months ago

  By: Orlando Colamatteo

• Unable to print variables outside of loop

  I'm getting a little hung up on this code for some reason. The Print statements inside the while c…

  jshurak

  5 replies

  13 years, 12 months ago

  By: gofrancesc

• ignore duplicate keys on clustered index

  I have one table Parent_Table with five columns EmpNo, EmpName, EmpDept, EmpReport. This table cont…

  sqlnaive

  2 replies

  13 years, 12 months ago

  By: Sean Lange

• Possible reasons for EXECUTE permission error

  Hi , My application in prod fails everyday at a particualr time with the error EXECUTE permission w…

  Giridhar A

  1 replies

  14 years ago

  By: SQLRNNR

• The OLE DB provider "SQLNCLI" for linked server "server" does not contain the table

  Hi guys , I have a linked server from witch i can select data .. like select * from 'srv'.'db'.sys…

  FatL

  1 replies

  14 years ago

  By: John Mitchell-245523

• making seperate table if row size increase?

  I have created table xyz int abc nvarchar(500) zxc nvarchar(4000) and few more filed with nvarchar…

  ajaysanhotra

  5 replies

  14 years ago

  By: Steve Jones - SSC Editor

• Objects in a datafile

  Can i Check list of tables within a datafile ? (In case i have more than 1 data files in the Primar…

  sqlnaive

  6 replies

  14 years ago

  By: Gail Shaw

• How to import the text file contents [ 500 mb] in to sqlserver 2005 schema

  We have an text file contents with more than 500 MB , we need to import this file contents to sqlse…

  sram24_mca

  5 replies

  14 years ago

  By: Gosta Munktell

• Code Speed

  I have code attached which looks at transactions in the AAACCTRA table, manipulates the data, write…

  tendayit

  5 replies

  14 years ago

  By: gofrancesc

• Query for datatype difference

  I have two tables A and B Table A contains few tables with there columns, datatypes & datatype…

  sqlnaive

  1 replies

  14 years ago

  By: LutzM

• SqlServer Stored Proceedure

  Hi all, Sorry if this is wrong place to write... My question is .. i do have a stored procedure whi…

  MuhammadShafiq

  2 replies

  14 years ago

  By: MuhammadShafiq