SQL Server does not help to easily determine the dependencies between tables.
This research presents the parent table and the child tables and columns used.

https://msdn.microsoft.com/en-us/library/ms179610.aspx
http://stackoverflow.com/questions/925738/how-to-find-foreign-key-dependencies-in-sql-server
 

well, however, we have many databases with bad design that didn’t have foreign keys defined but that did have related data.

Lire la suite de Finding Table and Primary Key and Foreign Key

Existe enumeras maneiras de baixar musicas do youtube.

Metodo zero instalação: Não precisa instalar nada. O processo se resume em copiar o endereço do video e usar um site que converte o video para ser baixado.

http://www.youtube-mp3.org/

Estes outros sites funcionam basicamente da mesma maneira.
http://savedeo.com/
http://savefrom.net/
https://www.dredown.com/youtube
http://www.clipconverter.cc/
http://deturl.com/
http://keepvid.com/
http://www.tubeoffline.com/

Lire la suite de Metodo 1 - como baixar musica do Youtube

Après restaure la base de données MS SQL, il est possible que certains utilisateurs de la base de données soient orphelins. Alors, voici les SQL scripts pour les réparer.

Répare tous les utilisateurs orphelins de toutes bases de données:

DECLARE @sql as nvarchar(max);
SET @sql = '
USE[?];PRINT''Database: ''+db_name();DECLARE @username VARCHAR(25);DECLARE
GetOrphanUsers CURSOR FOR SELECT UserName=NAME FROM sysusers WHERE issqluser=1AND(sid IS
NOT NULL AND sid<>0x0)AND SUSER_SNAME(sid)IS NULL ORDER BY NAME;OPEN GetOrphanUsers;FETCH
NEXT FROM GetOrphanUsers INTO @username;WHILE @@FETCH_STATUS=0BEGIN IF @username=''dbo''
EXEC sp_changedbowner''sa'';ELSE BEGIN BEGIN TRY EXEC sp_change_users_login''update_one''
,@username,@username;END TRY BEGIN CATCH PRINT''Fail to fix database user: ''+@username;END CATCH
;END FETCH NEXT FROM GetOrphanUsers INTO @username;END;CLOSE GetOrphanUsers;DEALLOCATE
GetOrphanUsers;';
EXEC sp_MSforeachdb @sql

Lire la suite de Récuperer les utilisateurs orphelins

Sometimes I want to have control over a SQL Server database, but always some connection blocks.

We can use this

USE MASTER;
ALTER DATABASE MyDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

BUT, sometime, we cannot do it! Well, we have this solution...

SET NOCOUNT ON;
DECLARE @ToKill AS NVARCHAR(max);
SET @ToKill = '';
--SELECT @toKill = @ToKill + 'kill ' + cast(spid AS NVARCHAR(10)) + ';'
SELECT @toKill = @ToKill + 'begin try kill ' + cast(spid AS NVARCHAR(10)) + '; print ''Ok   to kill : ' + cast(spid AS NVARCHAR(10)) + '''; end try begin catch print ''Fail to kill : ' + cast(spid AS NVARCHAR(10)) + '''; end catch;'
FROM master..sysprocesses WHERE
spid <> @@spid -- Not my self
AND dbid = DB_ID(db_name()) -- only my database
--print @tokill;
EXEC (@tokill);

Solution without "DECLARE", it's useful when many times you need to kill connections.

exec('PRINT ''Kill connection of database: '' + db_name();DECLARE @kill AS NVARCHAR (MAX);SET @kill = '''';SELECT @kill = @kill + ''begin try  kill '' + CAST (spid AS NVARCHAR (10)) + ''; print ''''Kill spid: '' + CAST (spid AS NVARCHAR (10)) + '' ('' + RTRIM(ISNULL(hostname, ''*NULL*'')) + ''|'' + RTRIM(ISNULL(nt_username, ''*NULL*'')) + '')'''' ; end try begin catch print ''''Fail to kill : '' + CAST (spid AS NVARCHAR (10)) + ''''''; end catch;'' FROM master..sysprocesses WHERE dbid = DB_ID(db_name()) AND spid <> @@spid AND hostprocess <> '''';PRINT (@kill);');

Chaque fois que je dois créer une application du type console, c'est le même problème.

Alors, je publie la version que je vais utiliser sur toutes mes applications.
Effet, j'ai analysé plusieurs solutions, et détails techniques de chaque solution et j'ai fini pour choisir une solution publiée sur CodeProject.

Ma version de la solution est normalisée selon le standard du Reshaper, et il y a un *petit* changement de l'expression régulier.

using System;

namespace MyConsoleApplication
{
    class Program
    {
        #region Private Static Methods

        private static void HowToUse()
        {
            Console.WriteLine("--------------------");
            Console.WriteLine("Syntax : ");
            Console.WriteLine("");
            Console.WriteLine("MyConsoleApplication /myparam1=value1 /myparamBool /mypar2 /myvalueX=C:\\temp\\");
            Console.WriteLine("");
            Console.WriteLine("--------------------");
        }

        static void Main(string[] args)
        {
            Arguments commandLine;
            commandLine = new Arguments(args);

            //commandLine line : /myparam1=TestValue1   /myparamBool
            if (commandLine["myparam1"].HasValue)
            {
                Console.WriteLine(commandLine["myparam1"].Value);
            }
            Console.WriteLine(commandLine["myparamBool"].ValueBool ? "has parameter" : "no parameter");

            ShowArguments(commandLine);
            WaitConfirmation();
        }

        private static void ShowArguments(Arguments commandLine)
        {
            const string message = @"::
            :: Parameters :
            ::";

            Console.WriteLine(message);
            if (commandLine.Parameters.Count == 0)
            {
                Console.WriteLine("** No parameters **");
                HowToUse();
            }

            foreach (var c in commandLine.Parameters)
            {
                Console.WriteLine("      " + (c.HasValue ? string.Format("/{0}={1}", c.Name, c.Value) : string.Format("/{0}", c.Name)));
            }
            Console.WriteLine("");
        }

        private static void WaitConfirmation()
        {
            Console.WriteLine("\r\nPress a key to continue: ");
            ConsoleKeyInfo cki = Console.ReadKey(true);
        }

        #endregion Private Static Methods
    }
}

Lire la suite de Command Line Arguments Parser