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: 1080
View the current Collation of database in SQL Server
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1175
query to fetch the youngest student details from Class-3
Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1198
  • query to get the total number of students in each class
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1426
    Fetching data of another server's table without using Linked Server
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1468
    Enable 'Ad Hoc Distributed Queries' in SQL server
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1574
    view the logic behind procedure in SQL Server
    Posted by Bandi on 1/30/2015 under Sql Server category | Views: 1257
    we cannot perform Dml inside functions
    Posted by Bandi on 1/29/2015 under Sql Server category | Views: 1319
    changing/setting isolation level at query-level
    Posted by Bandi on 1/29/2015 under Sql Server category | Views: 1229
    can not create IDENTITY property on DECIMAL datatype with scale >0
    Posted by Bandi on 1/22/2015 under Sql Server category | Views: 2075
    Adding NOT NULL column to an exisitng table
    Posted by Bandi on 1/22/2015 under Sql Server category | Views: 1693
    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: 1407
    DENY user access to particular column of a table
    Posted by Bandi on 1/14/2015 under Sql Server category | Views: 1255
    Dynamic SQL usage in procedure
    Posted by Bandi on 1/14/2015 under Sql Server category | Views: 1290