This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.
use dictionary insert into dbo.TblCurrentWordCounts (WordStat_ID, Word, NoOfWords, WordLength, WordPosition, ClientCode, MyDateTimeCol,ClientCodeWordPosition, ClientCodeWordWordCountWordLenPosition) select Word + CONVERT(CHAR(17),GETDATE(),120) AS CurrentDateTime, GETDATE() AS MyDateTimeColWord, Word, NoOfWords, wordlen, WordPosition, ClientCode, ClientCode & '_'& word &'_'& WordPosition, ClientCode & '_ '& word &'_ '& NoOfWords &'_ '& WordLen &'_ '& WordPosition from TblWords where word <>'' and clientcode='210904C' --where word <>'' group by word, NoOfWords, ClientCode, wordlen, WordPosition order by clientcode
|Counting connections to SQL Server through C#||3||29|
|SQL Pivot Rows To Columns||9||22|
|When I execute a stored proc with input parms using SQL Server 2008, I get the following error msg: Msg 8152 String or binary data would be truncated. Do you know how I can resolve this?||1||13|
|SQL Server (2008) Declare Variable (Date) and Set value||6||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
28 Experts available now in Live!