|
|
|
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 Sql Server 2005 Full Text Catalog Question Posted by Ben at 2/5/2006 8:08:17 PM I'm trying to enable change tracking on a full text catalog that I have.
I'm seeing interesting results.
For starters, I used to use:
FulltextCatalogProperty(N'Table_Name', N'ItemCount')
To determine how many items were indexed. Then I do math against the total
number of items...more >>
project deployment issues Posted by nathan.atkins NO[at]SPAM alcoa.com.au at 2/5/2006 7:33:35 PM Im having some issues when deploying my project written in vb.net which
uses and Sql server database. During development I used my local
machine as the server database, and this worked fine for myself and
other users on remote pcs.
But now I have changed the sql connection string to point to a
...more >>
Where is the OpenFileDialog? Posted by De kessé at 2/5/2006 6:56:00 PM How do I get an openfiledialog in an asp.net page?
I try me.openfiledialog but it does not work...
...more >>
combining 2 or more columns "as" one column in a select statement Posted by ads at 2/5/2006 6:41:27 PM hi guys,
how do u combine 2 columns as one in a select statement such as:
"select firstname,lastname from tablename"
where firstname and lastname are to be combined as single column called name.
i had difficulty finding other resources for this issue.
Thanks in advance,
Ads
...more >>
Stored procedure performance Posted by Naveen at 2/5/2006 2:57:15 PM I have a stored procedure which internally calls different stored procedures
based on the input values. And each child proc will call different procedures
internally.
When I copy the parent stored procedure content into the query analyzer and
set the variables values and execute the statist...more >>
Violation of PRIMARY KEY constraint - can SQL give row details? Posted by Jack Ukleja at 2/5/2006 2:55:31 PM Is there a way to get SQL to report the rows involved in the primary key
violation?
It would be extremely useful not to have to engineer a query to find what
caused the violation, when SQL must surely know what rows/keys were involved.
If SQL cannot do this, then why?
Thanks,
Jack...more >>
Number Generator? Posted by Harry Whitehouse at 2/5/2006 2:09:11 PM Newbie here!
I have a small .NET Web service running on a load balanced server array.
The service has a simple job -- dispense unique ascending numbers. Since
the request can come in though any of three servers, I figured I'd hook up
to a simple SQL table that they all would reference.
...more >>
Select statement based on Lenght of another field Posted by Stephen K. Miyasato at 2/5/2006 11:20:51 AM I'm trying to do a select statement based if there is any value in the memo
field(Varchar)
How does one do it
if (Select * from PatLabVal2 where len(Trim(memo)) > 1)
BEGIN
Select PatNo,sort, TestNameDisplay ,Result + ' '+ abn + '*' as TestName,
memo
END
ELSE
BEGIN
Select PatNo,so...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Please help! Insert a picture in an MS SQL Server table Posted by De kessé at 2/5/2006 10:49:37 AM Please help! Insert a picture in an MS SQL Server table
How can u insert a picture an an image field in SQL server table? Is it
possible from SQL server tools or other tools, programming?
...more >>
Bound control timing issues in Visual Basic Posted by oaksong NO[at]SPAM hotmail.com at 2/5/2006 9:41:18 AM It is just me or....
I have two appications in very different environments that have
suddenly shown very similar behavior, after a fashion.
One application is simple desktop. I've been working on the development
off and on for a number of months. It uses controls bound to an Access
database...more >>
Last time a table was used.. Posted by andystob at 2/5/2006 8:25:56 AM Is it possible to tell when a table has been last used?
...more >>
Insert a GUID Value Posted by Wayne Wengert at 2/5/2006 7:46:06 AM I want to insert a GUID value but I can't find the correct syntax to do
that. If I retrieve a GUID as follows:
==================
Dim user As MembershipUser = Membership.GetUser()
Dim guidMemberid As Guid = CType(user.ProviderUserKey, Guid)
=====================
and I then want to add a...more >>
use of inheritance Posted by ashokg at 2/5/2006 1:41:51 AM how can we use inhritance in creating tables.....i have an ERDiagram
with inherited tables but i don;t know how to implement
this.............
any link for any tutrial ???????
thanks
...more >>
UDT Index Posted by Leila at 2/5/2006 12:00:00 AM Hi,
How can I create index on X property of my Point UDT?
Thanks in advance,
Leila
...more >>
Help on DTS-Openquery timeout on linked server Posted by Roberto Rasto at 2/5/2006 12:00:00 AM I have:
- One linked server
- One DTS with an OpenQuery on linked server
I set the Connection Timeout and General Timeout on the DTS Connection to 0
I set the Command Timeout on DTS Step to 0
I set the Connection Timeout and Query Timeout on the Linked server to 0
Always I receive a provid...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |