thirdworldgroup.org

weblog.kevinattard.com

Problem Solving: T-SQL: MDF files in use

http://weblog.kevinattard.com/2014/07/t-sql-mdf-files-in-use.html

ASPNET, SQL, XNA and More. Monday, July 7, 2014. T-SQL: MDF files in use. List the MDF file for every database in SQL Instance. Declare @files table ( db name sysname, physical name nvarchar(260) ) insert into @files exec sp MSforeachdb 'select "? Sysdatabase files' select db name, physical name from @files. Subscribe to: Post Comments (Atom). ASPNET: Disable Submit Form on Enter Key. How to get table row count for all tables in a database in T-SQL. ITextSharp: Disable PDF Printing.

weblog.kevinattard.com

Problem Solving: July 2014

http://weblog.kevinattard.com/2014_07_01_archive.html

ASPNET, SQL, XNA and More. Monday, July 7, 2014. T-SQL: MDF files in use. List the MDF file for every database in SQL Instance. Declare @files table ( db name sysname, physical name nvarchar(260) ) insert into @files exec sp MSforeachdb 'select "? Sysdatabase files' select db name, physical name from @files. Wednesday, July 2, 2014. T-SQL: Get a list of dates. Returns a list of dates from first of year to end of year. Subscribe to: Posts (Atom). ASPNET: Disable Submit Form on Enter Key.

weblog.kevinattard.com

Problem Solving: T-SQL: Remove duplicate rows

http://weblog.kevinattard.com/2014/05/t-sql-remove-duplicate-rows.html

ASPNET, SQL, XNA and More. Monday, May 5, 2014. T-SQL: Remove duplicate rows. Be extra careful before using DELETE ;) I usually do a select query instead of a delete to see what I am about to delete and when i'm certain that the query is correct, I change it to a delete. WITH cte AS ( SELECT[foo], [bar], row number() OVER(PARTITION BY foo, bar ORDER BY baz) AS [rn] FROM TABLE ) DELETE cte WHERE [rn] 1. June 14, 2016 at 3:13 AM. Subscribe to: Post Comments (Atom). ASPNET: Disable Submit Form on Enter Key.

weblog.kevinattard.com

Problem Solving: Validate Devexpress controls at client-side using javascript

http://weblog.kevinattard.com/2011/07/validate-devexpress-controls-at-client.html

ASPNET, SQL, XNA and More. Wednesday, July 6, 2011. Validate Devexpress controls at client-side using javascript. In order to validate devexpress controls in the page using javascript, use the following code:. ASPxClientEdit.ValidateGroup(null); or ASPxClientEdit.ValidateGroup('validationgroup');. This method returns true if all controls on the current page with the specified validationgroup pass validation and false if they don't. Or using a normal button. Check Online Documentation for more details.

knz.org.mt

Associate Members

http://knz.org.mt/index.php/youth-organisations/associate-members

National Youth Council (Malta). Subscribe to Mailing List. Raquo; Associate Members. Subscribe to Mailing List. Annual General Meeting 2014. The KNZ term 2012/2014 ended last Saturday. An AGM was held wher. Notice of Annual General Meeting. The KNZ Annual General Meeting will be held on 20th December 2014. National Youth Policy 2015-2020. Following our input into the National Youth Policy 2015 - 2020, t. Subsidised First Aid course. After the Success of the first course, KNŻ is collaborating with.

weblog.kevinattard.com

Problem Solving: Conditional Filtering: Using conditions in T-SQL WHERE clauses

http://weblog.kevinattard.com/2011/07/conditional-filtering-using-conditions.html

ASPNET, SQL, XNA and More. Monday, July 18, 2011. Conditional Filtering: Using conditions in T-SQL WHERE clauses. Many of us have some time or another come across the scenario where we would like to use if statements in a where clause. Here are 3 ways (that I know of) on how you can conditionally filter your where clause in T-SQL. Using multiple queries seperated by IF Clauses. Using the Case expression. Although not so straightforward, many developers opt to use this as it is much more readable and you ...

weblog.kevinattard.com

Problem Solving: T-SQL: Return nth delimited element from a string

http://weblog.kevinattard.com/2014/01/t-sql-return-nth-delimited-element-from.html

ASPNET, SQL, XNA and More. Friday, January 10, 2014. T-SQL: Return nth delimited element from a string. SELECT [dbo].fn String SplitByDelimiter ( '1ST 2ND 3RD 4TH' ,' ' ,3). Taken from the below url, just updated it to work on SQL2005. January 30, 2015 at 3:54 PM. There is a problem if there is an empty item in the list. Eg if item 5 is empty then item 6 is returned as item 5 etc. May 16, 2016 at 4:27 AM. Thanks for sharing this valuable information to our vision. June 14, 2016 at 3:12 AM. Using Resource...

weblog.kevinattard.com

Problem Solving: ASPxGridView: How To - Creating custom delete column with image at runtime

http://weblog.kevinattard.com/2011/07/aspxgridview-how-to-creating-custom.html

ASPNET, SQL, XNA and More. Thursday, July 28, 2011. ASPxGridView: How To - Creating custom delete column with image at runtime. It took me a while to find a way to a add a delete column with an embedded image so I thought it would be better in this blog for easy reference. Naturally, I wanted the confirm message before deleting as well. There seems to be 2 ways to do this:. Using the in-built Delete button: GridViewCommandColumn.DeleteButton. Or creating your own button from scratch. I will prefer to go ...

weblog.kevinattard.com

Problem Solving: Run Visual Studio as an Administrator in Windows 8

http://weblog.kevinattard.com/2013/11/run-visual-studio-as-administrator-in.html

ASPNET, SQL, XNA and More. Wednesday, November 27, 2013. Run Visual Studio as an Administrator in Windows 8. In Windows 8, you have to right-click. And select "Troubleshoot compatibility". Check "The program requires additional permissions". Click "Next", click "Test the program.". Wait for the program to launch. Select "Yes, save these settings for this program". Subscribe to: Post Comments (Atom). ASPNET: Disable Submit Form on Enter Key. How to get table row count for all tables in a database in T-SQL.