Blogs about: Sql Statements
Featured Blog
Getting MS SQL Database size using ColdFusion
Someone asked how to retrieve the size of all MS SQL Server databases using Coldfusion. There is a handy built in stored procedure called sp_spaceused which will do the job for you. You can view the c… more →
now musing at www.aliaspooryorik.com!
C# - SQL Class
thebest51 wrote 2 months ago: Here my class to run SQL statements whitout declare and initialize Connection and Command in 2 Array … more →
Funny SQL statements
— 7 comments
masood wrote 1 year ago: One might wonder how SQL statements can make no excuse to laugh obstreperously, here are some funny … more →
Mythvideo HOWTO move files from one directory to another...
— 2 comments
howardrabb wrote 1 year ago: What seems like a no brainer I know. If I want to move files from one place to another all I do is c … more →
Getting MS SQL Database size using ColdFusion
aliaspooryorik wrote 1 year ago: Someone asked how to retrieve the size of all MS SQL Server databases using Coldfusion. There is a h … more →
Using CharIndex to get a SubString
— 1 comment
aliaspooryorik wrote 1 year ago: If you need to extract part of a string based on the index of a character in SQL, then you can use t … more →
SQL Server Express 2005 and ColdFusion 8
— 2 comments
aliaspooryorik wrote 1 year ago: ColdFusion does not connect to the default install of SQL Server Express 2005. After much swearing I … more →
Sorting alpha and numeric data in the same field
aliaspooryorik wrote 1 year ago: The problem I had was the client was entering some room names as numbers and others as a number with … more →
SQL server table schema
aliaspooryorik wrote 2 years ago: SELECT Table_Name FROM INFORMATION_SCHEMA.TABLES WHERE Table_Type = ‘BASE TABLE’ AND Tab … more →
Genius bit of code for find MS SQL table sizes
— 1 comment
aliaspooryorik wrote 3 years ago: http://www.databasejournal.com/img/BigTables.sql /************************************************** … more →
String Manipulation in MS SQL Server
aliaspooryorik wrote 3 years ago: http://www.informit.com/articles/article.asp?p=25040&rl=1 … more →
MS Access SQL statements
aliaspooryorik wrote 3 years ago: Create Table with Incremental Primary Key Create Table [Courses] ( [course_id] Counter NOT NULL, [co … more →
MS SQL samples
aliaspooryorik wrote 3 years ago: Rename a table Exec sp_rename [CurrentTableName], [NewTableName] Rename column EXEC sp_rename '[tabl … more →
