Viewing 15 posts - 2,866 through 2,880 (of 3,221 total)
Pardon me but this sounds like a homework problem. One option look at REDGATE Software's product at:
September 12, 2008 at 10:03 am
Suggest you read this in BOL and see how isolation levels effect data integrity and make your decision(s) based on that
Adjusting Transaction Isolation Levels
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9dfc3c68-9bf0-4896-b3b6-d2f1a601ead1.htm
September 12, 2008 at 9:34 am
Believe this will handle both "Jones, Jack" and "Jones Jack" equally as well.
DECLARE @WritersNames AS VARCHAR(50)
DECLARE @Pos AS INT
SET @WritersNames = 'Jones Jack'
SET @Pos = (Select charindex(',',@Writersnames,1))
IF (@Pos = 0)...
September 11, 2008 at 9:20 pm
Use SELECT CAST(@myval AS DECIMAL(10,2))
For example:
DECLARE @myval AS FLOAT
SET @myval = 123.45678
SELECT CAST(@myval AS DECIMAL(10,2))
result: 123.46 (note the rounding)
Next example:
DECLARE @myval AS FLOAT
SET @myval = 565
SELECT CAST(@myval AS DECIMAL(10,2))
result...
September 11, 2008 at 2:09 pm
Jacob:
But why has this been so hard? I thought connecting to different DBMS was supposed to be quite seamless.
With Windows authorization:
Use my sample code and connection is relatively simple...
September 11, 2008 at 11:59 am
Autonumber is an Access term, what you may mean in SQL is termed an Identity column - which contains a number unique within that table and incremented each time a...
September 10, 2008 at 5:59 pm
For my own self editication I created a table and loaded your data and then developed a CTE to identify all the duplicate entries in what was your Column 5....
September 10, 2008 at 3:37 pm
Jacob, well I again checked my incoming PM box, nothing, oh well will leave this subject (forum) open so I will recieve a message saying that some one posted to...
September 10, 2008 at 3:11 pm
Jacob did you get my Private Message to you.
First of all the App user does NOT have to login to SQL Server and/or the database, as long as the database...
September 10, 2008 at 2:29 pm
To assist others who desire to help you please read the article in my signature block and post your question accordingly, that is the table schema, test/sample data as an...
September 9, 2008 at 7:41 pm
How about this policy. IT workers (Programmers, developers, DBAs) were classified as "Salaried/Exempt". Which meant you were not paid overtime, or given comp time off. Now if...
September 9, 2008 at 9:35 am
To select just the month, that is data to the left of the first comma try this code to give you an idea of what you can do:
DECLARE @FM as...
September 8, 2008 at 7:01 pm
Heather then like Steve Jones' recommendation
Read the articles by Jeff Moden. He covers some great basics you might want to avoid.
. Limit your reading to Jeff's work...
September 8, 2008 at 3:44 pm
Laura
The vendor has asked that I send the database to them so they can more accurately estimate the cost of conversion.
Perhaps a dumb question on my part but are you...
September 8, 2008 at 3:40 pm
probably can't post my sql, so that is why i'm giving a description of my queries.
Extremely difficult to make any meaningfully suggestions with such meager information. Can...
September 8, 2008 at 3:23 pm
Viewing 15 posts - 2,866 through 2,880 (of 3,221 total)