| Calendario |
| | l | m | m | g | v | s | d |
|---|
| 25 | 26 | 27 | 28 | 29 | 30 | 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 | 31 | 1 | 2 | 3 | 4 | 5 |
|
|
 Serialize Object to string
Serialize 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
|
| Archivio Posts | |
Anno 2020
Anno 2018
Anno 2015
Anno 2013
Anno 2011
Anno 2010
Anno 2009
Anno 2008
|
| Statistiche |
- Views Home Page: 15.070
- Views Posts: 58.204
- Views Gallerie: 2.837
- n° Posts: 117
- n° Commenti: 1
|
|