I need to create a schedule where I allocate a service provider to work for a client.
Eg: The Service Provider John will provide services to the customer
condo valley of the sun on the day March 15, 2016 from 10:00 am to 12:00 .
J...
I am using Sql Server Express, I have an instance installed in two virtual machines on the server, one of the installed instances is Sql Server 2008 , and the other is the Sql Server 2014
When executing the same query in both instances I h...
I have 2 SQL Server databases in my SQL Server Management Studio.
I would like to put a password in one of them, making it impossible to access it, is it possible?
I have a single table with some foreign key records repeated a maximum of 5 times according to entries, eg:
id_ok|fornecedor|valor_final|escolha|ativo|
--------------------------------------------
o_11 | DOPE |R$ 20800 | SIM | NOK |
o_...
I'm running a query in a view, but one of its fields is text, in this field the user can enter a date (xx / xx / xxxx) as well as any other type information. I would like to know how I can return only the records I can convert to date or how can...
I'm trying to log on to a SQL Server 2008 database, with the windows user accessing my published site in IIS.
I've configured Web.Config for windows authentication, set up the application pool, leaving identificador equal Aplication...
Since the tables PRODUTO , CATEGORIA and a CATEGORY can have several PRODUCTS , I'd like a select to be listed in a nvarchar column All PRODUCT.NAME of a CATEGORY .
Something like:
select concat( select p....
I have a sql query where it brings the total of a value entered into a date, however I want to show in the result the dates that generated zero, even though it does not contain information in the database, I always search in a period and the day...
I would like to know if there is any command that returns me the script of creating the foreign keys in SQL server, as well as the command sp_helptext I return the creation script of views and stored procedures for example.
Thanks
Good afternoon, we use SQL SERVER 2008 as the official database server and have the following query:
SELECT P.NOME AS [PROFESSOR],
STIPOCURSO.NOME AS [NÍVEL DE ENSINO],
SPL.CODPERLET AS [ANO],
ST...