|
|
-
Alpesh Patel Learned 6 Months ago through Just Learned
We can easily restrict the access of database using Logins but to hide it's tough.
SQL Server has feature to hide all databases from SSMS.
To do that follow the steps.
1. Create or Go to Property of existing Login.
2. Move to Securable tab.
3. In ...
|
-
Alpesh Patel Liked 6 Months ago through Just Learned
BI Helper tool is good for BI Developers for the purposes like
1. Bulk Property update in SSIS
2. Visualize the performance and design error of SSIS package.
3. Compare to Reports/Packages etc in BIDS/SSDT.
4. Report for Used and unused columns in S...
|
-
Alpesh Patel Learned 6 Months ago through Just Learned
BI Helper tool is good for BI Developers for the purposes like
1. Bulk Property update in SSIS
2. Visualize the performance and design error of SSIS package.
3. Compare to Reports/Packages etc in BIDS/SSDT.
4. Report for Used and unused columns in S...
|
-
Alpesh Patel Posted 6 Months ago through Just Learned
BI Helper tool is good for BI Developers for the purposes like
1. Bulk Property update in SSIS
2. Visualize the performance and design error of SSIS package.
3. Compare to Reports/Packages etc in BIDS/SSDT.
4. Report for Used and unused columns in SSAS...
|
-
Alpesh Patel Posted 6 Months ago through Just Learned
We can easily restrict the access of database using Logins but to hide it's tough.
SQL Server has feature to hide all databases from SSMS.
To do that follow the steps.
1. Create or Go to Property of existing Login.
2. Move to Securable tab.
3. In per...
|
-
Alpesh Patel Commented 6 Months ago through Just Learned
You can take column names by pressing help for Table and get all Columns from there....
|
-
Alpesh Patel Liked 6 Months ago through Just Learned
Goto www.google.com, type 3+4 in the search text box and press enter. You can also do something like 12*(5+5)-12/4......
|
-
Alpesh Patel Learned 6 Months ago through Just Learned
Goto www.google.com, type 3+4 in the search text box and press enter. You can also do something like 12*(5+5)-12/4......
|
-
Alpesh Patel Liked 6 Months ago through Just Learned
The Format is the new function to format string.
i.e. If you wish to format date in you desire format then.
SELECT FORMAT(sysdatetime(),'yyyyMMdd')...
|
-
Alpesh Patel Learned 6 Months ago through Just Learned
The Format is the new function to format string.
i.e. If you wish to format date in you desire format then.
SELECT FORMAT(sysdatetime(),'yyyyMMdd')...
|