SQL Storage Compress

Technical Article

RE: variable for DB name in sql script

  • Reply

Better yet just store the scripts as a file WITHOUT the DB Name. Then use a batch file to run the scripts via osql. Since the scripts will be running under the database context you have used to log into osql with you should be ok. The user would then simply open a dos box […]

You rated this post out of 5. Change rating

2003-12-18

Technical Article

RE: Init cap

  • Reply

quote: It's been a while since I done that conversion, therefore I'm not 100% sure, but I think something like this would work DROP TABLE myName GO CREATE TABLE myName( myn char(10)) go INSERT INTO myName (myn) VALUES('alfred') INSERT INTO myName (myn) VALUES('Alfred') INSERT INTO myName (myn) VALUES('berta') INSERT INTO myName (myn) VALUES('Frank') INSERT INTO […]

You rated this post out of 5. Change rating

2003-12-15

Blogs

The Future of the Social Web Is in Good Hands

By

The Social Web Foundation is aiming to grow the fediverse and make the social...

Monday Monitor Tip: Compliance Checking for Old Versions

By

A customer recently wanted to know if any of their instances were too old...

Making Legend Order Match Segment Order in a Power BI Stacked Column Chart

By

A reader of one of my previous posts pointed out that the legend order...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers