T-SQL user guide
==================== Calcul d’ un max d’ un champs ==================== Unicode = 2 caractères SQL Server also has a DATALENGTH() function. This function can be used on all data types (Text, NText or Image data...
Category: SQL Server
Constraints and Referential Integrity in SQL Server
Constraints Constraint specifications add additional restrictions on the contents of the table. They are automatically enforced by the DBMS. The columnconstraints are: NOT NULL — specifies that the column can’t be set to null....
How to list constraints in an sql server database?
Execute the following Microsoft T-SQL example scripts in SQL Server Management Studio Query Editor to list all or specific CHECK constraints in AdventureWorks database. ———— — Microsoft SQL Server T-SQL list all check constraints...
SQL Server : Index data (cluster)
Il ne peut y avoir qu’un seul index clusterisé par table. Les données de la table sont logiquement triées dans l’ordre de l’index clusterisé, ce qui explique qu’il n’y en a qu’un seul. Autrement...
How to empty a SQL Server database transaction log file
I have 1 GB databases that grow several GB log files. Well, probably the best practice includes backing them up. That was overkill for me, and sifting through all the documentation and forums (eventually)...
Sauvegarde automatique SQL Server Express 200X
1- Commande T-SQL de Sauvegarde à stocker dans un fichier sur C:backup.sql : BACKUP DATABASE [DB_DATA] TO DISK = N’E:Srvper-Fullcrumdbdata‘ WITH NOFORMAT, INIT, NAME = N’LOGICAL_DATAS’, SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO ...
