Can you or can you not pass parameters to a view? Well, the short answer is no. A view is seen by the database (and should be considered by us) as a table.
Read article: Pass parameters to View in SQL or Oracle →
Writing SQL queries can be considered by some as a form of art: everyone has a different style of writing and improving them (I’m talking about complex queries). Queries can achieve the same goal while being…
Read article: Make optimization to SQL query with SQL Server Management Studio →
As part of my daytime job, I conduct professional interviews for candidates. For that, I’m always on the search for good interview questions. I regard a good question if it’s not too complicated, has a…
Read article: Interview Question: Select only Prime numbers from table →
Have you ever wanted to create a copy of a database table, programmatically? Could be a part of a stored procedure as a temporary table, or just a quick way of duplicating structure and constraints of…
Read article: Quick Tip: Create a copy of a database table MSSQL programmatically →