I am working with a script to exclude certain data types, and I was wondering if there is a comprehensive listing of the system.<datatype> for each of the...

• This reply was modified 5 months ago by cajun_sql. Reason: addition

Thanks very much!  Yes, I may do Regex replacing on the generated CSVs.

By the way, in DbaTools, is there any filtering based upon datatype of columns (e.g. AutoNumber) or the...

Addendum: Here's the code I've been using for export:

Credit to this link

#Initiate a connection
$MyConnection = Connect-DbaInstance -SqlInstance LOCALHOST\MSSQLSERVER -TrustServerCertificate
#Define a list of tables
$Tables = @("cop.table1", "cop.table2",...

I've been doing a bit more research into this in between other projects.

If I used powershell to export (like in this link - below), is there a way to use...

Thanks so much!

I'll check into those options to see what direction to go in.

(Your answer solved the error - thanks!)

Thanks for your input.

The first part of my post was an typo on my part - I had been getting the 'incorrect syntax' previously...

• This reply was modified 6 years, 3 months ago by cajun_sql.
• This reply was modified 6 years, 3 months ago by cajun_sql.
• This reply was modified 6 years, 3 months ago by cajun_sql.

Thanks very much!

I've been also looking at the example in the link you referenced. I just left the @urlKEY value empty, as I wasn't sure where its value came...

Thanks,

I've been working on this search/replace string and had a question about why the replace still is not occurring.

Below is the actual SQL I've been using in test:

UPDATE [dbo].[tbl_a]

SET...

daniel.freedman 80164 (10/15/2015)

---

It looks like you're overthinking it. Try something like this:

INSERT INTO aaa_test_users (UserName, first_name, last_name)

FROM aaa_test_sp

INSERT INTO aaa_test_users_positions (UserID, position, phone)

SELECT aaa_test_users.UserID, aaa_test_sp.position, aaa_test_sp.phone

FROM...

Sean Lange (8/20/2014)

---

cajun_sql (8/20/2014)

---

Sean Lange (8/20/2014)

---

cajun_sql (8/20/2014)

---

Thanks.

Why does the SQL INSERT statement succeed where...

Sean Lange (8/20/2014)

---

cajun_sql (8/20/2014)

---

Thanks.

Why does the SQL INSERT statement succeed where the Recordset AddNew...

Thanks.

Why does the SQL INSERT statement succeed where the Recordset AddNew fails?

Thanks - I wanted to share the solution, thanks to user AlwaysLoadingData on StackExchange:

SELECT

KSA.ID as KSA_ID

,KSA.KSA_Version

,KSA.KSA_Sort_Order_Number

...

LutzM (11/27/2013)

---

I'd go with a separate table with the columns ObjectiveId (as a foreign key reference to the current table), OutcomeId, KSA_aspectNo, KSA_AspectValue together with a column referencing the related.

I'm...

:-)Thanks for the great question, and (in your answer) thanks for showing the scenarios in which the other choices could be valid.

Nice detail work.