|
|
|
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 View in SQL Posted by Granville at 11/14/2004 11:58:02 PM Good day
I have a table in SQL with the following columsn in it
Column A Clumn B
6000 4
6001 5
6002 4
6003 8
6004 6
7000 8
7001 7
7009 8
701...more >>
Delete Unmatched Records Posted by Rick at 11/14/2004 10:03:54 PM I have tow tables they are an invoice together there is a header and a
detail table I Have many more invoices in the detail table than I do in the
header. I want to delete the record in the detail that do not match any
invoice in the header. InvoiceID is the related field I have been banging m...more >>
Control jobs from a remote server Posted by Andy Phillips at 11/14/2004 8:39:34 PM I am able to disable a job by using the follwing command:
msdb..sp_update_job @job_name = 'Copy Logs',@enabled =0
How can I disable a job running on a remote server from my local server.
I need to do this because the remote server can go out of sync from my
process and I want to place jobs on...more >>
Leftmost column in an index Posted by DWalker at 11/14/2004 7:51:30 PM When you read about the fields in a query using the "leftmost column in an
index" for better performance, then I hope that -- if I have a table called
TableX with columns ColA and ColB, and I create the index as such:
Create Index Ix_Blah on TableX(ColB,ColA)
then ColB *is* the leftmost co...more >>
SQL statement to get all tables in the database Posted by Matt at 11/14/2004 7:11:48 PM I know we can see all tables in Enterprise Manager or Query
Analyzer. But is there any SQL statements to get all tables in the database?
Please advise. Thanks!!
...more >>
setting Startup service account of a machine via SQL-DMO Posted by Norbert Kraft at 11/14/2004 5:25:56 PM I would like to change the startup service account of a couple of msde
Machines to a domain account instead of system account using sql-dmo.
As i've been told EM underlying dlls are DMO and EM does the job, it
should be faily easy to accomplish this in SQL-DMO. However, I did not
find any o...more >>
Inexplicable View problem - help!!! Posted by Kath at 11/14/2004 4:12:23 PM Hi everyone,
I'm having problems with a view *losing* columns. Has anyone had this
before?
To give you an example of what I'm working with I have put the concept
below:
I have some data held in a 30-column wide table; 24 of these columns include
1 column for each monthyear.
eg column...more >>
Alter char column to computed column Posted by Jane at 11/14/2004 3:09:07 PM Hi There,
I have a table with a char(1) column, I need to change it to a computed
column, but I can't do it with the following statement:
ALTER TABLE memtrans ALTER COLUMN SHORT_REC_TYPE as LEFT(REC_TYPE,1)
When I ran it, I got error message: "Incorrect syntax near the keyword 'as'."
S...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
TSQL Question. URGENT Help. Exists and Not Exists Question Posted by Mark at 11/14/2004 10:04:09 AM I have table Issuer as indicated below with two columns. issr_num (Issuer
Number) can have multiple frame of references (C or P). My goal is to bring
all issr_num but if the same issur_num has a reference of C and P both then I
only want to see the one with C and I want to ignore the one with ...more >>
scheduling dos batch file as job Posted by hyeebah jones at 11/14/2004 9:31:42 AM Hello,
In addition to the automation of standard database jobs
it would be nice to also coordinate the running of a small
simple DOS batch file from the SQL job queue.
Can someone advise how to do this? For example, say
I have a batch file called C:\batch_file.bat and want to run
this tri...more >>
inserting data in mdf table in asp.net2 using SQL server2005 express Posted by Pratik Gupte at 11/14/2004 9:10:05 AM I have created a database in .mdf format, but I am unable to insert data
into its tables. Can anybody help how to insert data using ASP.Net 2.0 using
SQL Server 2005 Express edition in windows integrated security mode.
thx
...more >>
sav image field to file Posted by Remon Bekker at 11/14/2004 4:54:01 AM Hi all,
I have the following problem: An external program is filling an SQL table
including an image field (which is a PDF) which I need as a file. Is it
possible to write a trigger on this table to save the image field to a file ?
Can you give an example for this code ?
Thanks !...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |