Development

• Topics

  Started by

  Posts

  Last post

• Find specific values in sql XML-query

  I have the below xml column in database : <row id="10000000" xml:space="preserve"> <c1&g…

  pitioageneral

  4 replies

  10 years, 2 months ago

  By: Eirikur Eiriksson

• Run the script for each database

  Hello All, This might be a very simple for some but I am in a bit pickle for this. i have run on …

  BoobyB

  7 replies

  10 years, 2 months ago

  By: Jamie-2229

• remove line breaks from xml

  Help how can i remove line breaks from my xml data when i export it to excel it breas

  raymond.konker.williams

  2 replies

  10 years, 2 months ago

  By: Eirikur Eiriksson

• Is it possible to simulate the cross apply function?

  My database in SQL 2005 has a compatibility of 80. I cannot change the compatibility level on the …

  vwilliams

  14 replies

  10 years, 2 months ago

  By: Luis Cazares

• Data from one Table to Two Columns

  Hi All, I need a help to populate the Data in two Column from one table DRIVER_IDDRIVER_NAMELOGG…

  patelmohamad

  23 replies

  10 years, 2 months ago

  By: Eirikur Eiriksson

• Updates in stored procedure

  Hi, I have a table 'ABC' and a stored procedure which updates 'ABC'. I update the table 'ABC' ever…

  susmitha117

  2 replies

  10 years, 3 months ago

  By: rahul.rahuzz

• Display One CompanyCode values instead of other companycode

  Hi, I got stuck at one scenario. The requirement is, I have CompanyCode, ItemNumber and PlannerNumb…

  yvbchowdary

  2 replies

  10 years, 3 months ago

  By: rahul.rahuzz

• datetime check constraint for 23:59:59.997

  I need to add a check constraint on a field that checks the time of the date to make sure it is 23:…

  dirk.dromgoole

  12 replies

  10 years, 3 months ago

  By: Jeff Moden

• can sql server add columns dynamically

  I have XML files that need to be put into a table. The problem is that the nodes can range from 1 t…

  gdailey 74486

  3 replies

  10 years, 3 months ago

  By: Luis Cazares

• SQL Server does not allow remote connections.".

  HI, I HAVE LINKED SERVER .... I M EXECUTING A FROM SERVER1 select * from [SERVER2\dev].COMPANYNAME…

  Bhuvnesh

  6 replies

  10 years, 3 months ago

  By: desperadomar

• INSERT multi-table foreign keys from XML

  Hi I trying to build a SP in which I'm inserting foreign key values into a table from XML as follow…

  Carlo Clausius

  4 replies

  10 years, 3 months ago

  By: Carlo Clausius

• "Cursor operation conflict"

  HI INSERT INTO [srsvr\dev].db_lines.dbo.SYNC_OBJECT_RECEIVE_IN_M(object_name,eventtype,Created_by) …

  Bhuvnesh

  7 replies

  10 years, 3 months ago

  By: Sean Lange

• Use a select query to assign parameters to a stored procedure

  Hi, I have a stored procedure that accepts 3 parameters - Date, Location and Item and returns the d…

  pssudarshan

  1 replies

  10 years, 4 months ago

  By: pssudarshan

• User Defined Data Types versus User Defined Types

  In SS Mgmt Studio under Database>Programmability>Types... there are two User-defined type opt…

  kanejeeves

  2 replies

  10 years, 5 months ago

  By: amit_adarsh

• SQL Server Database Developer Role Dying?

  I just wanted to get some opinions from other database professionals. My current employer is trying…

  david.tyler

  11 replies

  10 years, 5 months ago

  By: EdVassie