Mr WordPress on Hello world!
Author Archives: lindaf10
If I GRANT SELECT (or UPDATE/INSERT/DELETE) permissions to a user, then they can use those permissions to view data in a table. If I REVOKE the permissions, it’s the same as if the user never had them. They would need … Continue reading
Copy and paste the script in a database to analize, then replace de variable @tblName with the table name to analize and execute /************ Identify all columns of all indexes on a table***********/ DECLARE @tblName AS sysname select @tblName =’TABLE_NAME’ … Continue reading
This article is going to cover the newly introduced data types in SQL Server 2008. The DATETIME function’s major change in SQL Server 2008 is the four DATETIME data types introduced. They are DATE, TIME, DATETIME2 and DATETIMEOFFSET. DATE Data Type … Continue reading