Programming SQL

generic datatype table
I have designed the following table that is generic in datatype for its primary data ... Id (PK, bigint, not null) SymbolId (int, not null) IntervalTypeId (int, not null) IntervalMultiplier (int, not null) BarNumber (int, null) DataDateTime (DateTime not null) ValueDatatypeId (int, not null) ValueBoolean ... 16 Jul 2008 19:15

@@Error changed by Begin?
Is this code valid in a proc? <Some SQL statement> If @@Error <> 0 Begin RaisError('ProcName: Return code %i doing something', 16, 1, @@Error) With SetError Return @@Error End The Begin stataement shouldn't change the @@Error value, correct? The call to Rais... 25 Jul 2008 16:36

Problem: MySQL time datatype to SQL Server 2005 Datetime
when trying to insert a MySQL time datatype into a SQL Server 2005 DatTime (using a C# program) format I get the error message: Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'.Couldn't store <22:00:00> in StartHour Column. Expected type is DateTime. I searched the Internet but... 15 Jul 2008 09:12

Saving Stored Prodedure results to an excel file
I have created an access app that passes 3 parameters from a form, to a stored procedure that performs a query I need to be able to save the result to a excel file without creating a table in sql server. How can this be accomplished ... 12 Jul 2008 13:35

Date parameter defaults to current system date
I coded a parameter: @RunDate As DateTime = GetDate() and it complained, can this be done? ... 11 Jul 2008 16:08

Return the indexed word from a full text catalog
Hi, Is there a way where I also can return the indexed word similar to the way we can get the Key and Rank? Thanks in advance Christian ... 15 Jul 2008 02:03

T-SQL first and last day of current month
I need an elegant way to determine the first and last of the current month so I can compare if other dates are prior to or after the current month. I do know that GetDate() gets me the current date and DatePart() gets me individual parts of the month. I think I can see how to get the first of the month but the... 11 Jul 2008 15:06

Is this possible?
In a stored procedure is it possible to excecute some SQL that returns a single value and then get that value into a variable? thanks. ... 11 Jul 2008 14:04

checking to see if a row is being updated
I have been asked to find out if it is possible to see if a row is being updated. Suppose this is executed UPDATE Table1 SET column1 = Column1 WHERE Column1 = 1 Are there DMVs or other places that are available that would enable a question like: Does the row where column1 = 1 on table1 have an intent or exclu... 13 Jul 2008 05:54

Need view with variable parameter
I need to do what a view does (return a table) but I need a variable parameter (current date). I've heard about functions, can they do this and how do I write one? Thanks. ... 11 Jul 2008 15:06