I have the same local and remote databases structure and I connect to remote database using linked server.
I want to write a trigger for one of my tables which has an ntext datatype field an as you know the trigger can\'t be written for n开发者_高级运维text datatype.
CREATE TRIGGER TR_SAMPLE INSTEAD OF DECLARE @ptrval varbinary(16) DECLARE @value1 varchar(8000) DECLARE @value2 varchar(8000)
Is there a way to know the lock history for a table? In example, a list with all the locks that occurred on a table between 8:00 and 9:00.
I have a small application where users can login and do whatever they do in there. The database structure regarding users is nothing fancy. There are three tables:
I tried the following on SQL-Server: create table #TmpLOGSPACE( DatabaseName varchar(100) , LOGSIZE_MB decimal(18, 9)
开发者_JAVA百科I have created a store procedure for updating the patient name in multiple tables. When Iexecute it, shows the error like
I want to insert a .jpg image into SQL server using simple INSERT query. I tried the following query in which was posted as an answer to the following question
i have a query that contains a series of 21 UNIONs, e.g.: CREATE VIEW dbo.USGovCurrencyOnHandBreakdown AS
I transfered data from our old SQL Server 2000 (SBS 2003) to another server running SQL Server 2008 r2 (Server 2008 r2 standard).
加载中,请稍侯......