Blogspot - programmingocean.blogspot.com - ProgrammingOcean
General Information:
Latest News:
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 ...
Recover the Database in SQL SERVER 10 Jan 2011 | 06: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 | 03: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 ...
How get the column names from a particular Table in Oracle 24 Jun 2010 | 07:20 pm
In Oracle you can retreive the field names as shown below,
How get the column names from a particular Table in Oracle 24 Jun 2010 | 03:20 pm
In Oracle you can retreive the field names as shown below,
How to get the position of a character from a word in SQL server. 20 Jun 2010 | 05:05 am
For this there is a function call CHARINDEX(). This is very similar to InStr function of VB.NET and IndexOf in Java. This function returns the position of the first occurrence of the first argument in...
Working with Cursors in SQL Server. 20 Jun 2010 | 05:01 am
Cursors are useful thing in SQL as it is enable you to work with a subset of data on a row-by-row basis. All cursor functions are non-deterministic because the results might not always be consistent. ...
Working with Stored Procedures 20 Jun 2010 | 04:50 am
Stored procedures are stored in SQL Server databases. The simplest implication of stored procedures is to save complicated queries to the database and call them by name, so that users won’t have to en...
How to get the position of a character from a word in SQL server. 20 Jun 2010 | 01:05 am
For this there is a function call CHARINDEX(). This is very similar to InStr function of VB.NET and IndexOf in Java. This function returns the position of the first occurrence of the first argument in...
