Visualisation

Technical Article

RE: Openquery and using variables

  • Reply

My Linked Server name and sql query change. Even if I write multiple queries to fulfill all the conditions, I am still left with the linked server name as a variable?The latest thing is to use four-part name. Can I supply variables to do that job?We do not want the server locations to be hard […]

You rated this post out of 5. Change rating

2005-02-16

Technical Article

RE: Getting all the Functions in a DB and Re-Saving them.

  • Reply

It sounds like you might want this more automated, but if this is for occasional use you can script out all the functions by right clicking on the DB name in EM | All Tasks | Generate SQL Script |Show all |check the box for All User Defined Functions.  Then click the Options tab and check Script […]

You rated this post out of 5. Change rating

2005-02-10

Technical Article

RE: Execute statement in sp Urgent Help!!!

  • Reply

Hi Phill,Thanks for prompt reply... Actually Pls. find the the whole procedure... In which i am 1st import a text file. Then i have to Fetch the Table name from this file along with Column. And then insert into DB. Pls. find the whole procedure... for uor refrenceCreate PROC Sp_EnterTextFile @filename sysname    as     BEGIN        SET […]

You rated this post out of 5. Change rating

2005-02-03

Blogs

T-SQL Tuesday #176 One piece of advice that you wish Past you had

By

This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...

T-SQL Tuesday #176: One piece of advice for Past Steve

By

I almost missed this month, so this is also a good #SQLNewBlogger post. I...

Deleting Old Local Git Branches–#SQLNewBlogger

By

I had a lot of local branches for a repo (actually a few repos)....

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