SQL Identifier clause
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 01:28 AM
Hi,
I was trying to prepare some dynamic SQLs to create table using the IDENTIFIER clause and WITH AS clause, but I'm stuck on some bug as it seems.
could someone verify it or tell me that I am doing something wrong?
code is running on SQL Warehouse
Thanks in advance
Case 1 => Create Table Conventional => Success
Case 2 => Create Table using IDENTIFIER clause (without with as clause) => Success
Case 3 => Create Table using IDENTIFIER clause and using WITH AS clause => FAIL
I've tried using brackets around with as and select, didn't help ..
Any suggestions?
#identifier #sql