azure sql database

RE: SQL query question

• by ershova

• Microsoft MSDN

• Reply

select * from MyTable where (field1=@value1 or @value1 is null) and (field2=@value2 or @value2 is null)That saves you from "pattern matching" for different types

2004-03-04

RE: Line Drawing Extended ASCII characters in Text Field

• by Frank Kalis

• Database Journal

• Reply

Ok, that sounds different. Not quite sure if I understand now, but would a look at CHAR and/or ASCII in BOL help? 

2004-03-01

RE: SQL Injection - Part 1

• by bryant@mindfair.com

• Database Journal

• Reply

The active account should not even be a DBO in the database(s) it uses. I recommend creating at least two db roles, one for general users and one for administrative access. Each role should only have permission to execute the stored procedures relevant to the role.This might be a little off-topic but is security ever […]

2004-02-25

funny results using view to oracle ...

• by Curtis-Smith

• Quest

• Topic

getting unexpected results when using a view with data from a linked oracle DB. Here's the case. I created a view in SQL and joined to the linked oracle db. the view works fine when i select all data from the view, however when i add a where clause such as "select * from my_view […]

2004-02-19

3 reads

RE: crc error in transaction log

• by chisholmd

• MSDN Communities

• Reply

Well I answered the question myself, NO I can't just delete the transaction log.  Fortunetly for me a complete chkdisk managed to correct the issue, I only had to wait for  a shut down opportunity.Dave 

2004-02-14

RE: Question of the Day for 29 Jan 2004

• by David Poole

• SQLServerCentral.com

• Reply

I wish Microsoft would invent a license that caters for home use.  I know you can get learning editions of VB and VC and VC# but it would be great if there was a learning edition of Visual Studio et al at a greatly reduced rate.A learning edition of Microsoft's server products would be useful […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-01-29

RE: Partial subscription

• by Roust_m

• SimpleTalk

• Reply

Just found a couple of SPs and wonder if this will work:1. You create a publication with N - articles2. Subscribe all servers that need at least one article from it.3. Use: sp_dropsubscription @publication = 'publication', @article = 'article', @subscriber = 'subscriber'to remove the articles not needed on particular subscriber. 4. If you need them […]

2004-01-27

1 reads

RE: Transactional Backups for archived data

• by Jeff Weisbecker

• SQLServerCentral.com

• Reply

jcool has a good point regarding referential integrity, constraints, and such. This could be an issue, but not impossible. As long as Primary keys stay unique and can never be duplicated. My suggestion for being able to recover the data is to archive it to another table or set of tables. Maybe even in another […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-12-09