|
|
|
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 RAND in a UDF Posted by Dan Slaby at 7/9/2005 8:32:41 PM Is there a way to use RAND() in a UDF, or is there alternative way to
generate a random number inside a UDF?
Dan
...more >>
Need DTS query to move table objects Posted by clintonG at 7/9/2005 7:57:47 PM I need a query to use with the DTS Import/Export Wizard that can be used to
export tables from one database which can then be imported into a different
database on the same server. The table data is not needed at this time. I
assume this is how to make a set of tables in a database that functi...more >>
print detail plus summary Posted by qjlee at 7/9/2005 7:19:04 PM Hi, I need to create a report on a list of transaction by items for each
employee and for each employee a total number transactions. e.g.
employee 1 transaction 1
employee 1 transaction 2
employee 1 transaction 3
total number of tranaction for employee 1 is 3
employee 2 tra...more >>
Wildcard Characters With PATINDEX! Posted by Arpan at 7/9/2005 6:08:05 PM A table named tblFood has a column named Description (varchar(50))
where one record under this column is, say, "tbuns" (without the
quotes). Now suppose the following query is executed in QA:
----------
SELECT *,PATINDEX('%bun%',Description) AS PIndex FROM tblFood
----------
The result of ...more >>
Advanced query to fetch gaps in date range? Posted by Mark Findlay at 7/9/2005 12:15:10 PM I am attempting to formulate a query that will tell me if there are any
single-day gaps in a series of records in a reservation table:
Here is the reservation table
-----------------------------
id int
startdate smalldatetime
enddate smalldatetime
guestid int
Assum...more >>
How do I get Identity value of a record a've just inserted? Posted by Bill nguyen at 7/9/2005 11:13:14 AM I'm working on a VB.NET app and need to obtain the system-generated record
identity value in table A and update table B using this value. The problem
is that I don't know the identity seed until the record is inserted into
table A.Any help is greatly appreciated.
Bill
----------------
T...more >>
PRINT messages inapproriately ending up in SqlException's message property Posted by Paul at 7/9/2005 10:49:06 AM I posted this question in the VB.Net newsgroup but got no response. This
question is related to both the DotNet Framework and SQL Server, I'm hoping
maybe someone can help me here.
Occasionally my users will try to perform an action and be presented with an
exception raised directly from SQL S...more >>
A parameter character similar to Access Posted by Nick Zdunic at 7/9/2005 7:58:01 AM I'm using .NET to access the database.
Using MS Access I can write a query such as 'Select Password From Users
Where UserID = ?'
I can populate a parameter collection and associate it with the query and it
will return the result.
Is this possible under SQL Server. If so what is the par...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
xml stored procedure Posted by chian at 7/9/2005 3:27:02 AM back end i have a table 'temp'. with identity field
in front end i am using datagrid some updation/insertion in my datagrid
my get dataset
ds.getChange()
update records with identity fiedl and
insert records with 'o' value
i wannt to send dataset to xml and then using
xml stored procedure i ...more >>
How many sub-selects and better options? Posted by J Rieggle at 7/9/2005 12:00:00 AM Hi.
I am working on an ecommerce website, and I recently implemented paging of
product items from a chosen category. The first approach was to keep the
SQL simple, so I link all products to a single category. However my client
is asking that it be possible to browse all items that exist w...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |