Example of using pagination and switch case in where clause in SQL server
Posts Tagged ‘SQL’
How to Resolve error – ORA-28000: the account is locked
Convert rows into comma separated values column – SQL Server
Get Foreign Key related details for the Table in SQL Server
Drop the user define function from database if it exists.
Get the Fort night start and end date on the basis of input provided. if date falls in first 15 day then it will give the First Fort night start and end date and if date falls after 15 day then it gives respective start and end date.
Scalar function to get the first Day and Last day of the Week in SQL Server
Get the first day and last day of the month in SQL Server using Scalar functions
How to drop the stored procedure in SQL Server if exist
In organization, where huge number of tables present in database. its very hard to search the particular table. Here few SQL queries to search the table name by pattern. Search For Table whose name starts with A Clustered Index speeds up performance of the query ran on that table. Clustered Index are usually Primary Key but [...]