IT Nota

  • Home
  • How To
  • .NET
  • WordPress
  • Contact

Format SQL Using Redgate SQL Prompt

As a follow-up of the post String Literals as Column Aliases are Deprecated, this one feature from Redgate's SQL Prompt is quite handy to correct any existing SQL scripts quickly. Using the SQL from How to Find All References to an Object in a SQL Server Database as an example, here's what we originally have: Pay attention to the object name within the single quotes as a column … [Read more...]

December 14, 2022 Filed Under: How To Tagged With: Microsoft SQL Server, SQL, SQL Server

String Literals as Column Aliases are Deprecated

Something that's still found in SQL scripts in enterprise environment, even with newly written scripts is the use of string literals as column aliases. Although this feature has been deprecated since 2012, old habits die hard. So what's the right way to write it? You can either use alias without a whitespace or use a double quote character. Either of these examples below is … [Read more...]

December 9, 2022 Filed Under: Database Tagged With: Microsoft SQL Server, SQL, SQL Server

How to Find All References to an Object in a SQL Server Database

You can use the following scripts to find all affected objects that make any references to your search term. You can either use sql_modules or syscomments to accomplish this purpose. Generally, they should give you the same results, but from time to time, I found that they may give you slightly different results and I haven't had the chance to look closer how big the difference is. Just to keep … [Read more...]

July 7, 2022 Filed Under: How To Tagged With: Microsoft SQL Server, SQL, SQL Server

How to Get Table Definition in SQL Server

Whenever you need to pull a quick definition of a table in SQL Server. Here's the SQL command (T-SQL) to get the table definition in a database: The result would be something similar to this: COLUMN_NAME DATA_TYPE IS_NULLABLE AccountNo int(10,0) YES AccountName varchar(50) YES Balance money(10,2) … [Read more...]

January 21, 2020 Filed Under: How To Tagged With: SQL, SQL Server

How to Import IIS Log to PostgreSQL

If you ever had a need to dump and analyze IIS logs from a database, this post will show you how to do it in PostgreSQL RDBMS. The assumption is that you're already familiar with the default installation and setup of PostgreSQL, if not please check the manual link at the bottom of this post. We will use default settings. Steps to Create IIS Log Table and Import Log File to PostgreSQL Create … [Read more...]

March 20, 2019 Filed Under: How To Tagged With: IIS, Internet Information Services, PostgreSQL, SQL

  • 1
  • 2
  • 3
  • 4
  • Next Page »
Buy me a coffee Support this site
Buy Me a Coffee?

Categories

  • .NET
  • Coding
  • Cybersecurity
  • Database
  • How To
  • Internet
  • Multimedia
  • Photography
  • Programming
  • Resources
  • Review
  • Tips and Tricks
  • Use Case
  • WordPress
  • Writing

Recent Posts

  • How to Delay Shutdown or Restart on a Mac
  • How to Activate Built-in Web Server
  • SSIS Best Practice with Naming Conventions
  • How to Delay Shutdown or Restart on a Windows Server
  • How to Type Emoji Using Keyboard Shortcuts in Windows and macOS

Recent Posts

  • How to Delay Shutdown or Restart on a Mac
  • How to Activate Built-in Web Server
  • SSIS Best Practice with Naming Conventions
  • How to Delay Shutdown or Restart on a Windows Server
  • How to Type Emoji Using Keyboard Shortcuts in Windows and macOS

Tags

.NET ASP.NET Cdonts Dll Classic ASP Code Editor ETL FSharp Genesis Framework Git Google HP Asset Manager HTML5 Hugo IIS Information Security Internet Internet Information Services iOS JAMStack JavaScript Linux macOS Microsoft Microsoft SQL Server MVC PHP PowerShell Python Simple Mail Transfer Protocol Smtp Server SQL SQL Server SSIS SSMS SSRS Sublime Text Visual Studio Visual Studio Code VPN Web Server Windows Windows 8 Windows 10 Windows 2012 Windows Server

Copyright © 2011-2023 IT Nota. All rights reserved. Terms of Use | Privacy Policy | Disclosure