Viewing 15 posts - 1,546 through 1,560 (of 2,894 total)
Reading the following should help:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 17, 2012 at 10:28 am
And if you really insist, then the following example should give you an idea:
declare @n int
set @n = 5 -- I want my inserts start from 5
create table #t (id...
May 17, 2012 at 10:26 am
Don't use identity, use ROW_NUMBER() instead. You can start counting from any requested value...
May 17, 2012 at 10:19 am
In 2008 and after you can do:
insert into table1 (column1, column2,column3)
select column1,column2,n
from table2, (values (1),(2)) q(n)
May 17, 2012 at 10:14 am
...i have a code which was written in Vb.net for migration of data,so my client dont need that type of coding he wants in either...
May 17, 2012 at 8:27 am
CELKO (5/16/2012)
...The kids I tutor at a failing middle school ...
Poor kids... :w00t:
I only can guess which first book you make them to read, it must be ISO standards. Following...
May 17, 2012 at 6:59 am
nguyenhoang 18993 (5/17/2012)
No! if I action...
May 17, 2012 at 6:33 am
It can be done using "Quirky Update" method.
Read this great article by J. Moden: http://www.sqlservercentral.com/articles/T-SQL/68467/
May 16, 2012 at 1:40 am
Try type 200 instead of 201.
May 15, 2012 at 1:00 pm
have you changed the server code which talks to DB? Or, if you are using stored proc, have you change the parameter definition there?
May 15, 2012 at 11:01 am
...
The reason I say that Microsoft has a lot to answer for is this: The default-to-clustered "feature" achieves nothing much for wise developers but its unintended consequence is that too...
May 15, 2012 at 10:59 am
..., but this is forcing the sort.
Yeah, but it will only work for known values.
It's as well as doing it manually...
May 15, 2012 at 10:51 am
I love it!
declare @t table (id int identity(1,1), val varchar(200))
insert @t
select 'OO27k Informed Consent from Persons with Limited'
union select 'OO27l Expedited Review'
union select 'OO27m IRB...
May 15, 2012 at 10:42 am
Removing all digits may not help for cases like:
OO1a 2011 Zero
OO1a 2012 Non-Zero
as OP, if I understand correctly, would want to sort them as above, and stripping digits would sort...
May 15, 2012 at 10:30 am
...
Hope this makes sense....
...
It would make full sense, if you could show the exact expected result based on your sample. It would help to understand how you want your data...
May 15, 2012 at 10:17 am
Viewing 15 posts - 1,546 through 1,560 (of 2,894 total)