SQL Server - Convert() function
Convert () function in SQL Server to convert an expression from one data type to another data type
Syntax for CONVERT function
CONVERT ( data_type [ ( length ) ] , expression...
2015-01-24
1,888 reads
Convert () function in SQL Server to convert an expression from one data type to another data type
Syntax for CONVERT function
CONVERT ( data_type [ ( length ) ] , expression...
2015-01-24
1,888 reads
When you have to compress a database you'd better first see the considerationfor the compression.This is a script that I...
2015-01-24
71 reads
Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to...
2015-01-23
1,948 reads
I was excited to learn this week that I’ve been chosen as a participant in the Friends of Red Gate...
2015-01-23
568 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-01-23
485 reads
I’m just starting to look at functional languages from an Object Oriented background. One of the first things I thought...
2015-01-23
49 reads
After almost 5 years of existence, SQLPort (Portuguese PASS Chapter in Lisbon) is kicking of 2015 with a renewed image...
2015-01-22
539 reads
Read XML column attributes in to two columns DimType and Dimvalue from the below example also retrieve the data matching...
2015-01-29 (first published: 2015-01-22)
38,615 reads
I'm sitting on a plane. I'm in an exit row, still a big guy in a little seat. I go...
2015-01-22
806 reads
Steps to install standalone SQL Server 2012 instance 1) Start the setup > Go to Installation from Left > Click on 1st option of New SQL Server standalone edition...
2015-01-22
22 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers