Viewing 15 posts - 481 through 495 (of 3,221 total)
CREATE TABLE #Yaks (
YakID int,
YakName char(30) )
select name
from tempdb..sysobjects
where name like '#yak%'
Read this:
http://www.sqlteam.com/article/temporary-tables
Now I ran the code from the above, using two separate connections and this was my results:
#Yaks___________________________________________000000000035
#Yaks___________________________________________000000000033
So...
April 29, 2012 at 7:13 pm
Here this works for me.
SELECT Name,REVERSE(right(REVERSE(Name),12)) from sys.databases
model model
msdb ...
April 29, 2012 at 2:37 pm
Tara-1044200 (4/29/2012)
Not sure if understood you guys correctly ?
It depends
I used a table to illustrate what could/would happen when using just the LEN function. Please review what I...
April 29, 2012 at 12:49 pm
For triggers read this.
http://msdn.microsoft.com/en-us/library/ms189799.aspx
2) Can you delete a parent table record if there is a child table record exits ? How ?
Suggest you use google to search for "Cascade delete"
April 29, 2012 at 12:42 pm
Phil Parkin (4/29/2012)
Here is a sample: I guessed what Tara-1044200 was attempting to do.
Indeed & a fair guess. But her post immediately after your suggestion seemed to indicate that things...
April 29, 2012 at 12:11 pm
Phil Parkin Posted Today @ 1:29 PM
Now perhaps you would post your code which proves it does not?
Here is a sample: I guessed what Tara-1044200 was attempting to...
April 29, 2012 at 11:47 am
This may be your problem
CREATE TABLE #T (Name1 VARCHAR(20))
INSERT INTO #T
SELECT 'ABCDEFGHIJKLMNOP' UNION ALL
SELECT 'ABCDEFGHIJKL' UNION ALL --12 characters
SELECT 'XYZ'
SELECT DATALENGTH(Name1) AS 'Datalenth' FROM #T
Returned:
Datalength
16
12
3
For the two shorter entries...
April 29, 2012 at 9:19 am
Jeff Moden (4/26/2012)
TheSQLGuru (4/25/2012)
Hey Jeff, can you put a downloadable file with the relevant operational code parts of the post? Thanks in advance, and wonderful stuff as always!
If I...
April 28, 2012 at 4:02 pm
Nice simple/easy question to start the week ...........THANKS
April 28, 2012 at 2:10 pm
Microsoft has available (for free) Upgrade Advisor software which you can run before attempting the upgrade... it will advise you of most problems which you might encounter.
http://www.microsoft.com/en-us/download/details.aspx?id=11455
April 28, 2012 at 9:06 am
WayneS (4/27/2012)
For those that would like a...
April 27, 2012 at 9:53 am
Steve Jones - SSC Editor (4/26/2012)
April 26, 2012 at 2:15 pm
Alas and alack, a day late and a dollar short, but I ran across this article today, and it might be what is needed.
The author is: By: K. Brian...
April 25, 2012 at 8:48 am
SceloM (4/25/2012)
So having a check for char(9), char(10) and char(13) should cover me for the spaces?
I have implemented the function on my full query and seems to be working...
April 25, 2012 at 8:37 am
Here is a general method to determine what that last character is.
[DECLARE @A2 VARCHAR(50)
SET @A2 = 'GAUTENG EAST 1'
--The @A2 has a horizontal tab as the last...
April 25, 2012 at 7:55 am
Viewing 15 posts - 481 through 495 (of 3,221 total)