SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Translating Crystal Syntax to SQL difficulties.

  Hey All,Hoping to draw on some of the expertise on here! Currently struggling to translate the foll…

  lovelevel60

  1 replies

  7 years, 7 months ago

  By: Ken McKelvey

• @@TRANCOUNT (variable or function)

  The website below says that @@TRANCOUNT is a function.   But I read somewhere else that @…

  michael.leach2015

  3 replies

  7 years, 7 months ago

  By: Gail Shaw

• Init-cap the characters in SQL server

  Hi Sir, How to Init-cap the characters in SQL server in SQL query without creating any function? cr…

  kiran.rajenimbalkar

  21 replies

  7 years, 7 months ago

  By: Sean Lange

• SELECT from a View execute longer than normal

  Hi, I have this query SELECT  AIM.*FROM database1.dbo.vw_Customer  C WITH(NOLOCK) &n…

  mediacommentry

  3 replies

  7 years, 7 months ago

  By: Grant Fritchey

• Polybase - Syntax error

  Hi,So first up this is not a 2017 issue but in fact is actually a 2019 CTP issue. I've been trying …

  NicHopper

  2 replies

  7 years, 7 months ago

  By: NicHopper

• microsoft odbc driver 13 for sql server : domain\server logon failed error

  Hi,   We have Stored procedure to create the database using xp_cmpshell , it works fine i…

  sram24_mca

  3 replies

  7 years, 7 months ago

  By: Thom A

• CASE condition inside openquery not working

  Hello Everyone,  I need help with the below. When I am trying to run the below query using CAS…

  shummi21

  5 replies

  7 years, 7 months ago

  By: frederico_fonseca

• More than one check constraint per column?

  In the documentation for CREATE TABLE (Transact-SQL), under check constraints, I see: A column ca…

  g.britton

  23 replies

  7 years, 7 months ago

  By: g.britton

• Log return value from exec sp in job agent (step) history?

  Hi,I wonder if there's a quick way to have the return value from an EXEC stored-procedure Stat…

  rotcha99

  3 replies

  7 years, 7 months ago

  By: Phil Parkin

• dbMail parsing url ampersand to word "and"

  I'm using dbmail to gather data and send an email.  As a part of that email, I have a url surr…

  Janet Barnett

  3 replies

  7 years, 7 months ago

  By: Janet Barnett

• Order of column properties in column definition

  Suppose I create a table.  Then I specify a column name.  After that I have data type.&nb…

  michael.leach2015

  2 replies

  7 years, 7 months ago

  By: Jonathan AC Roberts

• Oracle Attunity Connector Queries

  Hi Folks,Need your help for better understanding of Oracle Attunity connector. Would appreciate if …

  BI_NewBie

  1 replies

  7 years, 7 months ago

  By: sgmunson

• SSIS :Flat File Source Transforming it into Two OLE DB SQL Table (Throwing Errors when I Convert and Sort before Loading into OLEDB Source)

  I'm trying to take a flat file and turn it into two tables in SSIS and Load to a OLEDB Source (SSMS…

  smithdan1157

  1 replies

  7 years, 7 months ago

  By: sgmunson

• What is binding in the column properties?

  In the column properties, there is a property called "Default Value or Binding."  What is mean…

  michael.leach2015

  2 replies

  7 years, 7 months ago

  By: michael.leach2015

• Finding when date changes for customer in table

  In table UserData, it accumulates rows for users every time there is some sort of transaction. …

  mnovosel

  14 replies

  7 years, 7 months ago

  By: x