install second operating system

I want to declare a variable in SQL SERVER 2000?

Feb 11, 2008 by nitin k | Posted in Programming & Design

I Query this variable from Table which is of Text type
and store in variable.What datatype should be used to store this variable.Actually this variable has SQL QUERY stored,
I execute this variable by sp_executequery method in SQL SERVER

Try the READTEXT statement

you can read more about it in the SQL Server books online

try copying and pasting the following in IE or just search for it in books online

mk:@MSITStore:C:\Program%20Files\Micro

Iyad M | Feb 11, 2008

Overview of SQL Server Data Types: Date and Time

This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is ...

Overview of SQL Server Data Types: Numbers

This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is ...

SQL Server - Data Types and Properties Free Video Tutorial

idealprogrammer.com - SQL Server - Data Types and Properties Free Video Tutorial - Learn about data integrity, data types, common data type problems.

SQL Server Data Types: An Overview

This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is ...

SQL Server XML Data Type and Relational Data

This video discusses how to use the sql server xml data type in conjunction with relational table data.

Digg Headlines

(1 diggs) SQL Server Money datatype pushed to SqlDataSource
Sep 20, 2010 from go4answers(Monica Smith) in *
go4answers I have a table in my SQL Server db with fields of money datatype. It seems as though SQL Server likes to have 4 decimal places for the money datatype, but is there any way in the settings of this table or that money field to change this to 2? I know how to programmitically trim the last two zeros, just wondering if I can manually set something so I don't have to do this every time I retrieve the money datatypes from the database table.Thanks in advance! :)...Read more on SQL Server Money...
(1 diggs) time datatype
Oct 26, 2010 from go4answers(Monica Smith) in Technology
go4answers is there in sql server 2005 time typeI want to save in table only time hh:mmis that possible ?...Read more on time datatype
(2 diggs) Update text/ntext or varchar(max) data-type columns in SQL Server
Jul 24, 2007 from decipherinfosys
decipherinfosys Sometimes, there is a need to store large data set like a big xml file, resumes, book reviews etc. in the database. Since we store the data, occasionally we may have to update it as well. MS SQL Server 2000 provides TEXT data type to store such large contents in the table. In the following example, we will show how we can manipulate such columns...
(1 diggs) Datatype casting/conversion
Sep 29, 2010 from go4answers(Monica Smith) in Technology
go4answers I am working on updating an existing ASP.NET server-side application using VS2008 and DOT-NET 3.5 Framework. I come from a primarily VB/VB.NET/SQL background.We have added a third-party custom control to the application.I try assigning the .VALUE property (type decimal) to a variable of type decimal and I get this error:"Cannot implicitly convert type 'object' to 'decimal'. An explicit conversion exists (are you missing a cast?)" That is the exact text from the error. (Its a......Read more on...
(3 diggs) SQL Server 2008 Will Have 7 New Datatypes
Jun 25, 2007 from sqldigg
sqldigg SQL Server 2008 will have 4 new date datatypes and also new datatypes for GeoSpatial data. The Spatial datatypes will be exposed as .NET system UDTs