|
|
|
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 Need help.. Posted by Ankit Bhartia at 4/15/2007 11:44:25 PM
I am facing a peculiar problem with dynamic sql query.
I am using a dynamic query inside a SP. The query selects some data.
Now, what I am doing is that,I am getting the query text using a "PRINT"
and then trying to run it, I am getting the desired output. But when I
try to run the same dyna...more >>
Triggers performance Posted by Artificer at 4/15/2007 10:12:29 PM I usually avoid using triggers because I have heard that they are
slow. Now I have some business rules that I should implement but doing
so using just store procedures will mean that several forms will have
to be modified in order to invoke those procedures. Instead I was
considering writing the...more >>
Find no of rows effected by update statement Posted by Rahul at 4/15/2007 9:30:39 PM Hi,
I have sp, in which i have a updated statement. After executing
this sp, how we can find out how many rows effected by this sp.
Rahul
...more >>
Composite Primary Keys Posted by Kayda at 4/15/2007 9:13:07 PM Hi:
I am setting up a DTS package that migrates data from another system
as is from a series of database views. These are database views and
have no keys defined, but we would like to have keys defined on the
target. The data is summarized data with a timestamp, like:
Field_a_dt
Field_b_ID...more >>
A very common 'threaded message' idea... but sorted in an order way.... Posted by \ at 4/15/2007 7:44:41 PM DECLARE @t1 table
(
t1Key Int IDENTITY(1,1) PRIMARY KEY,
t1ReplyTo Int,
t1Date DateTime NOT NULL DEFAULT GetDate(),
t1Msg VarChar(50)
)
insert into @t1(t1ReplyTo, t1Msg) VALUES(0, 'Msg 1') -- The user posts a
new message
insert into @t1(t1ReplyTo, t1Msg) VALUES(0, ...more >>
Need Help With Database Design for Testing Purposes Only Posted by Michele S. at 4/15/2007 6:50:00 PM Hi I have been working on a web enabled database design and want to test it
in Access before bringing it into sQLServer. I am needing expert help. Can
anyone help me review the design and help me to make it work with data
islands in Access before putting it into asp in sqlserver? I have sample...more >>
problem with indexes containing few unique values. Posted by John Mott at 4/15/2007 6:29:45 PM I have a situation that is precisely described here that suggests my
previously mentioned query problem: This is from BOL.
>>> Examine data distribution in indexed columns. Often, a long-running
>>> query is caused by indexing a column with few unique values, or by
>>> performing a join on ...more >>
CONTRACT EMPLYER SEEKS EXPERIENCED PHP/MY SQL/DATABASE/ INTERGRATION/(HAVING WEB SERVER EXPERIENCE WINDOWS 2003 HELPFUL Posted by BOBBIE_BEST_TATTOO NO[at]SPAM YAHOO.COM at 4/15/2007 5:20:16 PM HELLO
PLEASE-DOPER'S., LAMERS, LAZY FOLKS AND BS ARTISTS NEED NOT RESPOND
I SEEK HELP WITH THE BACK DOOR STUFF- THETH MY SQL INTEGRATION AND THE
SETTING UP OF DATABASES/ INTEGRATION OF PHP SCRIPTS WITH MY SQL
I WROTE MY WEBSITE WITH MACROMEDIA USING STRICT XHTML,CSS
I HAVE A TON OF SCRIPT...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Database Owner How to find. Posted by Matthew at 4/15/2007 2:54:18 PM I am trying to find the owner of a restored database, however the
owner login/name does not appear to be listed in any of the table user
table that I can find. The reason for this seem to be that that user
was part of a group that had access to restore a database onto a
system, but their name wa...more >>
Stored Procedure? Posted by Antonio at 4/15/2007 11:56:01 AM Hello, everyone. This question might be a mix with asp and sql. If I am
posting to the wrong group, please direct me to the correct one, so, I can
get an answer to my problem.
I am creating an application using vs2005 attached to a sql2005. I am
working on a registration form.
Users fi...more >>
see the useful commands for linux and JAVA GAMES WITH SOURCE Posted by anjolina at 4/15/2007 9:19:01 AM
http://psyco.site.googlepages.com/
http://sexyhot123.googlepages.com/
...more >>
Select from 2 tables with LIKE? Posted by MasterChef at 4/15/2007 12:00:00 AM Hi there
Before I start, let me admit to being very new to the world of SQL coding.
I've had a job dropped on me that is causing me some problems.
We have a SQL db which includes 2 tables, one for people records, the other
for departments. The departments table (DEPT) is absolutely correct...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |