| Groups | Blog | Home |
|
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 SQL Auto increment Posted by Maziar Aflatoun at 2/1/2004 10:26:41 PM Hi everyone,
Is there a way in SQL to define an Auto Increment column which is always in
order, even after removing elements from the middle.
For instance, currently if you define something as Auto Increment it will be
like
1,2,3,4,5,6,7,8,9,10 however, if you remove rows 4 and 9 then it w...more >>
readonly db, nolock Posted by sviau at 2/1/2004 8:59:20 PM is adding nolock in sql statement same as setting readonly for database? how
big of a performance gain is using with (nolock) on database that is only
for reading (updates except for data synch)
thanks
stephane
...more >>
paging and sorting Posted by sviau at 2/1/2004 8:57:42 PM whats the best method (performance wise) for paging and sorting using sql
serer 200?
where usingtemp tables. wondering if there is a more efficince, better
performing solution?
thanks
stephane
...more >>
stred procedure tuning: issues Posted by sviau at 2/1/2004 8:56:52 PM 1- this seems to work. what the catch? is there hidden overheard to
converting the string to int?
AND PTS.PropertyTypeID IN ('20')
AND ASL.AreaID IN ('6251','1107','6242','245')
AND (FG.FeatureGroupID = '1')
*** columns are data type integer.
2- how bad (performance wise) is it do to "...more >>
SQL Script to Refresh Views Posted by Scott Buerkley at 2/1/2004 8:32:47 PM My terminalogy might not be correct, but is there a way refresh all my views
after updating a table. I noticed that after adding a column to a table all
the veiw that are attached to the table have to be saved again. All my
views begin with a "V", so after running a SQL script to update my tabl...more >>
query about extracting values from a field in Stored Procedure. Posted by jungewum NO[at]SPAM yahoo.com.au at 2/1/2004 5:43:06 PM Hi,
I am writing a Stored Procedure. In the Stored Procedure, I have a
field called @product_list.
The value of the @product_list can be 'A1,A2,A3,A4,B3,B1'.
The separator is the comma (,) character.
The number of product_code (e.g. A1, B1) in the @product_list varies.
How do I extract ...more >>
TSQL Writting to Windows Event Log Posted by Denver at 2/1/2004 4:41:10 PM I have written a stored procedure, and each time it executes I would like to make an entry in the Windows Event Log. How can I do that?
Thanks....more >>
Automated Email including fields from a View Posted by David C at 2/1/2004 3:51:00 PM
Hi All,
I hope someone can help me here, I am trying to work out how to set up
an automated email that will be sent out every morning telling users
when the data transfer started and approx end time.
I have a View which has two fields [Start Time] and [Approx End Time]
I would like the ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Return gaps in a sequence Posted by DaveF at 2/1/2004 2:37:49 PM How can I find the gaps in a sequence of consecutive integers?
I have this:
1
2
4
6
7
8
10
The gaps are 3, 5, and 9.
I can get the consecutive records with this:
SELECT * FROM x x1 JOIN x x2 ON x1.c=x2.c-1
c c
----------- -----------
1 2
6 7
7...more >>
single selection parameter with multiple value Posted by kriste at 2/1/2004 1:33:27 PM Hi,=20
Can anyone enlighten me how to get the following correct?
@temp is dynamic string which it can be either a few param (eg, =
003,0045,005) or it can be a record set too (eg. SELECT upc from =
product_master WHERE name like 'A%')
declare @temp varchar(100)
select @temp =3D '''00000000...more >>
indexes Posted by william at 2/1/2004 12:45:02 PM what is the diff. between non unique clustered and unique
clusetred index, and which one should be created when.
Thanks a lot,
...more >>
id complex Posted by Sharon at 2/1/2004 12:37:11 PM hiall :)
i need an identity which is composed of two columns:
i want some id column on the table to reset every new year (yyyy)
which is also stored in a column in the same table.
is that possible?
10x lots.
sharon.
...more >>
thanks Posted by kevin at 2/1/2004 11:06:44 AM I am struggling to understand what does technically
checkpoint do?
pls help.
...more >>
file system and raw partition Posted by shandy at 2/1/2004 10:54:17 AM Does anybody know what is the diff. between
file system and raw partition.
why it is good idea to use file system for tempdb and raw
partition for other databases.
Thanks a lot.
...more >>
shutdown Posted by mp at 2/1/2004 10:52:26 AM what is the diff between
shutdown
and shutdown with no_wait architectically.
...more >>
This is what I have been asked in a recent interview. Posted by nb at 2/1/2004 10:51:14 AM How would u go for creating an index on a table having
100 million rows.
...more >>
asynchrous I/O Posted by amit at 2/1/2004 10:50:03 AM What is asynchrous I/O, and how I can configure it.
...more >>
largest table Posted by ravi at 2/1/2004 10:48:53 AM how to find largest table and its size.
Thanks...more >>
Any sybase guy here Posted by newwbee at 2/1/2004 10:47:37 AM Can any body tell me how to connect sybase with perl.
Thanks.
...more >>
direct and deferred update Posted by kunal at 2/1/2004 10:46:42 AM Can anybody pls tell me the diff. direct and deferred
update with a example.
Thanks a lot.
Regds,
satish
...more >>
heavily used tables and stored prpcedure Posted by ramni at 2/1/2004 10:45:40 AM How to find heavily used tables and stored prpcedure in
the system.
TIA
...more >>
Count Query Posted by Peter Neman at 2/1/2004 9:06:07 AM i have a simple table (table1) containing a number of Bank accounts details for our clients and a second table (table2) containg Client details. i am trying to get a count of the number of accounts over 1 that we have for each licence
Table 1
Licence ( varchar(6))
11111
22222
3...more >>
Simple? Select Statement... Posted by Bruce Duncan at 2/1/2004 8:58:26 AM I have 2 tables (products, proditems) and I would like to
return a table with all products with the smallest
price. The data looks like this (scaled down for ease)
products:
prodid, prodname, proddesc
proditem:
proditemid, prodid, supply, price
data examples:
products:
1, AD, descripti...more >>
Diagram not loaded by Scripting*** Posted by RM at 2/1/2004 8:06:08 AM Hi
I've got a script of my Db in SQL Server 2000,and
want to load it in elsewhere ,so there's a problem
not to move Diagram and some objects in my DB,why?
what's the solution?
any help would be greatly appreciated.
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/...more >>
XTAB - CROSSTAB UTILITY Posted by IanMGSmith at 2/1/2004 7:20:26 AM sp_XTAB produces crosstab views/output with minimum fuss.
No messing with code, just tell XTAB what you want to pivot.
Tested to 762 columns, XTAB can generate up to 63000 characters dynamic
sql and should handle most needs.
Regards,
Ian
----------- simple example
Use Northwind
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |