SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  6 years, 2 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

  6 years, 2 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

  6 years, 2 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

  6 years, 2 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

  6 years, 2 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

  6 years, 2 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

  6 years, 2 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

  6 years, 2 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

  6 years, 2 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

  6 years, 2 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

  6 years, 2 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

  6 years, 3 months ago

  By: x

• What Steps Woud You Take: Inserting 200,000 records

  Hello guys, I'm a novice. I need to create a stored procedure to insert 200,000 records into an exi…

  Jacob Pressures

  6 replies

  6 years, 3 months ago

  By: Jeff Moden

• Translate numbers stored in char field to readable text

  I have a database without any real diagrams/explanations.  There is a definition table hold a …

  Janet Barnett

  5 replies

  6 years, 3 months ago

  By: Eirikur Eiriksson

• Undocumented "feature"(?) : full text CONTAINS (column_name, '"n*"') is matching numeric values

  One of my company's testers wrote up a bug about an area in our application returning more results …

  rschoedel

  2 replies

  6 years, 3 months ago

  By: Sue_H