TSQL Challenge 45 - Evaluate mathematical expressions presented using
This challenge involves evaluating mathematical expressions presented using Roman Numerals and return the result of each expression.
2010-12-13
1,693 reads
This challenge involves evaluating mathematical expressions presented using Roman Numerals and return the result of each expression.
2010-12-13
1,693 reads
The first part of your job is to identify the unique color combinations of products and the second part is to identify the products that have the given color combination.
2010-11-29
1,382 reads
This challenge involves writing a logic to identify incomplete segments and missing elements in an electronic data integration file exchanged between two applications.
2010-11-16
879 reads
This challenge involves writing a logic to change the column position of values in the output based on the presence and absence of other values on each output row.
2010-11-01
2,872 reads
This challenge involves extracting email addresses from a table that contains text data downloaded from various websites.
2010-10-18
2,274 reads
This challenge involves converting numeric values from binary format to hexadecimal format.
2010-10-04
1,670 reads
Jacob Sebastian takes a look at some different ways to write your WHERE clauses. A good basic article for those starting to work with T-SQL.
2010-07-30 (first published: 2008-02-27)
81,571 reads
This article presents a generic function that makes it easy to query XML documents
2010-06-30
12,341 reads
This article from MVP Jacob Sebastian looks at the modify method for changing an XML document.
2010-03-18
10,343 reads
The cloud services from Microsoft for SQL Server are known as SQL Azure. MVP Jacob Sebastian brings us a introductory article about how to work with this service.
2009-10-22
9,743 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132.. Fungsi Layanan:...
Call Cs 08218200233 Jl. Borobudur No.I, RT.03/RW.07, Mojolangu, Kec. Lowokwaru, Kota Malang, Jawa Timur...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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