... The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the...
Today I will explain about the different ways to add a NOT NULL constraint on a column. Advantages of NOT NULL constraint: 1) You can prevent users to enter...
One of the cirtical factor in database/table designing is to prevent duplicate records. There are several ways to do this. You can place Unique Index or Unique...
In this section we will learn on defining a Foreign Key Constraint. In simple words lets try to define a relationship between two tables. Please visit the...
The below script will give you list of Primary Keys in a database and columns which are part of the primary key definition. If you don't know how to add a...
60 seconds with Abhishek Kant MVPs are champions of community. VJ caught up with Abhishek Kant, India MVP Lead, to get his view on the Microsoft Most Valuable...
The below script will give you list of Foreign Keys in a database and columns which are part of the Foreign key definition. If you don't know how to add a...
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...
Hi 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...
Hi 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. You can use DROP TABLE to drop...
Hi Today, I will talk about how to change the data type of a column which has data. Let's create one simple table CREATE TABLE EMPLOYEE_WORKING_HRS(EMP_ID INT,...
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...
Next meeting will be April 29th at noon EDT. Meeting Details Topic: PowerShell PowerShell is all over SQL Server 2008 but most DBA's don't have a clue about...
In this section, I would like to talk about one interesting feature of SQL Server 2005. Before I say anything about this feature let me ask you a simple...
Hi veer, I was unable to attend the session, do we have the session recorded. Thanks Vijayasekar ... -- Thanks Vijayasekar [Non-text portions of this message...
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...
Hello All, I am looking for feedback from you guys how to go about installing SSIS in SQL Cluster. I need clarification on the following areas. Do SSIS...
In this section, I would like to tell you about adding a column to the existing table with a default value. Default value is very useful in the sense if you...
In my previous article, I explained about how to assign a DEFAULT value to a column. In this section I will explain about how to drop/remove DEFAULT value from...
In this article I would like to explain about how to rename a table using SQL Server Management Studio (SSMS). If you look at my previous article on "Load text...
Hi In this article I would like to explain about "Constraints". Constraints are one of the key factor in designing a table. Before I explain what is the use of...
In this article I will talk about Table Level Constraints in SQL Server. These are very useful if you want to have rules based on multiple columns with in a...
In this article I would like to show you on how to find the check constraints defined on a table. In my previous articles I explained about Check Constraint...
Is all this syntax required , like syntax for to create a temp table or find the constraint or create table syntax etc Radhye ... From: vijaya_krishna_birju...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
