Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 1780
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: 12015
Fetch the number of occurrences of ‘s’ in each employee name
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1214
copy of table employee to new table Emp_Backup without data
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1330
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: 1617
Reorganizing Indexes
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1349
drop the existing Index and Recreate same index of a table
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1237
NON CLUSTERED ON PRIMARY KEY
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1294
    • we cannot create covering index with clustered
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1554
    query to get foreign key constraint names in the database
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1216
    Rename the table Department to new name as 'Dept_New'
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1288
    Update employee name replacing vowels (a,e,I,o,u ) with #.
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1248
    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: 1274
    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: 1215
    query to combine the employee information from two tables Emp and History
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1192
    List out the department id having at least four employees
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 4661
    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: 1332
    Find the most recently hired employee
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1174
    statement to drop the column from a table
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1119
    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: 1445
    SQL Server doesn't allow AFTER TRIGGER on VIEW
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1569