Posts by WizardDBA • 106 points
7 posts
-
0
votes3
answers2025
viewsA: How to save a Base64 image to SQL and save it locally as PNG
If you really want to do this storage in your database you can use one of the two options: In case you are sure that the image will not have more than 2GB stores with Varbinary(max) If this space…
-
0
votes1
answer40
viewsA: SQL Server 2008 Managment Objects: Can I uninstall?
Hello, Vitor can uninstall without any problem, will not impact the SQL engine. As you say in Microsoft SMO SQL Server Management Objects (SMO) are Objects Designed for programmatic management of…
sql-server-2012answered WizardDBA 106 -
1
votes2
answers685
viewsA: Schema permission in specific user
In a simple way it will be so: GRANT TAKE OWNERSHIP ON SCHEMA::Person TO USER_1 You need to see what level of permissions you want to give to the user in question, you can remove all doubts in this…
-
0
votes2
answers54
viewsA: hierarchyid, remove children from one node and assign to another node
Hello Gabriel for what I understood of your question I would not do the way you are executing, I would make a very different tsql but that executes what you want, now repairs I will present my…
-
1
votes1
answer49
viewsA: I can’t give a Grant in a schema
Basically what he is telling you is that you are trying to give permissions to a USER who already has such permissions or you are running Grant with the user context you want to give permission to.…
-
1
votes1
answer2043
viewsA: What is the difference between OUTER APPLY and INNER JOIN in Sql Server?
An OUTER APPLY what you will do is return to null the fields in which there is no match. While Inner Join does not return, it only returns values where there is matching. Null values are not…
-
3
votes1
answer80
viewsA: SQL is importing dates in different format
When you perform SELECT use the following syntax: SELECT CONVERT(VARCHAR(23), GETDATE(), 121) Replace function getdate() by the name of the column you want to convert.…