Posted in SQL-SERVER

Create New Database in SQL-Server Management Studio 2008.

Create New database in sql server management studio 2008. create table in sql database in sql server management studio 2008.

Continue Reading...
Posted in SQL-SERVER

Create Stored Procedure in SQL-Server.

Stored Procedure in SQL Server – Create new Stored Procedure in SQL-Server management studio 2008. how to write sql stored procedure in database.

Continue Reading...
Posted in SQL-SERVER

Copy one Table with Data to another Table in SQL-Server

create and copy new table from an existing table in sql server management studio. How to copy all the columns with data from one table to another table in sql server management studio 2008.

Continue Reading...
Posted in SQL-SERVER

CHAR, VARCHAR and NVARCHAR Data Type Difference.

SQL Datatype difference : Difference Between Sql Server CHAR, VARCHAR and NVARCHAR Data Type.

Continue Reading...
Posted in SQL-SERVER

Create XML using SQL Query in SQL Server 2008

Here, we will learn how to create XML using Query: SELECTTOP1000 [Code]       ,[Name]       ,[Price]   FROM[Temp].[dbo].[Product]   FORXML RAW (‘Product’),   ROOT (‘Products’); Here SQL statement “FOR XML…

Continue Reading...