String Functions in SQL Server Part 1 (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 8 months ago

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 based on the string family columns then you need to use string functions in order to return right output from your queries or modify t he out put to make it more meaningful. read more...

add a comment |category: Database |Views: 12

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

Useful Stored procedures in SQL Server Part 1 (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 9 months ago

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 information. 4) I want to see all the indexes which are created on a table. 5) I want to rename the objects etc. read more...

add a comment |category: Database |Views: 15

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

60 Seconds with Pinal Dave (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 9 months ago

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). read more...

add a comment |category: Other |Views: 54

tags: dotnetvj Vijaya_Kadiyala Vijaya Kadiyala another

SQL Server Beginer Articles Part 1(dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 1

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

MERGE in SQL Server 2005 (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 15

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

Create Table Using Select in Sql Server (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 178

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

OUTPUT in SQL Server 2005 (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 10

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

Load text or csv file data into SQL Server(dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 54

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

Drop table in SQL Server (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 10

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

Computed Columns in SQL Server (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 15

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

Foreign Key and Primary Key in SQL Server (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 10 months ago

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. read more...

add a comment |category: Database |Views: 33

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

List all the Foreign Keys in a SQL Server (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 10 months ago

The below script will give you list of Foreign Keys in a database and columns which are part of the Foreign key definition. read more...

add a comment |category: Database |Views: 22

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

XML Schema Definition Tool(dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 10 months ago

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 Xml schema from XML file. read more...

add a comment |category: XML |Views: 39

tags: XML Kadiyala Definition Vijaya XSD another