Assuming the underlying data types are date/time/datetime types: SELECT CONVERT(DATETIME, CONVERT(CHAR(8), CollectionDate, 112) + ‘ ‘ + CONVERT(CHAR(8), CollectionTime, 108)) FROM dbo.whatever; This will convert CollectionDate and CollectionTime to char sequences, combine them, and then convert them to a datetime. The parameters to CONVERT are data_type, expression and the optional style (see syntax documentation). The … Read more
If your on SQL 2005 you can try: BEGIN TRANSACTION BEGIN TRY –Run your Statements COMMIT TRANSACTION END TRY BEGIN CATCH ROLLBACK TRANSACTION DECLARE @Msg NVARCHAR(MAX) SELECT @Msg=ERROR_MESSAGE() RAISERROR(‘Error Occured: %s’, 20, 101,@msg) WITH LOG END CATCH
If you need column names in the response then proceed with the select TOP 0 * from that table, otherwise just use SELECT TOP 0 NULL. It should work pretty fast 🙂
Not sure if it is pertinent to the OP’s question anymore, but in case you came here to find out how to prevent recursion or mutual recursion from happening in a trigger, you can test for this like so: IF TRIGGER_NESTLEVEL() <= 1/*this update is not coming from some other trigger*/ MSDN link
There is no need to add a DEFAULT(NULL) to nullable columns. If data is not supplied to such columns, they will have a NULL. The only benefit I see is the one Larry Lustig has posted in his comment to the question – it documents the fact that you have not forgotten to add a … Read more