|
|
|
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 tables summary in QA Posted by Ragnar at 2/6/2005 11:25:01 PM Is there already a stored procedure which simply lists all user tables with
their corresponding number of entries? If not, did anybody write this by any
chance and could give me a pointer how to do that?
I would appreciate any help, thanks.
...more >>
newbie: to cursor or not to cursor Posted by Dan at 2/6/2005 6:28:34 PM Hi all, I'd like to ask a general question about some SQL query strategies.
Let's say I have 2 tables, e.g. an authors table (TAuthor), a works table
(TWork), and a work-authors table linking them (TWorkAuthor); each work may
have 1 or more authors:
TAuthor
authorID (PK)
firstName...more >>
Table-valued functions (syntax help) Posted by Matt Bolton at 2/6/2005 3:58:20 PM Converting Access queries to SQL views I've come across an issue in
referencing values calulated within the query. It seems that Access
allows this, but SQL doesn't. From BOL, I think I've established that
the best approach is table-valued UDFs, but I can't find any help in
BOL with the syntax t...more >>
Parameter Array with dynamic SQL Posted by sdev at 2/6/2005 2:19:03 PM I'm building an interface that will allow the user to dynamically make from
1-5 selections from a control. The @catList parameter is a comma-delimited
string of paramater values.
When I run it and make one selection from the control, it returns a row.
However, when I make more than one sele...more >>
roll call SQL Posted by dave9469 at 2/6/2005 1:51:23 PM
I'm having a little problem creating an SQL query to determine who i
signed in or out of an building access database, can anybody help?
Database structure
ID in/out time/date
6 0 6/2/05 10:05
5 1 6/2/05 09:00
4 0 6/2/05 16:50
4 1 6/2/05 ...more >>
Update databases Posted by simon at 2/6/2005 1:40:14 PM I have first database on one server and other database on second server.
Databases have the same structure.
The first database is for development. I change it every day and after new
functionality is done I would like to update the second - production
database with the changes in structure (n...more >>
Null value size Posted by Uhway at 2/6/2005 1:26:47 PM I am creating a table with following fields:
CREATE TABLE Employee (
EmployeeID bigint NOT NULL,
EmpName Varchar(50),
EmpAge int,
ImageSize int,
EmpImage image,
Comments varcha...more >>
Subscription Billing Database Design Posted by Arsen V. at 2/6/2005 1:11:16 PM Hello,
What is the proper way to implement subscription billing database?
Does "Order"/"OrderDetails" structure work for
monthly/yearly/bi-monthly/etc. subscription?
A subscriber could add new subscription options, removed options, etc.
Similar to how phone plans work.
What is the pr...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Placing a lock on a table Posted by Vlad at 2/6/2005 10:45:02 AM Is there any way to place a lock on a table for the duration of a certain
process (to ensure it does not get updated by anybody else), short of placing
the entire process in a single transaction? The process in question performes
data import and can run for up to 15 minutes.
Any comments ar...more >>
Help with SQL Query Posted by Vince at 2/6/2005 10:32:12 AM Hey all,
My abridged table structure is:
UNQ Number Student ID Date Attendance
1 1 1-feb-05 Y
2 2 2-feb-05 N
3 3 3-feb-05 Y
4 4 4-feb-05 ...more >>
**Dynamic SQL** Posted by maryam rezvani at 2/6/2005 7:52:36 AM Hi
1)I'm using SQl server 2000,how can I use dynamic sql to pass different
tables' name in a sql statement,I'd be thankful if you give an example.
2)I want to use the calculate field to join some columns instead of
concatination of them in different views,at first: is it a good idea?,
second:...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |