|
|
|
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 August 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 SQL Management Studio - Create Stored Procedure - Frustrated Posted by RosH at 4/7/2007 11:35:11 PM Hi,
I may sound a foolish newbie, but I am totally frustrated trying to
create a new Stored procedure in SQL server Management studio. I made
all the database tables and created a diagram and the relationships
and even tried out VBA connectivity which is working fine. I tried
creating a sto...more >>
How can I optimize these subsequent basic SQL queries into one query? Posted by Oscar at 4/7/2007 11:22:46 PM I want to optimize a subroutine which performs many subsequently queries and
shows a bad performance at the moment.
I've simplified the real queries in the following example :
"SELECT ID_emp FROM tblEmployee WHERE male=0"
(this results into a recordset rstA)
IF NOT rstA.eof then
DO...more >>
Connecting to SQL2k5 from IIS7 (ASP.Net) Posted by Steve Bottoms at 4/7/2007 9:19:58 PM Hi, all! Running ASP.Net 2.0 under IIS7 on Vista Business, connecting
to remote (same subnet, different box) SQL 2k5 Standard installation.
Well, I'm attempting to connect with a simple open & close to a
database on a remote SQL 2k5 box, and getting this error:
"When connecting to SQL Serv...more >>
Create a Trigger Posted by qjlee at 4/7/2007 6:30:03 PM I have an table called VENDOR. There are three fields, vendorid, vedorname,
clientname. I need to create a trigger to populate the vendorid when a
vendornamen and clientname combination is entered. e.g. populate vendorid
as 0001 when vendname A and clientname B is entered, populate vendori...more >>
Comparing VARBINARY data with Select statement in C# Posted by LEM at 4/7/2007 6:07:20 PM Hi,
My apologies if this is not the right forum where to ask this.
I have a table with one VARBINARY column (let's call this column 'A')
In my program, in C#, I have a buffer of binary data like this:
byte[] MyData;
I would like to write a select statement that returns all the rows
w...more >>
Automatically adding time to entry Posted by Mark (Websrfr) at 4/7/2007 5:46:03 PM Can someone tell me how to have a date time field in a table and have SQL
automatically put the date and time in the filed when a new column is created?
Thanks, Websrfr...more >>
The most simple question ever Posted by E-ZU at 4/7/2007 5:01:05 PM I know absolutaley nothing of SQL scripting and need what is probably
the most simple query ever.
I have a database called CODE and in that is a table called
Connections and in that table a column called Category_Id
I need to be able to search for all the records with a value of 61 in
the C...more >>
If User.xml file has more characters than 4000, what should i do? Posted by Orgil at 4/7/2007 4:31:03 AM Hi all, I need a help here. If User.xml file has more characters than
4000, what should i do? The table User has a ntext field. One cell of
this field can have thousands of characters. If there is a
possibility, tell me please!!!
-------------------------------------------- example code here
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Outlook 2003 VBA <--> SQL server 2005 Integration Posted by RosH at 4/7/2007 1:39:30 AM I was able to build the following code with the help of some help
topics from Microsoft site for Outlook programming. But unfortunately
errors keep on following me. I have included the code and the error
below. I would appreciate you to comment on it.
My intention is to create a macro in out...more >>
Login Information Posted by Amit Khurana at 4/7/2007 1:29:11 AM is there any provision to find out which login/user has updated/deleted/inserted data in particular table..
is there any system table/ or log available??
thx in adv..
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com...more >>
Alias to local server Posted by Michel Posseth [MCP] at 4/7/2007 12:00:00 AM Hello
maybe someone has a solution for this
For developing purposes i need to setup a local SQL 2005 server with a
aliass but i can`t get it to work
The scenario is the following
We have developed a nearly finished project with lots of components who all
target database server P...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |