Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 3833
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: 12138
Fetch the number of occurrences of ‘s’ in each employee name
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1279
copy of table employee to new table Emp_Backup without data
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1404
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: 1713
Reorganizing Indexes
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1415
drop the existing Index and Recreate same index of a table
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1316
NON CLUSTERED ON PRIMARY KEY
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1377
    • we cannot create covering index with clustered
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1620
    query to get foreign key constraint names in the database
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1297
    Rename the table Department to new name as 'Dept_New'
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1363
    Update employee name replacing vowels (a,e,I,o,u ) with #.
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1320
    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: 1341
    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: 1287
    query to combine the employee information from two tables Emp and History
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1262
    List out the department id having at least four employees
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 4740
    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: 1394
    Find the most recently hired employee
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1236
    statement to drop the column from a table
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1182
    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: 1505
    SQL Server doesn't allow AFTER TRIGGER on VIEW
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1658