SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Old Value

  I'm using this trigger to update specific columns.I want to get old values for some columns, but th…

  hrvoje.voda

  4 replies

  9 years, 2 months ago

  By: hrvoje.voda

• BEFORE TRIGGER Idea Posted to Microsoft Connect

  I have wished for SQL Server BEFORE TRIGGERs for a long time. I have posted to Microsoft Connect (…

  JediSQL

  16 replies

  9 years, 2 months ago

  By: TomThomson

• DBA Challenge! I've spent 4 hours trying to figure how to extract data from XML in a hierarchical form.

  I've searched the web to no avail.  So PLEASE help out!I have a table:CREATE TABLE [Course].[N…

  mrdba128

  4 replies

  9 years, 3 months ago

  By: Jeff Moden

• OpenDataSource query

  INSERT INTO OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0','Data Source=D:\Book1.xls;Extended Properties…

  RAKSHITHA

  1 replies

  9 years, 5 months ago

  By: sgmunson

• Query tuning - Help needed

  Hi all, I've been looking into this query and trying to see if there is any better way to write or …

  Feivel

  11 replies

  9 years, 7 months ago

  By: jbwa