Programming Blog
(Move to ...)
Programming Blogs
Health Blogs
▼
(Move to ...)
Home
▼
Thursday 1 December 2022
Generate SQL script from entity framework using powershell/visual studio
›
to run the below command , start PowerShell in visual studio. Select the database project. In PowerShell: Script-Migration this command wi...
Monday 28 November 2022
Adding custom prerequisite software to Visual studio installer project
›
One of my application require asp.net runtime to be installed in the client system to run the application. Visual studio installer project ...
Thursday 17 February 2022
Raspberry pi: how to find raspberry pi model details
›
In the raspberry pi console type: pinout output: ,--------------------------------. | oooooooooooooooooooo J8 +==== | 1oooooooooooooo...
Wednesday 29 September 2021
How to push changes to github after password authentication is deprecated
›
I tried to check-in some code to my github repository after more than 6 months today. I found that normal username and password for authenti...
Saturday 11 September 2021
simple use of Record in c#9 and newer versions
›
c# 9 introduces a new keyword Record which makes an object immutable. Properties in the record can be initialised at the time of creation o...
init only property in c#9 or later versions
›
c# 9 introduces new Init-Only property that allow to make immutable properties in a class. This means the property with "init" ke...
Friday 14 May 2021
How to check roles for sql users
›
The following query returns the members of the database roles. SELECT DP1.name AS DatabaseRoleName, isnull (DP2.name, 'No ...
Thursday 22 April 2021
Search by keyword in Stored procedure, Views, Functions And Tables
›
CREATE PROCEDURE [ util ].[SearchAll] ( @strFind AS VARCHAR (MAX)) AS BEGIN SET NOCOUNT ON ; --TO FIND STRING IN AL...
Tuesday 20 April 2021
Find table and column name in MSSQL
›
It is time consuming job to browse each and every tables and columns to find required tables and it's even difficult to search columns ...
Thursday 25 February 2021
How to give SQL User access to execute Stored procedures and read/write access to database
›
Assumptions: stored procedures and tables are created under schema dbo. in case different schema, change the below code accordingly. --Cre...
‹
›
Home
View web version