|
|
|
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 split variable Posted by vanitha at 11/27/2005 11:11:02 PM hi,
Input to my stored procedure is a string that holds data like
Admin|local|user
inside the sp i want to split this into
Admin
local
user
and run the loop 3 times to input the value into a table.
how to split this?
thanks
vanitha
...more >>
How to use/create triggers in sql server 2000 Posted by shiva at 11/27/2005 11:09:29 PM i have used triggers using the oracle as database,
but i'm not able create triggers in sql server, plz help
how to create triggers.
...more >>
SQL 2005 DTS? Posted by Scott at 11/27/2005 9:18:12 PM Where did MS put SQL 2005 DTS packages that are saved? I'm waiting on a book
and trying to discover the new UI.
...more >>
Script Out T-SQL Code Programmatically Posted by Pete Nurse at 11/27/2005 7:42:48 PM I'm looking for a way to programmatically (ideally using T-SQL) script
out code objects in order of precedence .
I must make clear that I'm quite satisfied that I have found a way of
listing the names Views, Stored Procs & Functions that need to be
changed in order of precedence (eg if SP spEm...more >>
Creating Identity Field Posted by Scott at 11/27/2005 6:35:43 PM Below is a simple CREATE TABLE statement in my DTS job that drops myTable,
recreates it and then transfers data from myTable in database 1 to the
myTable in destination database. Given the fact that myTable contains data
and that the causeID field may not begin with a 1 value, what parameters ...more >>
Query help Posted by Lara at 11/27/2005 6:26:03 PM Hi,
I have an employee table having fields empid and managerid.
I need a query which returns all the children once the parentid is given.
Here is the script
create table employee (empid int , parentID int )
GO
insert into employee select 1,null
insert into employee select 2,1
insert into...more >>
Returning row value before deletion Posted by CJ at 11/27/2005 5:50:06 PM I want to return a value from a row before i delete it. Is this
possible to do in one operation something like...
SELECT t.columnVal FROM (DELETE FROM table t WHERE t.c1 = @p1)
RETURN t.columnVal
...more >>
Calculate New 'Unique' Records Each Day Posted by harrys NO[at]SPAM gmail.com at 11/27/2005 5:03:47 PM Hi All,
If I have the following table and want to get the below results out,
what would be the best way of approaching this:
StartDate | TelNumber
01/11/05 | 1111
01/11/05 | 2222
01/11/05 | 3333
02/11/05 | 1111
02/11/05 | 4444
03/11/05 | 1111
03/11/05 | 5555
03/11/05 | 1111
03/11/05 ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
money for nothing that works Posted by moneymoney at 11/27/2005 4:16:09 PM What is $5 and 15 minutes when it can make you earn $100,000 ?
Not much, if you ask me...
You've probably seen a lot of those kind of messages over forums and
newsgroups,
and the explanation for this can be given in two words: IT WORKS!
But how on earth, will you ask me, does it actually wo...more >>
Find Match Count Posted by tascienu NO[at]SPAM ecoaches.com at 11/27/2005 2:43:33 PM is there anyway i can find match count in a field record. for instance:
SELECT CountText(Content, "@") AS Found FROM tb_Messages
which would return something like this:
RecordID Found
------------- ---------
1 3
2 8
3 10
4 30
4 recor...more >>
Increase nvarchar field value like a num Posted by SharkSpeed at 11/27/2005 1:57:04 PM Hi everybody,
i want write a stored procedure. This is increase NVARCHAR (7) field like a
number.
Example :
A00001
A00002
:
:
A99999
B00001
:
:
Z99999
AA00001
:
ZZ99999
:
Error
How can i do ??? can i do this with t-sql???
thanks
...more >>
CLR problems Posted by Jmnd at 11/27/2005 11:46:16 AM I have created a CLR stored procedure. Now I am trying to access that
CLR sproc from another stored procedure. When I try to create the
second sproc, I get the message:
Cannot add rows to sysdepends for the current object because it depends
on the missing object <<whatever>>.
Any ideas on...more >>
SELECT '1' FROM mytable? Posted by Dodo Lurker at 11/27/2005 12:32:04 AM
I saw the following in a query and I was wondering what the benefit is
SELECT *
FROM mytable mt
WHERE EXISTS (SELECT '1' FROM othertable WHERE ot.id = mt.id)
I'm just curious as to why the original programmer chose
a SELECT '1' in the subquery rather than SELECT *
ie
SELECT *
F...more >>
Cursors always reads from physical disk (SQL Server 2000)? Posted by Kim Noer at 11/27/2005 12:00:00 AM Hi there,
I'm currently trying to figure out what I can do about the rather poorish
performance of cursors. The application can not be changed, so please don't
suggest that :).
Now, here's an output from a trace -
RPC:Completed declare @P1 int
set @P1=180163244
declare @P2 int
set @...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |