| HOME > RSS Feeds > - Latest Tutorial Listings For Miscellaneous | ||
| Add To: | 
|
 |
Learn how to delete duplicate rows without any primary key in ms sql server database. This is the most common question asked in interview.
How to check if table exists or not in ms sql server database
In this programming tutorial we will learn how to check if table exists or not in ms sql server database. Doing so is quite easy in ms sql server. sp_help command is use for this purpose. So let's hav...
Query to get the all column names of a given table in ms sql server
In this programming tutorial you will learn the query to get the all column names of a given table in ms sql server. Its quite easy. Lets have a look over the query.
MS SQL Server Optimization Techniques for ASP.Net Programmers
In this programming tutorial you will learn the MS SQL Server optimization techniques for asp.net programmers. MS SQL Server is a widely used database with websites developed in asp.net technology.
How to get the all user created tables saved in ms sql server database
In this programming tutorial you will learn how to get the all user created tables saved in ms sql server database. It is quite easy and simple. Only you have to do is to write and execute the followi...
Query to get the length of string in ms sql server
In this programming tutorial you will learn the query that will get the length of string in ms sql server. It is quite easy in ms sql server. Let's have a look over it.
Difference between varchar and nvarchar
The wide range of data types in MS SQL Server can sometimes throw people through a loop, especially when the data types look highly interchangeable. VARCHAR and NVARCHAR seem to be highly interchangea...
Get the size of SQL Server Database and Tables
n this tutorial you will learn how to get the size of SQL Server database and its tables. It is a good approach to check the size of your database routine wise and then performed appropriate action wi...
learn how to get random records in sql server
In this tutorial you will learn how to get random records in sql server. Sometimes you may need to get random records from table in ms sql server database. To do this in ms sql server is quiet easy. L...
How to get all store procedures saved in ms sql server database
In this tutorial you will learn how to get all store procedures saved in ms sql server database. Its quiet easy and simple. Just you have to do is to write and execute the following query.