Programming SQL

How to select specific line in select statement from a give multiline text field/column of a table
TableName : TableX Column 1 : name (single line) Column 2 : Comments (multiple line) In "Column2" i have comments which are all about roughtly 20 lines but can vary. What i want to do is for example i want to write a select query which will display both columns but only show line 13 (or whichever i want) from c... 24 Jul 2008 12:55

Trimming chars
I just ran into an issue in 2005 where if I have a field that is a char(8), the select statement will still find the values if they are less then 8 characters (even though chars blank fill). For example if Quarter is char(8), I can do: SELECT * FROM COURSE WHERE Quarter = 'Fall' and get all my records. ... 16 Jul 2008 17:11

Correct Way to Insert into Multiple Tables - Materialised
Did you check the value for 'rowsAffected'? If you have in your stored procedure SET NOCOUNT ON then it will not return the correct rows affected to the client. HTH, Plamen Ratchev http://www.SQLStudio.com ... 16 Jul 2008 13:01

Creating parameterized query in SSIS package
Hi All, I have created a query to run in a .dtsx package. I would like to parameterize it so that a user can input a value via the Execute Utility dialog when the .dtsx package is double-clicked. Any info would be appreciated! Thanks, Gloria ... 18 Jul 2008 05:09

SQL2005 Express - where is the problem?
Hello, i have a problem with SQL2005 and VB2005. I receive randomly this error when calling a "select from a table" Random Error1: Column 'mycolumn' does not belong to table . Server stack trace: at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnNa... 16 Jul 2008 13:01

using parameterized query in ssis package
To All, I am trying to get a parameterized query to run in a ssis package. I ran the dtsx file with hard-coded values and the query and package work. The package exports data from a database into an Excel file. My hope is that users can double-click on the .dtsx file and get the Execute Package Utility Dialog... 16 Jul 2008 16:09

Correct Way to Insert into Multiple Tables -Materialised
You know, this help me alot as a beginner. But I ended up into a road block. I use a button insert to add my data. If it is successful it transfer to a confirm page and if it fails then to a problem page. But when i use this stored procedure although the info was successfully entered in my tables, it still tranfer to m... 16 Jul 2008 11:59

Arithmetic overflow
I am getting the following error message when I run sp_databases: Server: Msg 8115, Level 16, State 2, Procedure sp_databases, Line 32 Arithmetic overflow error converting expression to data type int. I also get the same message when I run "select count(*) from ...." Thanks ... 16 Jul 2008 11:59

Arithmetic overflow
I am getting the following error message when I run sp_databases: Server: Msg 8115, Level 16, State 2, Procedure sp_databases, Line 32 Arithmetic overflow error converting expression to data type int. I also get the same message when I run "select count(*) from ...." Thanks ... 16 Jul 2008 19:15

SQL Server Restore Exclusive Access
I am trying to run a SQL Server Restore of a Test Database and am getting a message saying... Exclusive access could not be obtained because the database in use. I have seen this before when I have an open thread to the database. I checked with my fellow programmers and they are telling me they have nothing ... 16 Jul 2008 11:59