Table - Batch
BatchNo BatchName PublicationList
-------- ----------- ----------…
11 months ago
Is there any method to sort a column(numeric) without using ORDER BY clause.
Dinendra Nath Dolai
By: Jeff Moden
Is there anyway that we can retrieve the Last Run date of a SQL Job using T-SQL.
Hello, I am fairly new to SQL and trying to write a simple query. The problem is the date/time…
By: Lynn Pettis
I need help on the following please.
i have stored the information 'birthdate' on the table c…
By: Luis Cazares
I have a problem where I have imported quite a lot of data from an Excel file, and some of …
11 months, 2 weeks ago
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP hos…
i'm trying to count the number of decimal places in a field.
e.g. mynumber decimal 9 (18,9)
11 months, 3 weeks ago
By: John S (Kerkrade)
I am trying to extract either a 2 digit or 3 digit number to the right in a product description.
1 year ago
Does anyone know how to write the T-SQL that checks if a job is still running? I need to make…
I would like to prepare a diagram which will explain the work flow of a stored proced…
I have a column called [created date ] that is of the datetime data type. This column has the date …
1 year, 1 month ago
By: Lord Slaagh
i have thousand records in my tablei.e:
i want to update …
By: Eirikur Eiriksson
I have a set of related dbs and I need to do some cross-db queries and I want to do them genericall…
1 year, 2 months ago
Following is my procedure
CREATE PROCEDURE prg_SHOW_VIEW_RUNNINGTIME ( @strViewName NVA…
1 year, 4 months ago
By: Gail Shaw
Viewing 15 topics - 16 through 30 (of 17,071 total)
You must be logged in to create new topics.