Coder Mind

2017-07-28T14:18:00.000+06:00

The Logical Name field in question, is in:Database properties->Files USE [HEALTHCARENEW]; -- Changing Physical names and paths -- Replace all NewMyDB with the new name you want to set for the DB -- Replace 'C:\...\NewMyDB.mdf' with full path of new DB file to be used ALTER DATABASE HEALTHCARENEW MODIFY FILE (NAME = 'HEALTHCARE', FILENAME = 'C:\SQL Database\CSHEALTHCARE.mdf'); -- Replace 'C:\

Set Background Image to UILabel Properly in iOS

2015-09-29T13:07:00.003+06:00

How you will set a background image to UILabel. I searching different site and stackoverflow following code is solve my purpose. This code help me set a image and to fit / shrink according to size of UILabel. UIImage *img = [UIImage imageNamed:@"yourimage.png"]; CGSize imgSize = self.YourLabelName.frame.size;

iPhone UITextField - Change placeholder text color

2015-09-11T10:09:00.000+06:00

We can Change the Placeholder textcolor to any color which you want by using the below code. UIColor *color = [UIColor whiteColor]; self.txtUserName.attributedPlaceholder = [[NSAttributedString alloc] initWithString:@"Username" attributes:@{NSForegroundColorAttributeName: color}];

How to make completely transparent navigation bar in iOS 7 + iOS 8 programticaly

2015-06-16T16:30:00.000+06:00

I found the solution from Stack Overflow and other site . Solution 01 Objective c self.navigationController.navigationBar setBackgroundImage:[UIImage new] forBarMetrics:UIBarMetricsDefault]; self.navigationController.navigationBar.shadowImage = [UIImage new]; self.navigationController.navigationBar.translucent = YES;

Generating a random password in php

2013-11-13T12:26:00.004+06:00

pre.CICodeFormatter{ font-family:arial; font-size:12px; border:1px dashed #CCCCCC; width:99%; height:auto; overflow:auto; background:#f0f0f0; line-height:20px; background-image:URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr5IS806R_S6p7jJsoOOzdCvsGswHYerqCWkHL283ryqJ3dEHgHWlh5gTTs5uycRHaJzeS7Dvjq6KY5huQdwULyeFFMubBW0Ewk5UbBCQ7hf09mzfIREcgQ8FeoY9Qi8Hq92NrVrUWp0zG/s320/

Rename a Database and its MDF and LDF files in SQL Server

2013-07-15T01:11:00.001+06:00

Restore Sql server Database from .bak file using (T-Sql)

2013-05-30T14:54:00.000+06:00

.style1 { color: #0000CC; font-weight: bold; } .style2 { color: #0000FF; font-weight: bold; } Database has full backup .bak file. It can be restored using following two steps. Step 1: Retrive the Logical file name of the database from backup. RESTORE FILELISTONLY FROM DISK = 'D:\BaakUpFile.bak' GO Step 2: If you want replase this existing Database RESTORE

Finding Duplicates rows with SQL Server

2012-10-05T01:05:00.000+06:00

This article shows how to find duplicated rows in a database table. This is a very common beginner question. Here is a useful sql query to help identify duplicate values in a column and return a count of the number of times that value appears.Following query demonstrates usage of GROUP BY, HAVING in one query and returns the results with duplicate column .