Start Index No With 1 Sql Query Reseed Auto increment

No comments
DBCC CHECKIDENT ('TabelName', RESEED, 0);

No comments :

Post a Comment

Website Testing Site (Responsive)

No comments

No comments :

Post a Comment

Handle Page not Found in Dot net 404 with webconfig

No comments
<configuration>
    <system.web>
      <compilation debug="false" strict="false" explicit="true" targetFramework="4.5" />
      <httpRuntime targetFramework="4.5" />
         
    <customErrors mode="On" defaultRedirect="~/page_not_found.aspx" >
   
    </customErrors>
     
    </system.web>
  <system.webServer>
    <httpErrors errorMode="Custom">
      <remove statusCode="404"/>
      <error statusCode="404" path="/page_not_found.aspx" responseMode="ExecuteURL"/>
    </httpErrors>
  </system.webServer>
<appSettings>
    <add key="ValidationSettings:UnobtrusiveValidationMode" value="None" />
  </appSettings>

</configuration>

No comments :

Post a Comment

Generate Random Number in SQL Numeric and Password / String

No comments
Random Number

SELECT ABS(CHECKSUM(NewId())) % 10000 AS [NewID]

SELECT ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) AS [RandomNumber]

select FLOOR(RAND(CHECKSUM(NEWID()))*(99999-10000)+10000) as [newiy]

Random String

SELECT NEWID() AS [NewID]

No comments :

Post a Comment