| Calendario |
| | l | m | m | g | v | s | d |
|---|
| 28 | 29 | 30 | 31 | 1 | 2 | 3 | | 4 | 5 | 6 | 7 | 8 | 9 | 10 | | 11 | 12 | 13 | 14 | 15 | 16 | 17 | | 18 | 19 | 20 | 21 | 22 | 23 | 24 | | 25 | 26 | 27 | 28 | 29 | 30 | 1 | | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
|
|
 Cursor
Esempio di come usare un cursore:DECLARE @opttype TABLE (code varchar(100),name varchar(300),systemoid varchar(300),description varchar (500),virtual bit,isdigitalized bit,isexternal bit )insert into @opttype (Code,Name,SystemOid,Description,Virtual,IsDigitalized,IsExternal) values('18','internal','test','',0,0,0),('30','internal','test','',0,0,0),('80','internal','test','',0,0,0),('81','internal','test','',0,0,0),('82','internal','test','',0,0,0)DECLARE @code varchar(100),@name varchar(300),@sy  Leggi tutto il post...
 giovedì, 11 giu 2020 Ore. 12.26
Serialize Object to stringSerialize Object to string public static string Serialize(object o, Type T)
{
//this avoids xml document declaration
XmlWriterSettings settings = new XmlWriterSettings()
{
Indent = false,
OmitXmlDeclaration = true
};
var stream = new MemoryStream();
using (XmlWriter xw = XmlWriter.Create(stream, settings))
{
//this avoids xml namespace declarati Leggi tutto il post...
 Categoria: C# martedì, 23 gen 2018 Ore. 12.07
Sql Function Return varcharSql Function Return varcharCREATE FUNCTION SchemaName.GetValuesCommaSeparated( @Id int)RETURNS varchar(100) -- or whatever length you needASBEGIN declare @values as varchar(100)declare @result as varchar(100) ='' DECLARE cursorValues CURSOR FOR select T.ColumnName from SchemaName.TableName T where T.ID = @Id --OPEN CURSOR. OPEN cursorValues --FETCH THE RECORD INTO THE VARIABLES. FETCH NEXT FROM cursorValues INTO @values Leggi tutto il post...
mercoledì, 10 gen 2018 Ore. 10.33
BACKUP DATABASEBACKUP AND RESTORE sintaxBACKUP DATABASE [dbname] TO DISK = N'D:\Database\Backup\20180102_dbname.bak' WITH COPY_ONLY, NOFORMAT, INIT, NAME = N'dbname-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10GOdeclare @backupSetId as intselect @backupSetId = position from msdb..backupset where database_name=N'dbname' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'dbname' )if @backupSetId is null begin raiserror(N'Verify failed. Ba Leggi tutto il post...
martedì, 09 gen 2018 Ore. 11.19
Install UtilInstallare un servizio WindowsC:\Windows\Microsoft.NET\Framework64\v4.0.30319>installutil /ServiceName="Service_Test" "C:\Program Files\Test\Services\Service.exe"installutil /u /ServiceName="Service_Test" "C:\Program Files\Test\Services\Service.exe" Leggi tutto il post...
martedì, 02 gen 2018 Ore. 14.45
|
| Archivio Posts | |
Anno 2020
Anno 2018
Anno 2015
Anno 2013
Anno 2011
Anno 2010
Anno 2009
Anno 2008
|
| Statistiche |
- Views Home Page: 11.787
- Views Posts: 56.339
- Views Gallerie: 2.837
- n° Posts: 120
- n° Commenti: 1
|
|