Programming SQL

Column description in transact-SQL
Check this link http://www.webtips.co.in/sql-server/transact-sql-to-get-description-of-column-in-sql-server-2005-using-fn-listextendedproperty.aspx ... 4 Jul 2008 03:53

Column description in transact-SQL
Check this link <a href="http://www.webtips.co.in/sql-server/transact-sql-to-get-description-of-column-in-sql-server-2005-using-fn-listextendedproperty.aspx"> Column Desc in SQL</a> ... 4 Jul 2008 03:53

Need Help Deciding On DB
I'm picking up a project (VB.NET) I started a few years back that stores thumbnail images 200X200 maximum along with a few columns of text. Currently it uses Access. As for records, that depends on the user. I don't foresee a user ever going over 200,000 records. I'm wondering if moving to SQLCE would net me... 7 Jul 2008 03:17

Standard procedure for error messages?
I have written some ASP.NET webservices and some SQL Stored Procedures. For example, I have a webservice that adds a new employee with 10 input parameters and 2 output (CounterID and IDKey). I would like the webservice to return any errors that the stored procedure encounters when executing. I am guessing ... 4 Jul 2008 08:59

Investor's Knowledge Analysis
Investor's Knowledge Analysis Hello! Please fill out the survey on Investment awareness & knowledge analysis. -- http://spreadsheets.google.com/viewform?key=pb_z4f1_zGMhaGMOzo4IsPw&email=true Check out this neat website I came across. You can find it here: http://investorline.co.in/blogs/news/?p=850 ... 3 Jul 2008 20:44

Reporting performance issue
Wei Peng (tapk5(a)hotmail.com) writes: We have a few report templates which worked fine in the past, but with data growing, their response is sluggish. I look for any idea to improve performance. please the attached query. If I use: ASGH.SkillGroupSkillTargetID in = 20152 or ASGH.SkillGr... 4 Jul 2008 16:09

ANN: DBTyP.NET 2008 - Database Comparison Tool - New Release
DBTyP.NET 2008 Release 3 Vienna, Austria - June 28, 2008 Today, BYPsoft announced the availability of DBTyP.NET 2008 Release 3, the newest version of the cross-database comparison tool that compares SQL Server, MySQL and Oracle databases (schema and data). DBTyP.NET 2008 Release 3 is available for download from http... 3 Jul 2008 17:40

How to tag 500 rows of a table without a unique key
i want to flag 500 rows in a staging table as the rows i'm going to process right now. Once they've been processed they will be deleted, and another 500 will get marked. i don't really care which 500 rows, just 500 of them. If the rows has a unique key, i would do an UPDATE ImportStaging SET ImportFlag = 1 ... 4 Jul 2008 16:09

Automation Script
Hi, I have to go to all tables within a database and assign a default value to the column DATE_CREATED. I am considering creating an automated script to do that. Is there any existing tool for these kinds of global changes? Thank you, Max ... 5 Jul 2008 11:30

invalid procedure call or argument destination on line 9
Can anyone see what is wrong with this vbscript? i get the invalid procedure call or argument destination on line 9 error ' Copy each source column to the destination column Function Main() IF DTSSource("GL_Load_Only")="Y" THEN DTSDestination("a_MonthlyPrelimSales_GLonly.Load_GL_Only ")=1 ELSE DTSDestinatio... 8 Jul 2008 19:17