git

10 SQL Snippets For Faster, More Effective Code

• by Gaurav Vohra

• SQLServerCentral.com

• SQL

• Article

How many hours per week do you spend writing the same SQL again and again?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.4 (10)

Log in or register to rate

You rated this post out of 5. Change rating

2015-07-16

7,973 reads

• Discuss

RE: OpenXML Problem

• by timfoster

• Redgate

• Reply

jt-75, you are my hero!!!!! I love you!!!!! If I was a girl (and you were, or are, a boy) I'd want to have your babies!!!!!My life is complete again. My code runs like the express train it should have been and not the overnighter (or direct express as Silverlink like to call it!!) from […]

2005-05-18

RE: Permissions

• by Steven-2

• Redgate

• Reply

Public access gives the user what ever permissions are assigned to the public role.You can have one database owner, but many people in the dbo group. dbo's have full access to the database in question.

2005-05-18

RE: How to move dts packages to new server?

• by ajay_k73

• SimpleTalk

• Reply

It is possble if both server are on. open package in design mode. go in package and use save as option. There you give new server name, username & password. hope this will solve your problem

2005-05-18

RE: ANSI_NULLS in where clause using ISNULL

• by Wayne-Lawton

• SQLServerCentral.com

• Reply

Brendthess: Antares is correct.  Your solution dropped various rows that should have been returned.Antares: Your assumptions and conclusions are completely correct.  Thank you for the confirmation that I am on the right track.G'day all,Wayne

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2005-03-04

RE: Restoring database in T-SQL

• by hoo-t

• Redgate

• Reply

If I understand your question, not being able to change the logical filename in the restore won't be a problem.  Give the database a new name, and new names for the physical files, and restore the database.  Once the database is restored, you can change the logical filenames with an ALTER DATABASE statement.  It doesn't hurt […]

2005-02-10

NaN in reporting Services

• by Munish-Bector

• Redgate

• Topic

Morning Guys 'n Gals,Hope someone can point me in the right direction:I keep getting a NaN error when I run my report in Reporting Services.Does anyone know of a way to replace the NaN with "---" in my report??Many Thanks Munish

2005-01-17

18 reads

RE: Cannot Register an Instance of SQL Server 2000

• by Robin Back

• SQLServerCentral.com

• Reply

Hi rmizzar!It might be caused by what protocols that are used. I would try to first set the language to tcp/ip and if that does not work, to named pipes.If you are logged in on the server when you do this, use the Client Network Utility and go to Aliases tab. Type in the servername […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-07-28