sql - set alias Name for Table visually -


i want set second name tables not in english letter. , when want insert table name table record, use alias name.

i know in each query can use as set second name, don't want way. want set property of table.

also pls tell me how can access property (alias name) in query.

i found this article, didn't found alias field

thank u

you can view:

create view easyname select * longcomplicatedtablename

so long view represents 1 table underneath, can use crud operations on view.

according msdn, naming restrictions table names follows:

  1. the first character must 1 of following:

    • a letter defined unicode standard 2.0. unicode definition of letters includes latin characters through z , through z, in addition letter characters other languages.

    • the underscore (_), "at" sign (@), or number sign (#). symbols @ beginning of identifier have special meaning in sql server. identifier beginning "at" sign denotes local variable or parameter. identifier beginning number sign denotes temporary table or procedure. identifier beginning double number signs (##) denotes global temporary object.

      some transact-sql functions have names start double @ signs (@@). avoid confusion these functions, recommended not use names start @@.

  2. subsequent characters can be:

    • letters defined in unicode standard 2.0.

    • decimal numbers either basic latin or other national scripts.

    • the "at" sign, dollar sign ($), number sign, or underscore.

  3. the identifier must not transact-sql reserved word. sql server reserves both uppercase , lowercase versions of reserved words.

  4. embedded spaces or special characters not allowed.

  5. supplementary characters not allowed.

when used in transact-sql statements, identifiers fail comply these rules must delimited double quotation marks or brackets.


Comments

Post a Comment

Popular posts from this blog

Android layout hidden on keyboard show -

i have strange problem layout. when tap on edittext , keyboard shown edittext stay on bottom , when tap on to hide keyboard , keyboard hides , edittext go should when want input text. when tap again, keyboard shown , edittext goes down behind keyboard... <relativelayout android:layout_width="match_parent" android:layout_height="match_parent" > <scrollview android:layout_width="match_parent" android:layout_height="fill_parent" android:above="@+id/rl_commands"> <textview android:layout_width="match_parent" android:layout_height="wrap_content"/> </scrollview> <relativelayout android:layout_width="match_parent android:layout_height="24dp" android:id="@+id/rl_commands" android:alignparentbottom="true">
Read more

google app engine - 403 Forbidden POST - Flask WTForms -

i have flask application running on google app engine. trying submit form built using wtform , keep getting following error. 403 forbidden: don't have permission access requested resource. either read-protected or not readable server. location.html (part of code) <form method=post action="/home/location"> .... <button type="submit" class="btn btn-primary" value="submit"> directions </button> </form> main.py @app.route('/home/location', methods=['post', 'get']) def location(): form = cfcdirections.direction(request.form) print(request.method) if request.method == 'post' , form.validate(): print("after if") directions = cfcdirections() street_no = directions.no street = directions.street suburb = directions.suburb postcode = directions.postcode
Read more

c - Why would PK11_GenerateRandom() return an error -8023? -

i looking through internet trying find source of pk11_generaterandom() function see why function fail. have program uses function when moved new flavor of linux, fails after forking ( fork() ) since not believe there problem nss, suspect doing incorrectly disregarded in older versions of linux new 1 there issue. the openssl package same on 'good' , 'bad' server: openssl 0.9.8e-fips-rhel5 01 jul nss rpm differs though. 'good' has nss-3.12.2.0-2.el5 and bas has version nss-3.15.3-4.el5_10 the 'good' server uses quite obsolete linux: linux 2.6.18-128.el5 #1 smp wed jan 21 08:45:05 est 2009 x86_64 x86_64 x86_64 gnu/linux enterprise linux enterprise linux server release 5.3 (carthage) red hat enterprise linux server release 5.3 (tikanga) the 'bad' server newer: linux bad 2.6.18-371.4.1.el5 #1 smp wed jan 29 11:05:49 pst 2014 x86_64 x86_64 x86_64 gnu/linux oracle linux server release 5.10 red hat enterprise linux server release
Read more