By tag: Vijaya
0
kicks
String Functions in SQL Server Part 1
In this article I would like to give you an overview on various string functions that are available in SQL Server and are widley used at work.
In this IT world 50% of the databases consist of CHAR, NCHAR, VARCHAR, and NVARCHAR as data types to store the values. When you are joining the tables bas...
0
kicks
Useful Stored procedures in SQL Server Part 1
There are several predefined stored procedures are available in SQL Server which we are using in our day-to-day life to resolve some of the issues like below.
1) I want to see the all columns of the tables.
2) I want to see who are all logged into Database.
3) I want to see the Constraint infor...
0
kicks
60 Seconds with Pinal Dave
60 seconds with Pinal Dave:
MVP award played an important role in helping me chase my passion to make a difference.
VJ caught up with Pinal Dave, MVP in SQL Server, to get his view on the Microsoft Most Valuable Professional Program(MVP).
0
kicks
SQL Server Beginer Articles Part 1
This link contains list of SQL Server Beginer Articles to start with. Starting from creating a table to Bulk Insert to copy data from text file.
0
kicks
MERGE in SQL Server 2005
In my previous section I explained about OUTPUT feature in SQL Server. In this section I will go one step ahead and will tell you, how you can use this feature to implement MERGE in SQL Server 2005.
0
kicks
Create Table Using Select in Sql Server
In this section i would like to give you a small tip about creating a table in SQL Server with out using CREATE TABLE statement.
0
kicks
OUTPUT in SQL Server 2005
In this session, I would like to talk about one very interesting feature of SQL Server 2005. Before I say anything about this feature let me ask you some simple question.
0
kicks
Load text or csv file data into SQL Server
Today I will talk about loading a CSV or comma or txt file into SQL Server using BULK INSERT. Using BULK INSERT, in few steps you can load the file into database.
0
kicks
Drop table in SQL Server
One of common query that we execute on day-to-day to basis is Dropping and re-creating a table when you are as beginner.
0
kicks
Computed Columns in SQL Server
Today I will talk about one of the very interesting feature called "Computed Columns" in SQL Server. This is a column in table but you will not assign any specific data type to this as you do it in regular CREATE TABLE statement.
0
kicks
Foreign Key and Primary Key in SQL Server
Check out the below script to find out the Foreign Key information like Name of the Foreign Key , Name of the Table which has foreign Key and List of columns in that Foreign Key definition. In addition to this the foreign key which is referencing the Primary Key and Primary key table or Parent table...
0
kicks
List all the Foreign Keys in a SQL Server
The below script will give you list of Foreign Keys in a database and columns which are part of the Foreign key definition.
0
kicks
XML Schema Definition Tool
In This story, i would like to explain about XML Schema Definition tool in simple words with an example. In many projects where Xml files are used, there can be a need to generate Xml schema From an xml file and classes from schema file. We can use XML Schema Definition Tool (Xsd.exe) to generate Xm...