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.
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.
