|
|
|
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 Any good T-SQL quick reference recommended? Posted by A.Fish at 4/24/2004 9:11:02 PM Hi
Are there any document talking about SELECT, WHERE, JOIN etc with straight forward samples? SQL books online is good but too heavy for fast browse..
Any suggestion is appreciated
Fish....more >>
=?ISO-8859-1?Q?What_wrong_in_my_stored_proc=3F__Can=B4t_be_possible....?= Posted by mark NO[at]SPAM mepos.de at 4/24/2004 5:13:35 PM Hi All,
I have some for me not understandable Error :-(
Using MS SQL Server 7.0. What´s that for a bullshit, what´s wrong?
Beetween msg 2 and 3 is a missing ")", but where?
Here´s the Code:
DECLARE crsPABM SCROLL CURSOR
FOR
SELECT verw_ADM, verw_Wand, (verw_A...more >>
databases within registration Posted by gdp at 4/24/2004 11:03:43 AM Hi...thanks to the answers to my previous question...the suggestions worked
just as i needed....if i have a particular instance of sql server running on
a machine is it possible to get a list of all the individual databases it
contains.
thanks again for the prompt and knowledgable responses
...more >>
DAY OF DATE Posted by ROCK at 4/24/2004 10:51:02 AM I WANT DATE FORMAT LIKE THIS 'MM/DDD/YYYY
I NEED LIKE THIS 04/SAT/200
PLEASE HELP M
THANKS...more >>
queries to get table list Posted by gdp at 4/24/2004 8:56:31 AM hi...can a query be written that returns a list of all the tables within a
database and that also allows you to find out what columns the tables
contain.
thanks
...more >>
error to delete a record from the table Posted by Joe at 4/24/2004 8:51:03 AM I tried to delete a record from the table
delete from student where id='448
But it has the following error
Server: Msg 547, Level 16, State 1, Line
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK__STUD_PRER__Condi__1C1D2798'. The conflict occurred in database 'university', t...more >>
Getting the Number from the next automatic increment Posted by Steve NO[at]SPAM BT at 4/24/2004 8:21:18 AM Hi All
I have a Table which generats a automatic number when i add a new record
how do i get that number that has been been added
e.g. My table is
CREATE TABLE [dbo].[Call_Log] (
[Ref] SMALLINT NOT NULL IDENTITY(1,1),
[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI...more >>
How to update datetime when new record inserted Posted by Jane at 4/24/2004 8:02:08 AM Hello all,
in My table one datetime fields is there
after inserting a record (with datetime field is null) in
table, I am want to fire a trigger to update the datetime
field How to do this
Note: I need trigger to update field
any help or site thx lot...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Any body have time help me Posted by kamal at 4/24/2004 7:50:08 AM Hai,
I am kamal
Any body have time read this
I need stored procedure or any language code Or URL to do
this operations
For me its very very very difficult to get. I already
wasted 2 weeks.
I am kamal, I doing one Multi Level Marketing Project.
I am trying to place the members i...more >>
Views Posted by Konstantinos Michas at 4/24/2004 5:04:24 AM Hello Experts,
Does Views (structure) stored in some other system tables
besides syscomments?
Thanks in advance....more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |