JayceOoi.com

- Technology, mobile, photography, gaming, programming, anything -

When SET QUOTED_IDENTIFIER ON, identifiers can be delimited by double quotation ” marks, and literals must be delimited by single quotation ‘ marks. However, when SET QUOTED_IDENTIFIER OFF, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers. Hmm… So what this mean?

For example,

SET QUOTED_IDENTIFIER OFF
GO

– You cannot use reserved keyword, it will fail
CREATE TABLE “select” (“identity” INT IDENTITY NOT NULL, “order” INT NOT NULL)
GO

SET QUOTED_IDENTIFIER ON
GO

– When is ON, you can use reserved keyword. It will pass.
CREATE TABLE “select” (“identity” INT IDENTITY NOT NULL, “order” INT NOT NULL)
GO

Another example,

SET QUOTED_IDENTIFIER OFF
GO

– Literal strings can be in single or double quotation marks.
INSERT INTO dbo.Test VALUES (1, “‘Text in single quotes’”)
INSERT INTO dbo.Test VALUES (2, ‘”Text in double quotes”‘)

When SET ANSI_WARNINGS ON, warning message will be returned. On the other hand, SET ANSI_WARNINGS OFF will turn off the warning message.

WW36 weekly contest winners

Yeah… The WW36 weekly contest is finally ended. And we have 2 lucky winners, Chin Wei and Mr Soleh. Only 2 people participated in this contest and both of them got the answers correct. Both of them will receive one RM10 KFC / Pizza Hut voucher. And I will keep one for myself. HeHe… :)

Here are the answers for WW36 weekly contest…

1. Who is the owner of JayceOoi.com?
Jayce Ooi
2. When is the birthday of JayceOoi.com?
30 March (2007)

Were the questions easy? HeHe… Too bad that most of the people just drop by and left without participate the contest. Wondering why? Never mind, there is another contest coming out this weekend. ;)

Why Some People Have All the Luck?

I received this email. It caught my eyes. Sharing it out for all of you to enjoy…

Why Some People Have All the Luck? By Professor Richard Wiseman, University of Hertfordshire

Why do some people get all the luck while others never get the breaks they deserve?

(more…)

Last day for WW36 weekly contest

Hurry up!!! WW36 weekly contest is due tonight 8pm. 3 FREE KFC / Pizza Hut vouchers will be given. For those don’t like the voucher, you can opt for RM10 cash / US$ 3 PayPal. :)


Page 548 of 630<<546547548549550>>


Featured ...

Patriot FUEL+ 6000 & 9000 mAh Mobile Rechargeable Battery Review
64GB SanDisk Extreme microSDXC UHS-I Card Review
64GB Samsung microSDXC Pro UHS-1 Card Review

Guide for ...

Samsung Galaxy Note 3
Google Nexus 7 (2013)
Samsung Galaxy S4
Google Nexus 4
Samsung Galaxy Note 2
Google Nexus 7
Samsung Galaxy S3
HTC One X
Amazon Kindle Fire
Samsung Galaxy S2
HTC HD2

Follow ...