|
|
|
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 Is this possible in SQL Server Posted by Chris at 11/11/2006 11:07:01 PM Hi,
I have a table in which one colum I store domain names. How can I loop
through each domain name and perform a lookup like nslookup to get the ip
address of the domains?
Thanks...more >>
Best SQL design? Posted by Cipher at 11/11/2006 4:11:44 PM I'm currently building an ASP.Net application that contains three types of
users (Managers, Consultants and Admin) whose related data is stored in
three simple tables:
CREATE TABLE dbo.Managers(
ManagerID int IDENTITY (1, 1) NOT NULL,
ManagerNumber varchar (20) NULL,
FirstName va...more >>
Print Variables Posted by scott at 11/11/2006 3:57:03 PM In Q/A, I'm printing my variable as seen in CODE 1 below. If I try and add a
label in my PRINT statement as in CODE 2, I get the error as shown below.
How can I PRINT text and concantenate my variable for testing purposes
without getting the error?
CODE 1 ****
print @myVariable
...more >>
Newbie Design Question: Linking tables & data time dependence for ?2GB? database Posted by lukner NO[at]SPAM gmail.com at 11/11/2006 2:36:53 PM I have a design (shown below) in which I have things with time
dependent properties. The situation has been simplified for discussion
on a board like this and true identity of things hidden to keep the
things somewhat secret for now. I'm a little worried that once things
mulitply, database exe...more >>
how can I union subqueries without repeating subquery? Posted by Keith G Hicks at 11/11/2006 1:38:51 PM I'm need to UNION 3 queries as follows:
SELECT A.C1A., C2, A.C3 , B.C1 AS C4
FROM
(
SELECT C1, C2, C3 FROM TableA
) A
INNER JOIN TABLE TableB B ON A.ID = B.ID
UNION ALL
SELECT A.C1A., C2, A.C3 , C.C1 AS C4
FROM
(
SELECT C1, C2, C3 FROM TableA
) A
INNER JOIN TABLE TableC C ON A.ID = C....more >>
Extended Stored Procedure dll reloading Posted by Neil W. at 11/11/2006 11:28:05 AM Is an extended stored procedure DLL loaded one time for SQL or is it
reloaded for each connection? Thanks.
...more >>
Sql Server Linked Server to MySql db Posted by WCM at 11/11/2006 9:02:01 AM I need to get sql server to talk to a MySql db - is there a way to get
sp_AddLinkedServer to work with MySql? If anyone knows the steps to set this
up (right ODBC driver, etc), please let me know.
Thank you in advance for any help you can provide....more >>
Search by Date Column Posted by Mehdi at 11/11/2006 6:27:01 AM Hi
I have table with diferent columns i want to search and filter data by a
column of datetime DataType .
I use the syntax below but it doesn't work :
"SELECT * FROM Table1 WHERE DateCol= 2006-08-10 "
or
"SELECT * FROM Table1 WHERE DateCol< 2006-08-10 "
or
"SELECT * FROM Table1 WHERE Date...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
automating backup of SQL express 2005 Posted by Stephen K. Miyasato at 11/11/2006 1:48:30 AM Newbie question:
I'm new to SQL2005 and need to automate backup to disk on a daily bases with
incremental backups during the afternoon.
How is that done? Will scripts? OSQL?
Is there and agent present to automate the process?
Thanks for the help,
Stephen K. Miyasato
...more >>
temporary sql tables Posted by Milsnips at 11/11/2006 12:00:00 AM i have a stored procedure that creates a temporary table called, say
"#results". if 10 users hit this stored procedure at the same time, is it
possible that one user call can delete the temporary table before the
original table creator has completed their call, or do they wait until each
has...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |