Viewing 15 posts - 2,836 through 2,850 (of 3,221 total)
Erin
I am trying to pull a field where if the data value has 8 characters, strip off the first and last character. If data value has 6 characters, leave...
September 24, 2008 at 2:29 pm
Perry.Pierce for a fuller explanation of the LIKE comparison read
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/581fb289-29f9-412b-869c-18d33a9e93d5.htm
It shows in detail other possible matching patterns that make LIKE a potent search tool in a SELECT statement.
Now a question...
September 23, 2008 at 1:37 pm
I would like to thank all who have commented. I have learned a little more to apply to any additional QOD that I may submit. Please note that...
September 23, 2008 at 6:35 am
Have you examined the @@IDENTITY function check BOL for a complete description.
insert into PERSON (PARTYID, NAME, DOB, DATE_TIME_CREATED, DATE_TIME_MOD)
values(@PARTYID, @NAME, @DOB, GETDATE(), GETDATE())
SET @Key = @@Identity
Got carried away here and...
September 21, 2008 at 3:00 pm
You might want to read the description for SYS.SYSTEM_COLUMNS catalog view in Books On Line. It contains the max_length for columns expressed in bytes. It does not have...
September 21, 2008 at 2:30 pm
This returns a single recordset ... and might be what you are looking for
took this example from BOL
USE AdventureWorks;
GO
SELECT
RANK() OVER(ORDER BY SalesYTD DESC) AS...
September 21, 2008 at 9:54 am
Great question ..Now for a trival comment the link shown for the correct answer
Displays a MSDN page titled Using SQL Server Profiler:
However this link http://msdn.microsoft.com/en-us/library/ms188786.aspx yields sys.server_prinicipals(Transact-SQL) produces from BOL...
September 21, 2008 at 8:56 am
In my install I found it at:
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SQLwb.exe
must say that it did display when I clicked "Start", then "Programs" expanded programs, as one normally would, and SQL...
September 21, 2008 at 7:55 am
The only help I can provide and it is not much, have you reviewed the Codeplex project on msspatial extensions, which apparently exists because of 2005's ability to support Common...
September 21, 2008 at 7:38 am
i don't have anything else to post.
i'm not asking to be spoon fed, just a suggested best stratgey i'll google myself from there
A ha so you did post some more...
September 20, 2008 at 7:49 pm
To help those who can help you.... please follow the posting protocol as covered by the article in my signature block.. Thanks
September 20, 2008 at 6:23 pm
Although not a direct answer to your question you might want to visit Books On Line for SQL Server 2008 in which Microsoft introduced the Hierarchical data type. This...
September 19, 2008 at 5:57 pm
Tongue in cheek when I say this:
Luke L .. for shame, for shame. Just
imagine what would happen to the Forums if they
followed your recommendation. If memory servers
me correctly...
September 19, 2008 at 5:35 pm
Your posted reference refers to SQL 2000 and you have posted your question to a SQL 2005 forum. There are many debugging tools available for specific functions in SQL...
September 19, 2008 at 5:19 pm
Bpowers:
Do I just set the seed to correspond to the first record in my spreadsheet?
Identity values are normally automatically incremented when a row is added to a table. Why...
September 19, 2008 at 4:38 pm
Viewing 15 posts - 2,836 through 2,850 (of 3,221 total)