Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 3550
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: 11957
Fetch the number of occurrences of ‘s’ in each employee name
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1186
copy of table employee to new table Emp_Backup without data
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1310
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: 1578
Reorganizing Indexes
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1305
drop the existing Index and Recreate same index of a table
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1209
NON CLUSTERED ON PRIMARY KEY
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1264
    • we cannot create covering index with clustered
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1514
    query to get foreign key constraint names in the database
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1193
    Rename the table Department to new name as 'Dept_New'
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1256
    Update employee name replacing vowels (a,e,I,o,u ) with #.
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1217
    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: 1247
    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: 1197
    query to combine the employee information from two tables Emp and History
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1165
    List out the department id having at least four employees
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 4616
    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: 1308
    Find the most recently hired employee
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1141
    statement to drop the column from a table
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1092
    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: 1426
    SQL Server doesn't allow AFTER TRIGGER on VIEW
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1522