How to write character string constants or literals in ms sql server?
- 1 Answers
- 1099 Views
- I also Faced
- E-Mail Answers
Answer / Akash Gupta
In MS SQL Server, you can write character string constants or literals by enclosing them within single quotes ('). For example: 'Hello World'.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can you list all the columns in a database?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
List the ways in which dynamic sql can be executed?
What is row by row processing ?
How can you get @@error and @@rowcount at the same time?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What is service broker? : sql server database administration
What is difference between global temporary tables and local temporary tables?
How to declare and use cursor variables?
What are “lost updates”?
What are mdf,ndf,ldf files and how to see the data in those files?
What are the four main query statements?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
