Viewing 15 posts - 271 through 285 (of 1,048 total)
one more link of forum:
http://www.sqlservercentral.com/Forums/Topic401606-444-1.aspx
August 17, 2013 at 1:58 am
you can refer this link-
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31896/
August 17, 2013 at 1:57 am
its better to use a table valued parameter and passed to SP
August 17, 2013 at 1:45 am
Very good question....
There is a lil confusion to me....
When the second batch gets executed the Stored procedure created successfuly, as according to deferred name resolution process when an entry is...
August 16, 2013 at 12:50 am
good points Gail...
Thanks 🙂
August 14, 2013 at 8:04 am
Can you please provide some more detailed information about your probem?
August 14, 2013 at 7:39 am
you can also try using ESCAPE -
SELECT s.name
FROM sys.objects s
WHERE
s.type= 'U'
AND s.name LIKE '%!_%' ESCAPE '!'
August 14, 2013 at 6:23 am
Dineshbabu (8/14/2013)
kaspencer (8/14/2013)
August 14, 2013 at 5:24 am
Lokesh Vij (8/13/2013)
Ah! Very simple question to start the day. Thanks Gary:-)
+1 🙂
August 13, 2013 at 11:46 pm
fgrubercpa (8/12/2013)
Pulled Up Tablet View (Management Studio displays), right-clicked and clicked option 'open in folder', then I was able to see the program in a folder (which...
August 13, 2013 at 12:12 am
Sean Lange (8/7/2013)
And even worse...what are going to do when the column is not wide enough to hold the current value plus this new string?
In this case I will change...
August 7, 2013 at 8:54 am
Sean Lange (8/7/2013)
kapil_kk (8/7/2013)
Sean Lange (8/7/2013)
like this?
update table1 set Name1 = '!@#$%^&*()' + Name1
In this manner, but only for those tables who has column of varchar types.....
Are you trying to...
August 7, 2013 at 8:49 am
Viewing 15 posts - 271 through 285 (of 1,048 total)