SQL-SERVER | Meera Academy

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.

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.

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.

SQL-SERVER

CHAR, VARCHAR and NVARCHAR Data Type Difference.

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

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…