Viewing 15 posts - 10,591 through 10,605 (of 15,381 total)
Oksana March (9/26/2012)
I need help understanding something.
The situation is - I have a table that stores comments about shipments, and sometimes the same comment is in a table...
September 26, 2012 at 7:46 am
Are you sure that works?
For me it has errors. There's no such thing as "DELETE field FROM Table" as it will delete the entire row. And AFAIK you can't use...
September 26, 2012 at 7:42 am
jrichards54 (9/25/2012)
September 25, 2012 at 4:08 pm
jrichards54 (9/25/2012)
I don't understand what you mean at all with second issue. Are you saying you can't connect to your database with Visual...
September 25, 2012 at 2:23 pm
Excellent job posting ddl and sample data!!!!
I did change up your columns a little bit so it is easier to figure out what is going on.
CREATE TABLE #orders (order_id INT,...
September 25, 2012 at 1:35 pm
yuvipoy (9/24/2012)
I have an assignment to check the consistency of SQL server database for different conditions.I am having some 200+ columns i a table i need to populate data...
September 25, 2012 at 12:27 pm
sathiyan00 (9/24/2012)
i have to move invalid records(data type mismatch) from excel into error log and have to process only valid records.
But...
September 25, 2012 at 12:26 pm
komal145 (9/25/2012)
Msg 245, Level 16, State 1, Line 7
Conversion failed when converting the varchar value 'd1867 ' to data type int.
Below is...
September 25, 2012 at 12:18 pm
sqlguy-736318 (9/25/2012)
Check constraints seem good for enforcing constraints at the table level. Putting validation at other levels does not prevent a user...
September 25, 2012 at 12:10 pm
jrichards54 (9/25/2012)
September 25, 2012 at 12:04 pm
ChrisM@Work (9/25/2012)
dwain.c (9/24/2012)
Sean Lange (9/24/2012)
September 25, 2012 at 11:32 am
rpouwels (9/25/2012)
I am trying to import the data in to Access from an SQL Server Database.
I already have the data imported, but Access keeps bugging me with the location...
September 25, 2012 at 11:25 am
mick burden (9/25/2012)
September 25, 2012 at 11:20 am
rpouwels (9/25/2012)
I am trying to fetch some data from an SQL Server Database.
I have a query, but it keeps prompting for credentials.
SELECT Invoices.NavisionInvoiceNumber, Invoices.NavisionInvoiceDate, Invoices.NavisionCustomerNumber, Invoices.NavisionCustomerName, Invoices.NavisionTotalDeliveries, Invoices.FilesDistributed, Invoices.IsComplete,...
September 25, 2012 at 8:01 am
Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1363952-391-1.aspx
September 25, 2012 at 7:58 am
Viewing 15 posts - 10,591 through 10,605 (of 15,381 total)