SQL 2016’s RLS Feature allows you to implement restrictions on data row access. You can use this business rule manager to enforce rules that are difficult to achieve through the
You can not use the ALTER TABLE statement in SQL Server to rename a column in a table. You can however, use the sp_rename stored procedure if you do not
It is quite easy to enumerate (list) all the possible SQL servers to which you want to connect. Here is a small example: using System;using System.Data;using System.Text;using System.Windows.Forms;namespace SqlServerEnumeratorCS{ public
The sp_MSforeachdb stored procedure helps you to do repetitive actions against all or some of the SQL Server instance databases. For example, this query: EXEC sp_MSforeachdb ‘USE [?]; EXEC sp_spaceused’
You can use the following query to rename an SQL Database: USE masterGOALTER DATABASE YOURDATABASENAME SET SINGLE_USER WITH ROLLBACK IMMEDIATEGOEXEC master..sp_renamedb ‘YOURDATABASENAME’,’YOUR_NEW_DATABASE_NAME’GOALTER DATABASE YOUR_NEW_DATABASE_NAME SET MULTI_USER GO The only problem,
A very quick way to import data from Excel into SQL Server through code is to execute the following query: SELECT * FROM OPENROWSET(‘Microsoft.ACE.OLEDB.12.0′,’Excel 12.0;Database=C:ExcelFileToImport.xlsx’, [SheetWhereDataIsLocated$]) This is known as
To find out what statements are running in SQL Server and what parameters have been passed, use SQL Profiler. This tool is included when you install SQL Server Management Studio.
Question: How can I fill a numeric field with a sequence of numbers using SQL? For example, I want a field named NUMBER to contain the numbers 1 for the
The Windows NT installation process for SQL servers from Oracle, Microsoft, IBM, Sybase, and Informix installs NT services. Not all products include a graphical tool that enables you to start