|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Getting T-SQL to use LIKE, REPLACE, and IN... all at the same time??????????????????? Posted by \ at 5/20/2006 8:33:33 PM
How in the world would you do this?
The user enters a word like: "BROWN".
The database contains a VarChar() field like: "RED,GREE*,BR*N,BLU*"
A match is found because the 3rd word "BR*N" matches "BROWN".
I guess I would have to use some combination of:
LIKE (for the wildcards).......more >>
to read backup file Posted by Zenek at 5/20/2006 4:38:41 PM Hello,
I have:
- server MS SQL MSDE (2000)
- database 'COLLBASE'
- table 'MAIN'
- row: column 'NAME' value 'version' and column 'VALUE' value '003'
I make backup files by SQL query.
I have more backups for different versions of this database (different
value in field 'VALUE' in table ...more >>
SQLDMO: Registry->AutostartMail property - where in registry? Posted by Mark Findlay at 5/20/2006 1:38:19 PM The SQLDMO Registry object exposes a boolean property called AutostartMail.
It is always returning FALSE, even though we have database mail configured
and enabled in SQL 2005.
I assume that since the SQLDMO Registry object exposes this property, that
it must be a registry entry somewhere we...more >>
substring search in each row with a different wildcard Posted by Axel at 5/20/2006 10:11:02 AM Hi,
I am looking for a solution for the following problem:
I have 3 columns in my table of my Customers records;
"Firstname", "Familyname" and the "Emailaddress"..
Here i want to match the -Firstname and Familyname- with the emailadress,
my aim here is to find the personalized emails. Th...more >>
SQL local server db connection Posted by ddevans888 NO[at]SPAM yahoo.com at 5/20/2006 8:22:08 AM I have found lots of information on my SQL connection but none of it is
helping. I am just learning and I am using Dreamweaver MX. I can see
my tables in DW but when I try to run my page I keep getting these
messages. I am working on my local PC with my SQL db connection on my
local PC. I ca...more >>
Between clause... Posted by Nando_uy at 5/20/2006 4:10:02 AM Hi all, I need write a stored proc with a clause like "between like xxx AND
like xxx" so, I can't. Thats is, a stored proc that returns values between
two parameters that use wildcards (for instance "LIKE @date").
Any Ideas. I read all the books and, I encounter information about BETWEEN
usag...more >>
xp_SendMail subject blank problem Posted by Sayem at 5/20/2006 3:10:23 AM Hi,
while sending mail through xp_sendmail the mail is sending properly.
but subject getting lost while viewing the mail from outlook.
can anyone help me.
code:
EXEC xp_sendmail @recipients = 'conmry@maersk.com',
@message = 'The master database is full.',
@copy_recipients = 'mah020@ma...more >>
HW Requirement for SQL Server 2005 Posted by perhiyar at 5/20/2006 12:11:03 AM We are running four servers at different sites say A,B,C and D and want
it to connect main Server at head office what would be the
configuration of main server for running SQL Server 2005.There are two
database say X and Y at each server at sites A,B,C and D. X requires
37.4 MB memory while Y re...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SP - drop table problem Posted by Agnes at 5/20/2006 12:00:00 AM In my store procedure, i will select some data into a temp table and then
drop it .
I am wonder if there are several people run the SP , will they create the
same table at the same table ??
Please help ~
select billingcode ,cocode into #tmpInfo from companyinfo where
rtrim(billingcode) = ...more >>
**Update** Posted by R-M at 5/20/2006 12:00:00 AM Hi
I'm working with SQL2000, and I defined the below structure:
MasterTable(No numeric(3),desc char(40)) No is PK
DetailTable(No numeric(3),code numeric(4),other char(40)) No&Code are PK
and I defined an Update Cascade for their relation.and I have an update
trigger on MasterTable.
My qu...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |