To Open Port in Firewall at Azure On the Start menu, click Run, type WF.msc, and then click OK. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane. In the Rule Type dialog box, select Port, and then clic...
Insert Result Of Another Store Procedure CREATE TABLE #Result ( Status nvarchar(100), Id INT, Name nvarchar(200) ) INSERT INTO #Result EXEC dbo.rpt_get_result @id,@filter Insert Result of Dynamic Query CREATE TABLE #Result ( Status nvarchar(100), ...
To Compatible Transact-SQL and query processing behaviors with the specified version of the SQL Server Database Engine. -- To check the compatibility level: select compatibility_level from sys.databases where name = '' -- To set the compatibility level: alter database database_name...
SQL Server 2012 or above versions SELECT TOP 1 FORMAT (GETDATE(), 'd', 'en-us') --US -MM/DD/YYYY SELECT TOP 1 FORMAT (GETDATE(), 'd', 'fr-FR') --FR -DD/MM/YYYY SELECT TOP 1 FORMAT (GETDATE(), 'd', 'ja-JP') --JP -YYYY/MM/DD SELECT TOP 1 FORMAT (GETDATE(), 'D', 'en-us') --...
Store Procedure / Tables Updated in Last 30 Days select dateadd(day, -30, getdate()) ,* from sys.objects where (type = 'P' ) and modify_date > dateadd(day, -30, getdate()) and name like '%Table_Name%' order by modify_date desc NOTE- Use U for User Defined Ta...
Check if Match Foundpublic Student GetStudentDetails(int id) { using (DbContextModel _db = new DbContextModel()) { var result = _db.student.Where(x => x.is_active && !x.is_deleted).Select(x => new StudentModel { id = x.id, mode = x.status.ToString().Contains("paid") ...
1. ANY Method Returns a Boolean value. Returns True even if a single element satisfies the condition. Return False if none of the elements satisfies the condition.. Linq to sqlpublic bool CheckStudents() { bool check = false; using (DbContextModel _db = new DbContextModel()) ...