Viewing 15 posts - 3,106 through 3,120 (of 3,221 total)
I can not get the results in one row as you have shown in a simplified manner.
From BOL:
The result sets combined using UNION must all have the same structure.
They...
May 9, 2008 at 10:33 am
/*Requirements BEFORE executing SQL code:
1. Excel workbook must exist on the server in this case C:\TipsNTrick\Tables.xls
2. Excel sheet column headings must be identical for example...
May 7, 2008 at 12:18 pm
Refer to books on line (BOL) sp_who - specifically the entries for columns "blk" and "cmd'
Blk:
The system process ID for the blocking process,...
May 7, 2008 at 7:59 am
Using SSMS
Expand the database which contains the 2 tables
Right click on the table name
In the drop down menu left click on "Design"
In the resulting pane click row with "StyleId"...
May 5, 2008 at 11:13 am
Open SSMS
Expand the list of databases
Right click on a database name
Left click on "Properties" in the menu which appears
In the next window (left pane titled "Select a page")
Click...
May 5, 2008 at 10:10 am
aljtdj (5/5/2008)
May 5, 2008 at 9:31 am
Steve Jones - Editor (5/5/2008)
That is not a compilation error. It's a run-time error when a conversion occurs. There are very few compilation errors, mostly syntax issues.
In my humble opinion...
May 5, 2008 at 9:13 am
AS previously stated:
dunnjoe (5/5/2008)
May 5, 2008 at 8:56 am
Grant Fritchey (5/29/2007)
May 1, 2008 at 8:19 am
Thank you one and all for the comments. Since the QOD is or should be designed to make us think and learn, I believe that all the comments...
April 29, 2008 at 6:44 pm
Another option -- You can create a stored procedure incorporating two input parameters to execute something similiar to the following
DECLARE @news INT ...
April 28, 2008 at 12:08 pm
SUJITH KUMAR (4/23/2008)
If a new number is generated insertion have no problem. If number generated is an existing one Sql Server not allowing to insert because of duplicate key....
April 25, 2008 at 8:18 am
Dots or no dots from:
http://msdn2.microsoft.com/en-us/library/aa225964(SQL.80).aspx
The following text:
Note During a full database or differential backup, Microsoft® SQL Server™
backs up enough of the transaction log to produce a consistent...
April 21, 2008 at 7:28 am
arsrini (4/17/2008)
We have three production servers running SQL 7.0 with hundreds of our own Stored Procedures. We want to upgrade these servers to SQL 2000 or SQL 2005. Are there...
April 18, 2008 at 9:50 am
Goodguy your answer "Thanks, I think I figured out the solution I need."
Heck we all can learn from these posts how about telling us what / why / how you...
April 17, 2008 at 10:33 am
Viewing 15 posts - 3,106 through 3,120 (of 3,221 total)