Most sql sever split name related news are at:
Recover the Database in SQL SERVER 10 Jan 2011 | 11:01 pm
1.create the Database with same Name,MDF Name,LDF Name. 2.Stop the Sql Server and then Replace the only new MDF file by old database (Corrupted database) MDF file and delete the LDF File of newly crea...
Reflect in the view after Edited or Newly Added column of a Table 10 Jan 2011 | 08:14 pm
After changed the name or add new column in the table, that changes would not reflect in the view if that field used in that view. For that you just run this system stored procedure with view name as ...
More sql sever split name related news:
Importing Large Files into MySQL using phpMyAdmin and CPanel scottelkin.com 8 Apr 2011 | 11:02 am
When I need to upload large .sql file (greater than 10 MB) into MySQL using phpMyAdmin, it frequently times out. The annoying the solution is to split the SQL file into several smaller file, but text...
Why I'm naming my Primary and Foreign keys the same! skyrocket.be 26 Mar 2012 | 11:00 am
I’ve recently changed the habit from naming my primary keys in an SQL table id to table_id just like I would name the key if it were a foreign key in another table. To me this has several advantages,...
