CONVERT DATETIME seems all right, but still ...

A table with a varchar column that has date and other value types too.
A query with a simple CONVERT DATETIME

Conversion failed when converting date and/or time from character string.

Crashing. Over and over again. I start to call it X-Files.
Until I read THIS.

Not only I know why it happened (and sortof feel like SQL is "stupid" :D) but I get an interesting idea to work around the issue.

F7 - Visual Studio - switch between aspx and "codebehind"

It was not working for me.

This is what I had to do:

• Bring up customization dialog with "Tools\Customize..."
• Bring up the keystroke mapper with "Keyboard..."
• Set focus in "Press Shortcut Keys" text box
• Press F7 or some other keystroke you want
• The "Shortcut currently used by" box will show the command currently invoked by the keystroke.
• Set focus to "Show Commands Containing" and type ToggleDesigner
• This will select the View.ToggleDesigner command in the list box of commands
• Next press the "Assign" button to assign the keystroke shortcut to the command.
• Click "OK" to the keystroke mapper dialog
• Click "Close" to the customization dialog

SQL split using Parsename

Interesting way to SPLIT stuff in SQL

Parsename, read all about it, here

DECLARE @FullName VARCHAR(100)
SET @FullName = 'John Doe'

SELECT PARSENAME(REPLACE(@FullName, ' ', '.'), 2) AS [FirstName],
PARSENAME(REPLACE(@FullName, ' ', '.'), 1) AS [LastName]

TextboxWatermarkExtender and Textbox with TextMode = Password

I managed to do this by setting the watermark stylesheet to overlay an image in the textbox.

You simply take a snapshot of how you want the watermarked textbox to look, save that, then set the watermark css of that textbox to a style that displays the image and aligns the text to the right (because otherwise it will still be visible)

It's very easy and works flawlessly.

The Textbox:

<asp:TextBox ID="Password" runat="server" CssClass="txtbox_login" Width="120px" TextMode="Password">

The Watermark (Set the WatermarkText property to anything you want, but just one character):

<ajax:TextBoxWatermarkExtender ID="txtWMark2" runat="server" WatermarkCssClass="watermarked_psw"TargetControlID="Password" WatermarkText="*" />

The StyleSheet (You MUST align the text to the right, otherwise it will still display over the image):

.watermarked_psw

{

color: White;

font-family: Tahoma;

font-size: 11px;

border: solid 1px #a9a9a9;

text-indent:2px;

vertical-align:middle;

text-align:right;

background-image:url(../images/psw_wMark.png);

background-repeat:no-repeat;

}

I found this one here, by JeanT

It works !

SQL for CNP :D

create table #cucu(bau varchar(10)) insert into #cucu (bau) values ('123') insert into #cucu (bau) values ('3888') insert into #cucu (bau) values ('2888') insert into #cucu (bau) values ('6888') insert into #cucu (bau) values ('300a') select * from #cucu where bau LIKE '[3,4,6][0-9][0-9][0-9]' drop table #cucu