Viewing 15 posts - 1,546 through 1,560 (of 3,221 total)
This might be what you are looking for:
CREATE TABLE #MyTable(A INT, B INT)
INSERT INTO #MyTable
SELECT 1,2 UNION ALL
SELECT 1,1 UNION ALL
SELECT 3,4
SELECT 'A = ' + CAST(A AS VARCHAR(2)), 'B='+...
January 4, 2011 at 8:02 am
Speaking of blogs and twitter, just happened to read Steve's (Jones) blog posting for January 3rd.
Congratulations for once again being selected as a MVP.
January 4, 2011 at 7:40 am
Nice question, got it right on a hunch .... but still learned something .. thanks
January 1, 2011 at 4:45 pm
If your developers are using temporary tables or want to create a new table you can use a SELECT INTO which will create the table with columns matching the data...
December 31, 2010 at 3:26 pm
GSquared (12/30/2010)
I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.
Congratulations
December 30, 2010 at 8:43 am
I have not tested the code T-SQL from this article:
http://www.sqlservercentral.com/scripts/Miscellaneous/31092/
From above link:
This is an update to sp_helpindex, it allows you to pass the table name and whether you want to...
December 28, 2010 at 9:58 am
This might be a start. It will list all indexes on all tables, plus a bit more about the index:
select g.name, d.name as 'IndexName', e.indid as 'IndexID', e.keyno...
December 28, 2010 at 9:01 am
Your welcome ... if you come up with what you think is a good solution please post it in the forum so others may benefit
Again - thank for you response...
December 27, 2010 at 3:02 pm
Look at thiis posting by Lynn Pettis, you will most likely find the T-SQL you require.
https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx
December 27, 2010 at 11:12 am
It seems to this person, that effort should be expended to learn why that particular piece of equipment is sending incorrect data for incorporation into the database, and then to...
December 26, 2010 at 4:25 pm
Steve a quote frequently attributed to Albert Einstein (although not found using a Google Search), but true nevertheless.
"When you stop learning you start dying"
- and one that I have...
December 26, 2010 at 9:32 am
My suggestion will be an outline of what could be done rather than specific T-SQL.
1. Create Table_2 without a primary key.
2. Start the T-SQL to perform the insert...
December 26, 2010 at 8:41 am
In the upper right hand corner of the forum page .. input "import from Excel". Click "Go". In the page that is shown click in the forum and...
December 25, 2010 at 7:05 am
It would be of assistance to those who wish to help if you can you post the table definition, and all indexes on that table, a limited amount of data...
December 24, 2010 at 1:21 pm
Tom.Thomson (12/23/2010)
Mauve (6/17/2008)
December 23, 2010 at 5:21 pm
Viewing 15 posts - 1,546 through 1,560 (of 3,221 total)