Viewing 15 posts - 1 through 15 (of 79 total)
Is there a way to get the complete hierarchy for a single Employee?
declare @EmployeeID int
select @EmployeeID = 12
SELECT EmployeeID, ManagerID, EmployeeName, EmployeeLevel = 1,
January 27, 2014 at 9:30 am
Consider using strongly typed xml and discarding fuzzy checking like datalength > 10
So you're SP's input parameter might be something like @parmeters XML (DOCUMENT dbo.MyXSD)
December 16, 2013 at 11:15 am
Note, this article is an update from a previous (pre-Sql Server 2005) version, here:
December 10, 2013 at 10:55 am
My comment "dynamic SQL isn't a good idea" is directly related to injection attacks, as you state.
What I like about this solution is that everything (client side with a strong...
December 10, 2013 at 10:54 am
You are to undertake this assignment individually, although you may discuss ideas with your fellow
students. However, the final submission must be your own work.
Wow, dude didn't even take time...
February 24, 2011 at 11:52 am
Here is a good post with several options:
Microsoft, open up this feature with some "normal" versions !
January 18, 2011 at 8:01 am
minto.antony (8/10/2010)try installing 'Microsoft Access Database Engine 2010 Redistributable' from http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=enand change your code to use Microsoft.ACE.OLEDB.12.0 instead of Microsoft.JET.OLEDB
and change your code to use Microsoft.ACE.OLEDB.12.0 instead of Microsoft.JET.OLEDB
I agree with "minto.antony", this is your best...
December 7, 2010 at 11:19 am
Mauve (10/28/2010)I see references to OPENXML in the postings.Don't use OPENXML! Use XQuery. See the following SQL ServerCentral article:http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/01/20/stop-using-openxml-please.aspx
Don't use OPENXML! Use XQuery. See the following SQL ServerCentral article:
True, but BE WEARY of element based xml depending on your Sql...
October 28, 2010 at 2:28 pm
Charles Wannall (10/22/2010)
October 22, 2010 at 10:41 am
I'm putting this in a separate post so it doesn't get buried.
For those of you who have conducted tests for various ways to do this......this article could be the reason...
October 22, 2010 at 3:56 am
//Difficult to create XML data at the application layer.//
I no longer use (strong) Datasets in my applications, EXCEPT I do use them as a way to create well formed xml.
October 22, 2010 at 3:50 am
Here is a "trick"
casting as a char(XX) where XX is your fixed-width
bcp "SELECT cast(LastName as char(50)) , cast(FirstName as char(50)) , cast(MiddleName as char(50)) , cast(Suffix as char(50)) FROM...
December 16, 2009 at 9:21 am
Thanks for the work........
I have static files where I (try) to keep the order of table creation....but this makes finding an orphan very quick work.
March 19, 2009 at 8:23 am
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.3054.00...
April 28, 2008 at 3:20 pm
REMOVED: (Another poster showed me how to post xml code)
April 28, 2008 at 11:47 am