Try: SELECT WO_BreakerRail.ID, indRailType.RailType, WO_BreakerRail.CreatedPieces, WO_BreakerRail.OutsideSource, WO_BreakerRail.Charged, WO_BreakerRail.Rejected, WO_BreakerRail.RejectedToCrop FROM indRailType LEFT OUTER JOIN WO_BreakerRail ON indRailType.RailCode = WO_BreakerRail.RailCode AND WO_BreakerRail.Date = @Date Thus adding AND WO_BreakerRail.Date = @Date onto the join
If the databases are on same server then do it like this, select * into DB_2.T1 from DB_1.[dbo].[T1] if you have databases on different servers than you have to create a linked server. On second thought you can generate “create tables scripts” and run them on second database
See the Introducing SQL Server Express Local DB Runtime presentation – gives a great overview. The huge benefit of LocalDB is that it’s real SQL Server – it’s a special version of SQL Server Express, but it basically supports everything that “real” SQL Server has – spatial data types, stored procedures – you name it. … Read more
You ask if you can have more than one primary key field and you most certainly can. You can have only one primary key, but that can consist of as many columns as you need to uniquely identify your rows. Use something like this when you are creating your table: CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName) … Read more
CREATE TRIGGER sampleTrigger ON database1.dbo.table1 FOR DELETE AS DELETE FROM database2.dbo.table2 WHERE bar = 4 AND ID IN(SELECT deleted.id FROM deleted) GO
As long as you have the right number of columns in your INSERT statement, and as long as all the values except KEYBOARD are some numeric data type, and as long as you have suitable permissions, this should work. INSERT INTO INVOICE VALUES( 1,1,’KEYBOARD’,1,15,5,75); SQL requires single quotes around text values. But not using column … Read more
Returning a Table Variable will make it a multi-statement table valued function and can be bad for performance due to the fact that it’s treated like a table except there are no statistics available for SQL Server to base a good execution plan on – so it will estimate the function as returning a very … Read more
For MySql, Check in the EXTRA column: SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘my_table’ AND COLUMN_NAME = ‘my_column’ AND DATA_TYPE = ‘int’ AND COLUMN_DEFAULT IS NULL AND IS_NULLABLE = ‘NO’ AND EXTRA like ‘%auto_increment%’ For Sql Server, use sys.columns and the is_identity column: SELECT is_identity FROM sys.columns WHERE object_id = object_id(‘my_table’) AND name=”my_column”
The two highest voted answers use a lot of deprecated tables that should be avoided. Here’s a much cleaner way to do it. Get all the tables on which a stored procedure depends: SELECT DISTINCT p.name AS proc_name, t.name AS table_name FROM sys.sql_dependencies d INNER JOIN sys.procedures p ON p.object_id = d.object_id INNER JOIN sys.tables … Read more
Have you tried the solutions presented here: Convert JS date time to MySQL datetime The title should be called “Convert JS date to SQL DateTime” I happened to need to do the same thing as you just now and I ran across this after your question. This is from the other post by Gajus Kuizinas … Read more