Viewing 15 posts - 796 through 810 (of 1,048 total)
easy one for NULL 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 27, 2012 at 5:21 am
Very good question to start of the week with joins 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 26, 2012 at 2:45 am
nice question for the week..
+1 🙂
learn about STUFF today
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 26, 2012 at 12:41 am
sp_rename 'tablename.[columnname],'column_name'
it will works 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 23, 2012 at 9:40 am
how to post query in this format?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 23, 2012 at 6:26 am
I create this one and it works- :-):-)
update PC
set pc.account =p.patientID
from PatientLocDtl pc
join patientlocdtl p on left(p.ChartNo,len(SUBSTRING(p.ChartNo,PATINDEX('%-%',''),len(p.ChartNo))))=left(pc.ChartNo,len(SUBSTRING(pc.ChartNo,PATINDEX('%-%',''),len(pc.ChartNo))))
where right(p.chartno,1) like '[0-9]'
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 23, 2012 at 6:24 am
hey, I am done with this....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 23, 2012 at 6:06 am
this is not the the question of the standard of SQl Server central
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 22, 2012 at 11:59 pm
i dont think this type of question should be asked in this forums..
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 22, 2012 at 11:58 pm
nice question and nice explanation by Hardcoder 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 22, 2012 at 11:56 pm
:-):-D:-P
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 22, 2012 at 11:46 pm
easy one..
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 22, 2012 at 11:39 pm
Hey I am able to create sp_who to a schema specific.. and it result whatever i wrote in stored procedre no other information is showing as it shows when run...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 22, 2012 at 4:17 am
i tried to created a stored procedure schema specific for sp_who but am not able to create that...
can you plz tell me how to create procedure specific to a schema...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 22, 2012 at 4:07 am
easy one for the day...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 22, 2012 at 3:41 am
Viewing 15 posts - 796 through 810 (of 1,048 total)