Lab Sql

While renaming the column name, the square bracket is included in the column name, which I think is… Read more Is This A Problem In The Sp_rename Function Or Sql Server Itself?

I've done this before in .Net but I am somewhat new to PHP and could use some help. I'm tr… Read more Retrieve Greek Letters From Mssql Database With Php

I am trying to read in a text file from an SQL query (SQL Server 2005) but am not having any luck a… Read more Reading A Text File With Sql Server

This is a follow up to the question Nested stored procedures containing TRY CATCH ROLLBACK pattern?… Read more Recording Sql Server Call Stack When Reporting Errors

I have a SQL CLR function which at the moment returns a string seperated by a comma. How would I co… Read more Sql Clr Return Two New Columns

is there an easy way to get a list of all columns of a SQL query? They are listed in the header of … Read more How To List All Columns Of A Given Sql Query

Why does SQL server behave this way. I am running this on SQL 2005. The IN clause does not validate… Read more Using The Dangerous In Clause In Sql

I would like to set up a localhost server to test my site on in sql server 2005. I just installed s… Read more Setting Up Local Server In Sql Server 2005