though i liked the solution provided in the previous post, here is another version..

select * from mytable where convert(varchar(6),datecolumn,112) between '200701' and '200702'

and convert(varchar(2), datecolumn, 108) between '20' and...

create table #test

(

col1 varchar(100),

col2 varchar(100)

)

create proc addCol @tabname varchar(100),@colName varchar(100), @dataType varchar(100)

AS

declare @sql as varchar(500)

set @sql='alter table ' + @tabname + ' add ' + @colname + '...

and the data type varchar2....

may be u'll also need NVL2 as well... as mentioned cast and convert needs to be replaced with specifics like to_string, to_Date, to_number etc...

There are...

The trickiest part of the editorial is

I guess it'll be less than that...

I bought...

we dont have double post. we've 5 posts on the same topic!!

RBarryYoung (12/30/2008)

---

Right, which leads to my strategy for dealing with block-headed vendors like this:

Question 1: What is your supported strategy for Disaster Recovery, that we should be implementing?

...

John Kandrovy (12/30/2008)

---

We are in the mist of moving a 3rd party vendor's SQL 2k database to a new server. According to the vendor it's our responsibility to move their...

create table #t

(col1 nvarchar(100)

)

alter table...

every action you perfom that changes data or structure of your database is first written to the log file (There are two...

Also refer to CONVERT Function in your Books Online for various conversion options available.

Read Andy's article on dynamic queries to grasp the concept.

http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/

Also http://www.sqlservercentral.com/articles/Security/dynamicsqlversusstaticsqlp1/617/

contains couple of example along with pros and cons of using dynamic sql.

The best resource is Books Online. Download it from Microsoft's site if you dont have a copy.

Second best resource is this site itself. You'll find hundreds of amazing articles on...

Duplicate Post. Pls reply to

http://www.sqlservercentral.com/Forums/Topic627369-23-1.aspx

That link if from your Books Online.

Simple way to copy/paste that link in your Query Window in SSMS and do CTRL+CLICK. it'll take you to required page.

Refer BOL. This link contains good example of enctyption using AES algorithm.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/38e9bf58-10c6-46ed-83cb-e2d76cda0adc.htm