|
You will have to convert your string in a valid datestring first. This should work:
declare @d as nchar(5)
set @d = '02 12'
select Cast('20'+ Right(@d, 2) + Left(@d,2) + '01' as datetime)Wout Louwers
|
|
|
|
|
Hi guys,
I have a problem when synchronizing web publication.
I begin by giving you an insight into my soft installed:
sql-server 2005
7even-windows so IIS7.5
I created a publication MaPublication.I made a right click on publication-> Release Local> MaPublication then I chose to configure synchronization Web.Then, next-> sql server mobile-> created a new directory select default website ->next->in Alias: SQLCE-> 2 messages appear successively OK OK-> next-> clients connect anonymously-> next-> OHH now when I click on the Edit tab to change a user account error message appears:
The program can not open the required dialog box because no location has been found.Close this message and try again
What is the problem? Is it a problem IIS??
Thank you for your contribution
Note: the MSDN help don't help me anymore so another propositionsmodified on Tuesday, March 16, 2010 1:03 PM
|
|
|
|
|
Hi Friends,
How to get a web page view source using sql stored procedure and then view source should be saved as a record in a table. Kindly please help me?
Thanks & Regards
Senthil Kumar.T.S
|
|
|
|
|
Getting the HTML source should be the job of your server side code and not the stored procedure.
|
|
|
|
|
Web page source is unassociated from SQL server unless you've got one really funky setup. Please elaborate on what you mean.
|
|
|
|
|
Hi Members
How to insert data in BFILE Data Type and retrieve data from BFILE Data Type?
Please help me
|
|
|
|
|
See here[^].Me, I'm dishonest. And a dishonest man you can always trust to be dishonest.
Honestly. It's the honest ones you want to watch out for...
|
|
|
|
|
|
thanks for response
But how can i retrieve data through command.Please help me
|
|
|
|
|
Do a search on the internet. There is tons and tons of information available.
By looking at the examples, I believe you will need to use a streamwriter.
Go through this article here[^].Me, I'm dishonest. And a dishonest man you can always trust to be dishonest.
Honestly. It's the honest ones you want to watch out for...
|
|
|
|
|
|
ok i search on net but i havn't found any running example.It may be my fault to understand.But before i ask question i always use google after that i ask question in forum.
Now you give me link.There is only i found create table and insert data into table through JAVA CODE.But i need simple use command in oracle(SQL*Plus).
Can you give me small example
Please help me
|
|
|
|
|
Have a look at this post here[^].
You can get your data but as SQL Plus is just a text editor, you will be unable to view your image.Me, I'm dishonest. And a dishonest man you can always trust to be dishonest.
Honestly. It's the honest ones you want to watch out for...
|
|
|
|
|
|
|
Hi,
I have a Location table. I am wondering what should be its primary key.
LocationTbl
ID identity (1,1) not null
LocationCode not null
LocationName null
LocationDescrption null
Thanks
|
|
|
|
|
Is this a trick question? Obviously the PK is the identity column.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
ID seems like an obvious choice but it won't have any meaningful info to end users. If LocationCode is unique and is meaningful to users, I would choose it as the primary key.
|
|
|
|
|
| I think you're missing the point with the primary key. It should never be visible to the end users! "When did ignorance become a point of view" - Dilbert
|
|
|
|
|
I do not agree that the primary key should never be visible to the end user but it is not a must have.
|
|
|
|
|
One of the key requirements for a primary key is that it must not change over time, and one of the best ways to achieve this is to use a surrogate key. Preferably an integer as most databases are tuned for queries on integers.
As it's only a part of the plumbing, the surrogate key has no need to ever be visible outside the DB. In particular, it should never be revealed to the user. This allows the DB administrator to change the representation of the keys at will if necessary.
I can think of very few circumstances when there's a sense in making a key visible to the end user. For example when it's used as a parameter in webpage request."When did ignorance become a point of view" - Dilbert
|
|
|
|
|
I agree.
|
|
|
|
|
Well said.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
As stated the ID should be your primary key with indexing on the LocationCode and possibly LocationName depending on criteria used to query the data.
|
|
|
|
|
Thanks fellows for replying to my post. I had no intenions to trick you. It just sometimes little things create a confusion. I think, I am going to keep LocationCode unique.
So, would you say i shouldn't keep ID (an identity column) in my Location table at all?
|
|
|
|
|
The ID column is a good idea. I would suggest you keep it.
|
|
|
|
|
If locationCode gets its values assigned by someone external to the system, then it should NOT be used as the PK of your table. Primary Keys must be yours, and yours alone. So nobody can entice you to suddenly change their values.
|
|
|
|
|
Hi all,
I'm running a .NET CF 2 application on WinCE, accessing a SQL Compact 3.5 database, and calling SqlCeDataAdapter.Fill() raises an error:
ExceptionCode: 0xC0000005
ExceptionAddress: 0x01a7438C
Reading 0x00000000
It seems to be caused by the underlying native DLLs but I cannot trap the error using C# exceptions. Any suggestions as to the likely cause/possible solution please?
TIA! ![Beer | [beer]](https://codeproject.freetls.fastly.net/script/Forums/Images/beer.gif)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
