Viewing 15 posts - 616 through 630 (of 2,894 total)
March 12, 2013 at 9:00 am
Jeff Moden (3/12/2013)
demonfox (3/12/2013)
Select Into
the columns created would take the data type ,nullability etc. properties from the columns available in FROM clause.
so make sure you have SOFTWARE_NAME_ORIGINAL...
March 12, 2013 at 8:29 am
opc.three (3/12/2013)
Eugene Elutin (3/12/2013)SELECT INTO is "performance winner", why would creating table first be better?
Not always. You can achieve minimal logging with INSERT INTO...SELECT as well. Some people prefer to...
March 12, 2013 at 7:27 am
Curiosity?
Then this great story is for you: http://www.classicreader.com/book/899/1/
I've already mentioned it last day...
March 12, 2013 at 7:09 am
Tobar (3/12/2013)
March 12, 2013 at 6:22 am
you can use some sys tables (or any other available table) as kind of tally one:
INSERT YourTable (COMCOD, ACTCODE, ACTDESC)
SELECT TOP 10
...
March 12, 2013 at 4:51 am
Sergiy (3/11/2013)
It won't remove all the rows with CompanyID's from the final recordset, but will add 2 records to it"
YEAR...
March 12, 2013 at 3:34 am
demonfox (3/12/2013)
Or , even better , don't use select into ..Just create a table first and then Insert values into it ..
I find it better than Select into .
Could you...
March 12, 2013 at 3:30 am
I cannot see the picture here. (company policy stops downloads)
If you only collect total wait time, then it's really hard to say anything, as it just accumulates everything.
March 12, 2013 at 3:23 am
fmuzul (3/11/2013)
I completely disagree on your statement "there is no way to write good performing code for database without understanding how database (and its engine) works". I drive my car...
March 11, 2013 at 10:42 am
What exact counter are you calling "total wait"? If it is wait_time_ms then you should remember that it shows accumulated wait times since the server was restarted, therefore high...
March 11, 2013 at 10:21 am
Calendar weeks or working weeks?
What is your definition of a week? Is it Monday To Friday? Is it Monday to Sunday?
Is it Sunday to Saturday? Or may...
March 11, 2013 at 9:53 am
You don't need ROW_NUMBER here:
declare @table table (ID int, Name varchar(100))
insert @table select 1,null
insert @table select 2,null
insert @table select 3,'Bill'
insert @table select 4,null
insert @table select 5,null
insert @table select 6,null
insert...
March 11, 2013 at 9:48 am
David Mando (3/11/2013)
I need to write a query that returns a result set that is within the past 4 weeks and 3 business days. For example, the result set for...
March 11, 2013 at 9:29 am
...
But, the most important thing, is that making the change in a C++ procedure let me use the full power of the C++ language. Can't be beaten by any T-SQL,...
March 11, 2013 at 8:56 am
Viewing 15 posts - 616 through 630 (of 2,894 total)