Nelson Petersen (11/29/2016)

---

No need to specify all the columns when you only want to change one of them:

create table test9 (c1 number, c2 number, c3 varchar2(26), c4 varchar2(14) );

Table created.

alter...

t.franz (11/29/2016)

---

@steve-2: What would you do regarding the column order, when you are facing a CREATE OR ALTER <table> statement and the column order differs from the real. Recreating could...

Not for tables.

t.franz (11/29/2016)

---

I doubt, that an ALTER OR CREATE <table> would be used commonly, particularly since a CREATE table will usually need some indexes, FKs, CHECK CONSTRAINTs and some other stuff...

henrik staun poulsen (11/29/2016)

---

Steve,

I'm perfectly happy about the enhancement that we got with

DROP TABLE IF EXISTS myTable

CREATE TABLE myTable(...)

This ensures that the table is dropped, so that my Create table...

hakim.ali (11/29/2016)

---

IMHO, even "CREATE or ALTER objectname" can/should be reduced to just "CREATE objectname". Visual Studio database projects / SSDT has had this for years. Just issue the create statement,...

Indeed

robert.sterbal 56890 (11/28/2016)

---

It would be helpful to have a forum item to discuss the terms. Does one...

Try these:

http://www.sqlservercentral.com/articles/Drive+space/134523/

http://www.sqlservercentral.com/scripts/67064/

http://www.sqlservercentral.com/articles/61819/

david.gugg (11/28/2016)

---

That's pretty crappy documentation on Microsoft's part. I also found the answer on https://msdn.microsoft.com/en-us/library/hh231286.aspx, where it shows the example as

#Import the SQL Server Module. ...

My daughter grinds beans each morning for her french press and froths milk. She usually makes enough to give me a cup 😉

djackson 22568 (11/28/2016)

---

The trick is knowing when your staff can pick up something new, and when you need to hire consultants. Our organization excels at that. Of course...

SQLPS has been deprecated. The article update date is based on a change to the article, which could just be a typo correction or anything else. That does not indicate...

http://www.sqlservercentral.com/About/Terms

The content is copyrighted by authors, and its use is subject to copyright law.

1 - Use PowerShell and Start-Service and Get-Service to check the status of your service. You can run a job to do this in Windows Scheduler.

2 - There are scripts...