Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 3399
Home > Codes > Sql Server

Sql Server Codes (1211) - Page 19

Code snippets submitted by registered members. You can also post a code snippet or tips and win monthly prizes as well as gain community credit points.

1211 records found.
 
Post
Display the Student Name whose name is having the third letter as ‘A’
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 12073
Fetch the number of occurrences of ‘s’ in each employee name
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1245
copy of table employee to new table Emp_Backup without data
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1370
query to get foreign key constraint names in the database using INFORMATION_SCHEMA
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1665
Reorganizing Indexes
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1378
drop the existing Index and Recreate same index of a table
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1278
NON CLUSTERED ON PRIMARY KEY
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1341
    • we cannot create covering index with clustered
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1587
    query to get foreign key constraint names in the database
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1261
    Rename the table Department to new name as 'Dept_New'
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1329
    Update employee name replacing vowels (a,e,I,o,u ) with #.
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1293
    Fetch data from the employee table order by empname in asc and salary in desc
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1310
    query to fetch the employee name with department id inserted at the 4th position of the employee name
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1258
    query to combine the employee information from two tables Emp and History
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1224
    List out the department id having at least four employees
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 4698
    query to fetch the all the employee details who do not belong to any department
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1365
    Find the most recently hired employee
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1200
    statement to drop the column from a table
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1146
    Display the NAME of all employees who have atleast one VOWEL in their last name.
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1476
    SQL Server doesn't allow AFTER TRIGGER on VIEW
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1614