|
|
|
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 User defined regex function coded in C# Posted by bdd at 3/31/2007 8:10:00 PM Trying to create a function to regex through a SqlString data type. I am
having problems casting or converting the sqlstring to a regex type. Here is
the code:
public static SqlString CF_SearchRegex(SqlString searchString)
{
string searchPattern = @"^(?<searchword>\w+)(?<there...more >>
Service Broker Question Posted by scott ocamb at 3/31/2007 6:28:16 PM I am building a service broker implementation.
Our website allows a user to select a bunch of emails to send. These emails
are send to a service broker queue.
The receive queue executes an extended stored procedure written in C#. This
proc performs mail merge work on the body and sends the e...more >>
How group a column to show side-by-side? Posted by Ronald S. Cook at 3/31/2007 3:30:10 PM This is nasty question but...
How can I take the following data from a table:
ID ItemNumber Type
1 9830302 CD
2 9830302 Cassette
And run a select statement to get me:
ID ItemNumber Type
1 9830302 CD/Cassette
Thanks,
Ron
...more >>
SQL 2005 Query Question Posted by Spanky deMonkey at 3/31/2007 2:57:31 PM In the Query Analyzer, when I use "AdventureWorks"
I issued the query: Select lastname from person.contact
The message states: Invalid object name 'Person.contact'
When I issue the Query: Select LastName from Person.Contact
I get results.
Why is the query CASE sensitive? I looked ...more >>
Intelligent Product Search Query Posted by Dan at 3/31/2007 2:38:04 PM I need to create a better search on an ecommerce web site. Using the
Northwind database as an example, here is what I need to be able to do.
In Northwind.Categories.CategoryName, there is a value of "Dairy Products"
In Northwind.Products.ProductNames there are 2 products with values of
"Qu...more >>
Separating words from non-space string Posted by Janusz at 3/31/2007 11:38:16 AM Guys,
I am trying to figure out how to program an efficient sql query for
this scenario.
Let's say I have a table with strings like that: thisismyexample ,
thisismyanotherexample, lastexample
Then I have a table with dictionary words:
this,is,my,example,another,last,..... (all the engl...more >>
Why this CTE error? What am I doing wrong? Posted by cmay at 3/31/2007 10:07:32 AM I can't get any CTE to work, even something this simple:
WITH ASDF AS
(
SELECT 123 as A
)
Every CTE I try to create gives me the same error:
Incorrect syntax near ')'
for the final ")"
Can anyone make a suggestion?
...more >>
Query help Posted by David Trasbo at 3/31/2007 4:26:32 AM I am still working on my instant messenger, but it's also going to
include an RSS reader.
The system is, that you need to subscripe the RSS feeds you want. If
you add a new RSS feed to subscripe, it will be available for
everybody in the database.
I have the table 'RssFeedSubscriptions' whe...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL 2005 Event Notification Posted by LeifHar NO[at]SPAM gmail.com at 3/31/2007 3:01:44 AM Hello,
I want to log "DISABLE TRIGGER" statement. But as I understand and
have read, this is not possible with event notification or DDL
triggers. I believe I understand why not DDL trigger, but why not
event notification?
Is the only alternative to setup a trace that runs 24x7?
Any sugg...more >>
How have strings within a string variable? Posted by Ronald S. Cook at 3/31/2007 12:00:00 AM This works fine:
SELECT *
FROM MyTable
WHERE Code IN ('X', 'Y', 'Z')
But I want those values in a variable. If I do the below, it doesn't work
because the X, Y, and Z aren't their own string:
DECLARE @MyString varchar(50)
SET @MyString = 'X, Y, Z'
SELECT *
FROM MyTable
WHERE Code...more >>
SQL Server and XML Posted by SqlBeginner at 3/31/2007 12:00:00 AM Hi All,
I have an XML file for which I need to pass data from SQL Server. Sample
xml file is shown below
<Root>
<One id="a">
<name>xyz</name>
<url>Content comes from sql</url>
<data>Content comes from sql</data>
</One>
<One id="b">
<name>xaz</name>
<url>Content comes...more >>
dataadapter and dataset Posted by yshie via SQLMonster.com at 3/31/2007 12:00:00 AM visual studio 2005
ms sql server
how will i know if i need to use a dataadapter and dataset? do i need to use
them everytime i have sqlcommand?
because i will create a data binding code and i don't know if i need to
create dataadapter and dataset. i have 4 textboxes and i will fill only the...more >>
How to retrieve column value into a variable? Posted by ~~~ .NET Ed ~~~ at 3/31/2007 12:00:00 AM When I was into Oracle I used to be able to do things like "SELECT column
INTO varname" and then use that variable into subsequent operations. I need
to do something like that in SQL Server 2005 (Express).
I have a table A with a PK and and several other columns. I am interested in
a non-PK...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |