Here is the best example of Cross Join and Inner Join. Consider the following tables TABLE : Teacher x————————x | TchrId | TeacherName | x———-|————-x | T1 | Mary | | T2 | Jim | x————————x TABLE : Student x————————————–x | StudId | TchrId | StudentName | x———-|————-|————-x | S1 | T1 | Vineeth | … Read more
Select non-persisted values with the VALUES keyword. Then use JOINs to generate lots and lots of combinations (can be extended to create hundreds of thousands of rows and beyond). Short and fast version (not that easy to read): WITH x AS (SELECT n FROM (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) v(n)) SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) FROM … Read more
Check your connection string. If you need help with it check Connection Strings, which has a list of commonly used ones. Commonly used Connection Strings: SQL Server 2012 Standard Security Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword; Trusted Connection Server=myServerAddress;Database=myDataBase;Trusted_Connection=True; Connection to a SQL Server instance The server/instance name syntax used in the server option is the same for all … Read more
Open up SQL Server Configuration Manager (search for it in the Start menu). Click on SQL Server Services. The instance name of SQL Server is in parenthesis inline with SQL Server service. If it says MSSQLSERVER, then it’s the default instance. To connect to it in Management Studio, just type . (dot) OR (local) and … Read more
Try this one – Query: SELECT database_name = DB_NAME(database_id) , log_size_mb = CAST(SUM(CASE WHEN type_desc=”LOG” THEN size END) * 8. / 1024 AS DECIMAL(8,2)) , row_size_mb = CAST(SUM(CASE WHEN type_desc=”ROWS” THEN size END) * 8. / 1024 AS DECIMAL(8,2)) , total_size_mb = CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2)) FROM sys.master_files WITH(NOWAIT) WHERE database_id = … Read more
You can look in sys.types or use TYPE_ID: IF TYPE_ID(N’MyType’) IS NULL … Just a precaution: using type_id won’t verify that the type is a table type–just that a type by that name exists. Otherwise gbn’s query is probably better.
create table my_table ( column_a integer not null, column_b integer not null, column_c varchar(50), primary key (column_a, column_b) );
Without any further information, which Database etc the best we can do is something like Sql Server SELECT TOP 1 * FROM Table ORDER BY ID DESC MySql SELECT * FROM Table ORDER BY ID DESC LIMIT 1
If both tables are truly the same schema: INSERT INTO newTable SELECT * FROM oldTable Otherwise, you’ll have to specify the column names (the column list for newTable is optional if you are specifying a value for all columns and selecting columns in the same order as newTable‘s schema): INSERT INTO newTable (col1, col2, col3) … Read more
The advantages are that you can use functions like LEN and LEFT on nvarchar(max) and you cannot do that against ntext and text. It is also easier to work with nvarchar(max) than text where you had to use WRITETEXT and UPDATETEXT. Also, text, ntext, etc., are being deprecated (http://msdn.microsoft.com/en-us/library/ms187993.aspx)