THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Denis Gobo

SQL Sentences

Why not store all of the SQL queries in the database?

Published Monday, February 25, 2008 12:15 PM by Denis Gobo
Filed under:



Jason said:

I hear this works best if you store all of the sentences comma separated in a single row\column with a varbinary(max) data type.

February 25, 2008 12:18 PM

andyleonard said:

I don't know Jason... how about storing them all in a single row - in one xml column in the sql_sentences table?

:{> Andy

February 26, 2008 10:55 AM

Denis Gobo said:

>>in one xml column in the sql_sentences table?

XML is sooooooo slow, I would put them in one nice NTEXT column  :-6

This way I can for security reason prohibit the substring functions etc

February 26, 2008 11:21 AM

andyleonard said:

>> This way I can for security reason prohibit the substring functions etc

Maybe encrypting or hashing the column as well... who wants all those sql_sentences floating around in the open?

:{> Andy

February 26, 2008 3:28 PM

Peter W. DeBetta said:

Is there a SQL Sentence to retrieve a SQL Sentence? (Or did I just blow your mind?)

February 26, 2008 5:21 PM
New Comments to this post are disabled

About Denis Gobo

I was born in Croatia in 1970, when I was one I moved to Amsterdam (and yes Ajax is THE team in Holland) and finally in 1993 I came to the US. I have lived in New York City for a bunch of years and currently live in Princeton, New Jersey with my wife and 3 kids. I work for Dow Jones as a Database architect in the indexes department, one drawback: since our data goes back all the way to May 1896 I cannot use smalldates ;-( I have been working with SQL server since version 6.5 and compared to all the other bloggers here I am a n00b. Some of you might know me from or even from some of the newsgroups where I go by the name Denis the SQL Menace If you are a Tek-Tips user then you might know me by the name SQLDenis, I am one of the guys answering SQL Questions in the SQL Programming forum.

This Blog


Privacy Statement