SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• DateTime Field Hide time if it is midnight

  I need a query to hide the time from a datetime field if the time is midnight. I tried a case state…

  gtjr92

  6 replies

  8 years, 5 months ago

  By: gtjr92

• EXCEPT returning matching rows

  Hi, I made a change to a query to return data quicker.  I used the EXCEPT operator to make sur…

  cpeck

  4 replies

  8 years, 8 months ago

  By: cpeck

• 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

  8 years, 8 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

  8 years, 9 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

  8 years, 9 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

  8 years, 12 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, 1 months ago

  By: jbwa