|
|
|
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 Cursor trouble 2005 Posted by michael vardinghus at 4/21/2007 10:10:22 PM Greetings All
I didnt work with 2005 much yet and I'm having trouble with a cursor script
used on 2000.
When this is exececuted it says "The cursor is READ ONLY" and i tried to
look through books online or internet but couldnt find an answer.
Anyone ?
USE [MIVARTEST_EDW]
GO
/**...more >>
Skip to end of SQL Script Posted by Michael Tissington at 4/21/2007 7:39:26 PM I have a large SQL script file with lots of batch blocks (ending in GO).
The first statement determine if the rest of the script should run using an
IF NOT EXIST
How do I skip to the end of the script file (or abort the script file) ?
...more >>
Obtain msinfo32 info + am I SAN attached ? Posted by Hassan at 4/21/2007 6:36:47 PM I like the first screen shot of the msinfo32.exe that talks about OS
version, physical memory,Model,etc. I dont need all the info that it
provides such as hardware resources,components...
I just need that first opening page contents
Also, how can I find out if my server is SAN attached or ...more >>
How to prepare a valid value for unique identifier column? Posted by Fendi Baba at 4/21/2007 8:04:23 AM I have a list of 5000 users that I will import into ASP.NET 2.0
membership provider tables. The table contains 2 fields/column which
are set to have unique identifier property. What is the best way of
generating this identifiers? Can it be self generated or prepared
based on some logics?
Than...more >>
2005: formating text in RAISERROR Posted by R.A.M. at 4/21/2007 7:31:22 AM Hello,
I am learning T-SQL and I would like to ask you such question (again,
because I had no reply and I haven't solved the problem). In the code below
I have error at RAISERROR because I don't know how to format message. In BOL
I have read that I should use C notation but my solution does...more >>
BCP question Posted by sharman at 4/21/2007 6:28:01 AM Hi,
I am moving some data from a table to a text file using BCP. The data is
created in a temporary table and is then moved to a global temporary table in
the order of ID (this is the identity field in the temporary table). However,
in the text file the last row gets inserted somewhere in t...more >>
A problem with indexing Posted by Hayatbakhsh at 4/21/2007 5:40:03 AM I have two databases. Both of them only have a similar table. The table has a
column of varchar type.
This column is indexed in first database but in second database no.
When i make a query like as this:
select column1 from table1
where column1='12345'
I saw an equal query time for both o...more >>
NOT EXISTS Posted by Mehdi at 4/21/2007 5:14:02 AM Hi Everybody
I have two set of recordset in MS SQL 2000, I want to have the subtract of
these two recordset like yhis
A={a,b,c,d}
B={c,e,f,g}
C=A-B
C={a,b,d}
I used the "NOT EXISTS" keyword but it doesn't work.
How can I do this?
Thanks
Mehdi...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Parameter Sniffing - Local Variables - OPTION (RECOMPILE) Posted by Leila at 4/21/2007 1:13:10 AM Hi,
I need clarification about the exact effect of OPTION (RECOMPILE) at the end
of query inside SP:
1) Does it help "Parameter Sniffing" happen even if we have used local
variables in query?
2) If "Yes", why WITH RECOMPILE in CREATE PROC statement doesn't have such
effect? (While it seems...more >>
(SQL Server 2005) newbie: join in DELETE Posted by R.A.M. at 4/21/2007 12:00:00 AM Hello,
I am learning T-SQL. In INSTEAD OF DELETE trigger I need to delete all
Positions (of Document) specified in deleted pseudo-table. The problem is
that primary key of Position consists of two columns: DocumentId and
PositionNumber. I have written command in a clumsy way:
DELETE FROM...more >>
Why doesn't this SQL query append a field to the table? Posted by Oscar at 4/21/2007 12:00:00 AM This is what I use to add the field adres to the existing table tblEmployee
in my VB-SQL Server application:
DB.Execute "IF NOT EXISTS(SELECT name FROM sysobjects WHERE name =
N'tblEmployee' AND type = 'U') ALTER TABLE tblEmployee ADD adres
nvarchar(25) Default 'newstreet'
This doesn't f...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |