Strangenut

Sign in | Join | Help

SQL Server Blog » All Tags » database » beginner » T-SQL (RSS)

Browse by Tags

SQL Server Blog

Home
Contact

Syndication

Recent Posts

Tags

News

Why don't you take a few minutes to join Strangenut, I'm trying to build an interactive community and would love to have your feedback on what I write and suggestions and questions I can answer! It's free, I won't spam you, and won't sell your address to anyone!

Programming

Archives

How to find all tables with a column of a particular name in SQL Server 2005 and 2008

This is a simple query for finding all instances of a column with a particular name along with the table that it belongs to. This will not work on SQL Server 2000. select sys.objects . name as TableName , sys.columns . name as ColumnName from sys.columns...

Published Fri, Feb 02 2009 1:37 AM by dacrowlah

Filed under: T-SQL, database, SQL Server, beginner, tips and tricks
How to enable CLR Stored procedures on SQL Server 2005 and 2008

In order to make CLR stored procedures run, you must first enable the CLR in SQL Server, other wise you will just get this error: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option. Enabling the...

Published Sun, Oct 10 2008 8:53 PM by dacrowlah

Filed under: T-SQL, database, SQL Server, beginner, stored procedure
Making the case for stored procedures

On a few of the mailing lists I am on for developers (primarily ones related to web development), there is a recurring topic that always gets people into rather heated debates: to use stored procedures or prepared statements? Now, either one you choose...

Published Sun, Oct 10 2008 2:23 AM by dacrowlah

Filed under: query execution plans, T-SQL, performance tuning, database, SQL Server, beginner, stored procedure

Powered by Community Server (Non-Commercial Edition), by Telligent Systems