|
|
|
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 Saving Excel workbook in SQL server using c# Posted by Jitender Khanna at 10/9/2005 11:08:01 PM
Could anyone please help me out as to how we can save the excel workbook in
the database and
read it back.
I was able to convert the text files and image files into binary format and
save them to the
DB and finally able to retrive them back in the same format. But was unable
to do...more >>
S_procesure question Posted by naijacoder naijacoder at 10/9/2005 10:35:38 PM
I have a store procedure that adds to a table below but i would like it
to be able
to check if a record exists and if it exists return to user that the
User already exists
Which i added below but i get error:-
Cannot insert duplicate key in object 'Users'. The statement has been
terminated. ...more >>
Size of tables Posted by Venkat at 10/9/2005 10:26:35 PM Hi folks,
I am looking for a script which lists out the size of all the tables in
a database. Anybody has it?
Thanks in advance.
*** Sent via Developersdex http://www.developersdex.com ***...more >>
select dates problem 2 Posted by ven at 10/9/2005 10:21:36 PM thanks for help with last my question but i have another problem:
there are two tables: articles and orders
articles
id_a name
1 somethin1
2 somethin2
3 somethin3
4 somethin4
5 somethin5
orders
id_o id_a quantity1 quatity2 date
1 1 ...more >>
extended procedures and filegroups Posted by SureshBeniwal at 10/9/2005 9:04:30 PM Hi Group
How are you all doing?
let us have some good
ideas about extended
procedures and FileGroups
say we want to execute
everything from within sql
server
create a dir
delete a dir
create a file
delete a file
change dir
then some ideas on FileGroups
what they are
i had le...more >>
Contains(*) question Posted by Brian Kitt at 10/9/2005 7:17:01 PM When I do a full text index on 2 columns, then do a query like below, it
appears to only match rows where 1 column of the index satisfies the
criteria. I want the query to return all rows where a combination of the 2
columns satisfy the query. Do I have something set up wrong?
SELECT * FR...more >>
INSTEAD OF INSERT: cannot insert into trigger table Posted by P at 10/9/2005 5:50:14 PM I have attatched an INSTEAD OF INSERT trigger to table foo. The trigger is
coded to insert an exact copy of whats in the Insert table into foo, as well
as data into other tables. When fired the trigger successfully inserts data
into all tables _except_ foo. No errors are displayed. Per the BO...more >>
Help with stored proc, updates all rows! Posted by Richard at 10/9/2005 1:07:34 PM I am trying to split a full name ( like Tom J. Smith ) into first name
(fname), middle initial (MI), and lastname (lname ), could you take a look
at t-sql script and trouble shoot it? the problem of it now it doesn't
extract/ update last name properly (lastname Ringer is updated by mistake to
al...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Dumb trigger question Posted by Bob at 10/9/2005 10:32:28 AM Table with last UpdatedBy Column and LastUpdatedOn Column.
Want to create Insert and Update Triggers that would automatically write
Logged in User Name and System Date Time to each field.
I Think User is SUSER_SNAME function and System date Is GETDATE() but can't
figure out how to write th...more >>
List Unused Entries Posted by Wayne Wengert at 10/9/2005 6:30:23 AM I am using SQLServer 2000. I have one table (Members) which includes a
MemberID (int) field. I have another table (EventRegs) with a unique
EventID(int) and a foreign key for MemberID. A given MemberID can occur in
more than one row in the EventRegs table. I want to find out which MemberID
v...more >>
SQL Debugging work from VS2005 and not from VS2005 Posted by saarcarmi NO[at]SPAM gmail.com at 10/9/2005 2:10:56 AM Hi
I am trying to debug a stroed procedure on SQL Server 2005 (SP4) from
within Visual Studio running on WinXP SP2 workstation
If I use Visual Studio 2005 - everything works just fine.
But, if I use Visual Studio 2003 (on the same machine), when I click
the "Step Into Stored Procedure", t...more >>
select dates problem Posted by ven at 10/9/2005 12:00:00 AM hello i have a table with dates column, let's say:
id date
1 2005-10-09
2 2005-10-09
3 2005-10-10
4 2005-10-11
5 2005-10-11
i need to select all rows but only this with two last dates, so after select
i need somethin like this :
3 2005-10-10
4 2005-10-11
5 2005-10-11
How ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |