General

• Topics

  Started by

  Posts

  Last post

• DB architecture — Which database is best for single key search

  I have a very simple database, which consists of two tables: TabA , idA binary(32) Primarykey NOT N…

  Blue Mancunian

  1 replies

  5 years, 3 months ago

  By: MVDBA (Mike Vessey)

• Searching for constructive criticism/feedback on a "SQL Search"-ish proc I wrote

  #roastme? lol...kidding... tl;dr: I wrote a proc that basically does the same thing as Redgate SQL …

  chad 62627

  1 replies

  5 years, 4 months ago

  By: chad 62627

• Return a value if record does not exist

  Hi, Is is it possible to retun a value from a select statement if the record does not exist in the …

  nick_roberts5

  6 replies

  5 years, 5 months ago

  By: David Burrows

• Running scripts from a share/git etc

  I have been playing with this for the last few days and have come up with nothing, so over to you a…

  Mad_cow

  1 replies

  5 years, 5 months ago

  By: John Mitchell-245523

• day shift job

  I am working as a DBA from past 8 years. There are shifts(eary morning, afternoon, night). I want t…

  coolchaitu

  2 replies

  5 years, 5 months ago

  By: MVDBA (Mike Vessey)

• Using Java script to import word and pdf into SQL server

  I am looking for example or use case codes  in using Java script to import Word document and pdf i…

  pcq0125

  13 replies

  5 years, 6 months ago

  By: pcq0125

• NetSuite - System_Notes SQL to obtain STATUS as of a past date using SYSTEM_NOTE

  Hi all, Everything I've seen on the subject of NetSuite Course SYSTEM_NOTES discusses mostly saved …

  liana.melissa12

  1 replies

  5 years, 7 months ago

  By: Erland Sommarskog

• List of And parameters

  Is there a way to create a SQL string to test against a list of OR parameters without going equals …

  millarman

  2 replies

  5 years, 8 months ago

  By: millarman

• VBA Error Handling When Opening Another Macro

  I have a process in which a macro loops through a list of other macros to run. I'm trying to add er…

  RonMexico

  4 replies

  5 years, 9 months ago

  By: RonMexico

• SQL Server 2019

  When will there be forums to discuss 2019?   Regards   Andrew

  AndrewL65

  1 replies

  5 years, 10 months ago

  By: Thom A

• Truncating table using linked server

  Hi, I am trying to truncate table which is in another database, i m accessing it thru linked server…

  cutespn

  5 replies

  5 years, 10 months ago

  By: rafaelbahialde

• SQL advice needed.

  I'm unsure where to post, so sorry if in the incorrect section. I need a tool that will look up all…

  Michaeldaangelo121

  2 replies

  5 years, 10 months ago

  By: Mr. Brian Gale

• Problem pasting datetimes from SSMS into Excel

  If you run a query in SSMS that contains datetime columns (with fractions of a second) then paste t…

  Jonathan AC Roberts

  2 replies

  5 years, 10 months ago

  By: Mr. Brian Gale

• MSDN Subscriptions

  5 years ago I use to have an annual MSDN Subscription which enabled me to download versions of Win…

  lockered

  2 replies

  5 years, 11 months ago

  By: lockered

• if/then or case return?

  Hi folks. I get the if/then and case keywords for conditionally setting field values, what I don't …

  Munty

  2 replies

  5 years, 11 months ago

  By: Munty