Viewing 15 posts - 271 through 285 (of 1,048 total)
one more link of forum:
http://www.sqlservercentral.com/Forums/Topic401606-444-1.aspx
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 17, 2013 at 1:58 am
you can refer this link-
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31896/
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 17, 2013 at 1:57 am
its better to use a table valued parameter and passed to SP
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 16, 2013 at 12:50 am
good points Gail...
Thanks 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 14, 2013 at 8:04 am
Can you please provide some more detailed information about your probem?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 '!'
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 14, 2013 at 6:23 am
Dineshbabu (8/14/2013)
kaspencer (8/14/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 14, 2013 at 5:24 am
Lokesh Vij (8/13/2013)
Ah! Very simple question to start the day. Thanks Gary:-)
+1 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 13, 2013 at 11:46 pm
:-)Excellent Question........
Thanks a lot
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 13, 2013 at 6:32 am
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 13, 2013 at 12:12 am
good and easy one....
thanks 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 8, 2013 at 6:07 am
Koen Verbeeck (8/7/2013)
Very nice question. Thanks.
+1 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 8, 2013 at 1:07 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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 7, 2013 at 8:49 am
Viewing 15 posts - 271 through 285 (of 1,048 total)