Click here to Skip to main content
15,918,333 members
Home / Discussions / Database
   

Database

 
AnswerRe: Stored Procedure Error PinPopular
neilarnold14-Nov-08 2:00
neilarnold14-Nov-08 2:00 
GeneralRe: Stored Procedure Error Pin
Syed Shahid Hussain14-Nov-08 2:34
Syed Shahid Hussain14-Nov-08 2:34 
GeneralRe: Stored Procedure Error Pin
Syed Shahid Hussain14-Nov-08 2:41
Syed Shahid Hussain14-Nov-08 2:41 
GeneralRe: Stored Procedure Error Pin
Jeremy Falcon14-Nov-08 6:21
professionalJeremy Falcon14-Nov-08 6:21 
QuestionProblem with SQL Where - using IF or CASE Pin
But_Im_a_Lady13-Nov-08 23:11
But_Im_a_Lady13-Nov-08 23:11 
AnswerRe: Problem with SQL Where - using IF or CASE Pin
Ben Fair14-Nov-08 3:14
Ben Fair14-Nov-08 3:14 
GeneralRe: Problem with SQL Where - using IF or CASE Pin
But_Im_a_Lady14-Nov-08 3:53
But_Im_a_Lady14-Nov-08 3:53 
QuestionProblem with synonyms in SQL Server 2005 Pin
boabab13-Nov-08 20:59
boabab13-Nov-08 20:59 
AnswerRe: Problem with synonyms in SQL Server 2005 Pin
Wendelius14-Nov-08 7:37
mentorWendelius14-Nov-08 7:37 
QuestionHow to get the schema of results from a stored procedure Pin
gantww13-Nov-08 11:00
gantww13-Nov-08 11:00 
AnswerRe: How to get the schema of results from a stored procedure Pin
Mycroft Holmes13-Nov-08 15:46
professionalMycroft Holmes13-Nov-08 15:46 
GeneralRe: How to get the schema of results from a stored procedure Pin
gantww13-Nov-08 17:17
gantww13-Nov-08 17:17 
QuestionSQL Express 2005 Database Read-Only Problem Pin
Ahmad Safwat13-Nov-08 3:37
Ahmad Safwat13-Nov-08 3:37 
AnswerRe: SQL Express 2005 Database Read-Only Problem Pin
Wendelius13-Nov-08 4:52
mentorWendelius13-Nov-08 4:52 
GeneralRe: SQL Express 2005 Database Read-Only Problem Pin
Ahmad Safwat13-Nov-08 5:37
Ahmad Safwat13-Nov-08 5:37 
GeneralRe: SQL Express 2005 Database Read-Only Problem Pin
Wendelius13-Nov-08 6:53
mentorWendelius13-Nov-08 6:53 
GeneralRe: SQL Express 2005 Database Read-Only Problem Pin
Ahmad Safwat15-Nov-08 21:11
Ahmad Safwat15-Nov-08 21:11 
GeneralRe: SQL Express 2005 Database Read-Only Problem Pin
Wendelius15-Nov-08 21:38
mentorWendelius15-Nov-08 21:38 
GeneralRe: SQL Express 2005 Database Read-Only Problem Pin
Ahmad Safwat15-Nov-08 23:50
Ahmad Safwat15-Nov-08 23:50 
GeneralRe: SQL Express 2005 Database Read-Only Problem Pin
Wendelius15-Nov-08 23:57
mentorWendelius15-Nov-08 23:57 
AnswerRe: SQL Express 2005 Database Read-Only Problem Pin
Paul Conrad13-Nov-08 6:39
professionalPaul Conrad13-Nov-08 6:39 
Questioninsert into and varbinary Pin
swjam13-Nov-08 2:18
swjam13-Nov-08 2:18 
AnswerRe: insert into and varbinary Pin
Wendelius13-Nov-08 4:45
mentorWendelius13-Nov-08 4:45 
QuestionI want to diplay particular records between two dates using nvarchar Pin
Samiullah13-Nov-08 0:12
Samiullah13-Nov-08 0:12 
AnswerRe: I want to diplay particular records between two dates using nvarchar [modified] Pin
Syed Mehroz Alam13-Nov-08 2:15
Syed Mehroz Alam13-Nov-08 2:15 
Samiullah wrote:
create table rough(checkeddate nvarchar(100))


Why are you storing date as an nvarchar? Try using a datetime type instead and you can easily filter records using the query you mentioned. But if you still want to achieve it using an nvarchar, you can simply cast the value to a datetime. Here's a small change to your query:

select * from rough where cast(checkeddate as datetime) between '1/01/2006' and '12/31/2006'


Regards,
Syed Mehroz Alam

My Blog
My Articles

Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination. - Albert Einstein

modified on Thursday, November 13, 2008 8:22 AM

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.