Sql Server Codes (1211) - Page 20

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.
 
changing collation at column-level
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1058
View the current Collation of database in SQL Server
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1133
query to fetch the youngest student details from Class-3
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1165
  • query to get the total number of students in each class
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1388
    Fetching data of another server's table without using Linked Server
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1420
    Enable 'Ad Hoc Distributed Queries' in SQL server
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1529
    view the logic behind procedure in SQL Server
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1223
    we cannot perform Dml inside functions
    Posted by Bandi on 1/29/2015 under Sql Server category | Views: 1291
    changing/setting isolation level at query-level
    Posted by Bandi on 1/29/2015 under Sql Server category | Views: 1197
    can not create IDENTITY property on DECIMAL datatype with scale >0
    Posted by Bandi on 1/22/2015 under Sql Server category | Views: 2022
    Adding NOT NULL column to an exisitng table
    Posted by Bandi on 1/22/2015 under Sql Server category | Views: 1642
    Adding more than one new columns to a table in single ALTER statement
    Posted by Bandi on 1/22/2015 under Sql Server category | Views: 1359
    DENY user access to particular column of a table
    Posted by Bandi on 1/14/2015 under Sql Server category | Views: 1230
    Dynamic SQL usage in procedure
    Posted by Bandi on 1/14/2015 under Sql Server category | Views: 1245