Articles - Database (SQL Server)

0

Like

This is a simple tip post. In this post I will show you a user defined function in SQL Server which parse the HTML and retrieve the Text only from it. ...Read more
Posted by: Manish Dubey
On 06 Aug 2013 | Views: 521 | Categories: Database (SQL Server)
0

Like

In SQL Server , Installation by default are case insensitive .This means that SQL Server ignores the case of the characters and treats the string 'Dot Net World' equal to the string 'dot net world'. SO how to perform case sensitive search in SQL? ...Read more
Posted by: Manish Dubey
On 03 May 2013 | Views: 357 | Categories: Tips & Tricks, Database (SQL Server)
0

Like

In this post, I have given a simple tip to check that primary is exists or not in table. ...Read more
Posted by: Manish Dubey
On 15 Apr 2013 | Views: 311 | Categories: Database (SQL Server)
0

Like

If you deleted all the records from the table and there is an Identity column in your table, You will see that when you insert a new record in your table then Identity column value starts from the last value of that column incremented by your step value. ...Read more
Posted by: Manish Dubey
On 10 Apr 2013 | Views: 296 | Categories: Database (SQL Server)
0

Like

In this post , I have explained that how you can insert values into Identity column in SQL Server. ...Read more
Posted by: Manish Dubey
On 05 Apr 2013 | Views: 328 | Categories: Database (SQL Server), ASP.NET
0

Like

IDENTITY column is an auto incrementing column provided by SQL Server. SQL Server will take care of incrementing this column automatically.This is much like an AutoNumber field in Microsoft Access or a sequence in Oracle. ...Read more
Posted by: Manish Dubey
On 01 Apr 2013 | Views: 333 | Categories: Database (SQL Server), ASP.NET
0

Like

In previous post SQL Server Database BackUp using C#, I explained how to take backup of SQL Server database using C#. Today I am going to describe how to restore SQL Server database backup programatically using C# and SQL Server Management Objects (SMO). ...Read more
Posted by: Manish Dubey
On 11 Mar 2013 | Views: 412 | Categories: Database (SQL Server), C#, ASP.NET
0

Like

There are various ways to take the SQL Server database backup. You can take the database backup using SQL Server backup wizard or using SQL Server BackUp Database statement. Here I am going to describe how to take the SQL Server database backup programatically using C# and SQL Server Management Objects (SMO). ...Read more
Posted by: Manish Dubey
On 08 Mar 2013 | Views: 452 | Categories: Database (SQL Server), C#, ASP.NET
0

Like

In this post , I have explained the SUBSTRING function of SQL Server of string functions category.
In my previous posts, I explained UPPER Function, STUFF Function, LEN Function, UNICODE Function, LEFT Function, CHARINDEX Function, CHAR Function, ASCII Function and some other articles related to SQL Server. ...Read more
Posted by: Manish Dubey
On 07 Mar 2013 | Views: 489 | Categories: Database (SQL Server)
0

Like

In this post , I have explained the UPPER function of SQL Server of string functions category. ...Read more
Posted by: Manish Dubey
On 05 Mar 2013 | Views: 335 | Categories: Database (SQL Server)
Page 1 of 9
Other lins

.Net Techies
Other lins