T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• find correct string in column

  Hi, i'm a beginner with t sql and i have a table as this : tableBuilding (idBuilding int, nameBuild…

  christophe.bernard 47659

  3 replies

  15 years ago

  By: christophe.bernard 47659

• TSQL CSV issue

  What do I have wrong here? DECLARE @MappingIds NVarchar(Max) SET @MappingIds = 'E371F678-45DC-4C83-…

  JKSQL

  11 replies

  15 years ago

  By: Jeff Moden

• Nested XML Explicit encodes the xml to string

  I have an xml explicit sql in which I want to add another xml childnode in one of the nodes but wh…

  nikshepmehra

  6 replies

  15 years ago

  By: drew.allen

• ServiceBroker: Access to another db

  Hello, I'm new to ServiceBroker. I want to rebuilt the indexes on an express server every night wit…

  teutales

  4 replies

  15 years ago

  By: Evil Kraig F

• Alter View from Trigger Hangs

  Hi everyone I have a requirement to issue an "ALTER VIEW" statement preferably from a tables update…

  doug.milostic

  14 replies

  15 years ago

  By: Terry-239890

• Date Math - last day of last month?

  anyone know how to efficiently get the last day of last month. I suspect I can figure out a way to …

  nick jensen-354153

  8 replies

  15 years ago

  By: jcrawf02

• noob question about tracing and sp_prepexec

  Hello all, I'm tracing a customers db with sp_trace_create. Looking at the result there is a abnorm…

  teutales

  1 replies

  15 years ago

  By: GSquared

• minus dates

  hi all, i want to minus two dates i tried but nothing below is what i have done. DECLARE @stardt DA…

  hbujar

  3 replies

  15 years ago

  By: Johan Bijnens

• FOR XML PATH help SQL 2005

  Hi, I am trying to convert some data in xml, using FOR XML PATH. I am very new to FOR XML, hence ne…

  Shaun-884394

  5 replies

  15 years ago

  By: VSSGeorge

• Converting to decimal from Calculation

  I'm trying to get a result of a product to return a decimal number (i.e. 1.05) but I keep getting 1…

  latingntlman

  5 replies

  15 years ago

  By: ScottPletcher

• Creating XML in SQL

  hey hey hey! I have code it gives me an xml file that looks like this(I also supply the code below)…

  esilva002

  1 replies

  15 years ago

  By: mister.magoo

• Spreading out record over a date range to be analyzed on a day by day basis

  I'm not sure I have accomplished this task using best coding practises and I was just wondering if …

  loki1049

  6 replies

  15 years ago

  By: ScottPletcher

• Execute a store procedure when a row is inserted in a table

  I need to execute a stored procedure when a row is inserted in a table (Table A). The stored proced…

  sistemas_casinomnes

  3 replies

  15 years ago

  By: Gail Shaw

• Duplicating table data including related data in other tables

  Hi I've been searching for a solution to this problem for some time and cannot find a solution. How…

  david meagor

  4 replies

  15 years ago

  By: david meagor

• A way to script all DBs from a server

  Is there a way to script all Databases from a server?

  ramadesai108

  7 replies

  15 years ago

  By: parthi-1705