Viewing 15 posts - 7,411 through 7,425 (of 59,072 total)
Hey Jeff,
sadly not my choice, but they are deploying an application, and the application is requesting to create some schemas, so, I hoped they would give me the scripts...
March 31, 2020 at 2:09 am
Ok... so we have the following test code from the article...
DECLARE @tab TABLE(Col1 GEOMETRY);
INSERT @tab(Col1)
SELECT GEOMETRY::STGeomFromText('POLYGON((1 0, 1 1, 0 1, 0 0, 1 0))', 0) --...
March 31, 2020 at 1:35 am
Privacy has always mattered. We just gave the up the first time we opened a bank account or bought a house or bought a car or applied for/used a credit...
March 31, 2020 at 1:10 am
The next question would be.... why are you giving users privs to create schemas?
March 31, 2020 at 12:59 am
Here's something funny (not really)... I don't know how to run the PowerShell examples from the command prompt. I've done it plenty of times building a string in T-SQL and...
March 30, 2020 at 11:37 pm
Thanks, Frederico. I aware of AWK but, pun intended, I've never used it before so I'm a bit AWKward there. 😀
March 30, 2020 at 11:34 pm
If you don't understand these steps, I'd suggest finding a tutorial on SSIS that includes setting variables, ForEach and Connection Managers.
That's why I'm asking people to...
March 30, 2020 at 11:13 pm
The JBMTest table code is on the first page of this thread a little more than half way down but here it is again just to make things easy.
March 30, 2020 at 10:48 pm
My question would be... has anyone run the PowerShell code to make sure it works (with replacements for the table name, etc, of course)? I ask because I'm no PowerShell...
March 30, 2020 at 9:00 pm
BWAAAA-HAAAA!!!! There's enough bad code out there for me to be really peeved about that I just don't care where the semi-colon is so long as it's there. In fact,...
March 30, 2020 at 7:53 pm
Crap... I'm sorry Jeffrey. I hit "report" instead of "quote" on your post by mistake.
As for the partitioning, please don't put words in my mouth. The original decision to partition...
March 30, 2020 at 7:25 pm
Thanks everyone for the help.
You're welcome but what have you ended up doing?
March 30, 2020 at 2:04 pm
See Chad Miller's Powershell function Write-DataTable
Got a link?
March 30, 2020 at 2:02 pm
Viewing 15 posts - 7,411 through 7,425 (of 59,072 total)