A Series of SQL Server basics to advanced level SQL Interview questions and answers that are commonly asked in interivew.
Assume that you have a table which contains alphabetic, numeric, alphanumeric string, and special characters and you are asked to fetch only alphanumeric string from… Read More »How to fetch alphanumeric string from table
617 total views, 3 views today
SQL Server indexes are used by queries to find data values quickly in tables and views. Basically it speed up the queries performance. You can… Read More »Difference between clustered index and non clustered index
972 total views
SQL Server update statement is used used to modify an existing records in a table, you can also update records in table based on some… Read More »How to Update from Select Statement in SQL
880 total views
Sometimes, you need to store multi language or multilingual data in any table column. Inserting a multilingual data into column without following some basics rules,… Read More »Insert multi language data in table
651 total views
Sometimes, you want to store the result of a stored procedure into table or temp table instead of returning the output. Storing output of stored… Read More »How to insert the result of a stored procedure into table
2,190 total views
Sometimes you need to format a date in specific format such as format a date time string YYYY-MM-DD hh:mm:ss. mmm to date MM:DD:YY. SQL Server… Read More »Date and Time Conversions in SQL Server
653 total views, 1 views today
Sometime you are required to validate the row counts for each tables in database. So getting a row counts for each tables either through using… Read More »Get Row Counts for all tables in SQL Server
2,785 total views, 1 views today
There are various in-built system catalog views, or metadata functions that you can use to check the existence of column in SQL Server tables. To… Read More »Check if column Exists or not in SQL Server Table
4,130 total views, 1 views today
You can script a table from database using a SQL Server Management Studio. SQL Server Management allows you to script out tables from database using… Read More »Script table in SQL Server
191 total views
You can generate a database scripts including the schema and the data by using the Generate Scripts option available in SQL Server Management Studio (SSMS),… Read More »Generate Database Scripts With Data in SQL Server
873 total views
Table Value Constructor (TVC) allows to group multiple rows of data in a single DML statement. It can be used as a part of either… Read More »Table Value Constructor
501 total views
Selecting a top n records for each category from any table, can be done easily using row_number function which generates a sequential integer to each… Read More »How to get TOP N records for each category
1,150 total views
The IDENT_CURRENT function returns the last IDENTITY value generated for any specific table or view on an identity column in any session and any scope.… Read More »IDENT_CURRENT Function
584 total views
How to find and separate the numbers, letters and special characters from string? Suppose you a column in table which contains a mix words which… Read More »Separate numbers, letters and special characters from string
1,102 total views, 4 views today
Xp_readerrorlog is a SQL Server extend stored procedure allows you read the contents of the SQL Server error log files. It allows you to read… Read More »How to Read SQL Server error logs using the xp_readerrorlog
1,351 total views, 4 views today
The sp_procoption is a SQL Server system stored procedure allows us to Set or clear a stored procedure for automatic execution when an instance of… Read More »SQL Server sp_procoption startup procedures
393 total views, 1 views today
How to change the Collation of table column to Case insensitive or Case sensitive? Lets prepare a sample table called DumpData, and insert few records… Read More »SQL change column collation to case sensitive
1,689 total views
How to copy or delete files from directory in SQL Server ? It can be done using xp_cmdshell which is SQL Server built in system… Read More »Copy or delete files from directory in SQL Server
1,833 total views, 1 views today
How to get a last access time for tables in SQL Server ? To get the last time when table was accessed in SQL Server,… Read More »Get a last access time for tables in SQL Server
8,639 total views
