Get SqlConnection from DbConnection
Well, if both can share the same Connection String then I guess they’re both SqlConnection. Try this instead: var connection = rep.Database.Connection as SqlConnection;
sql
Difference between sparse index and dense index
Dense Index An index record is created for every row of the table. Records can be located directly as each record of the index holds the search key value and the pointer to the actual record. Sparse Index Index records are created only for some of the records. To locate a record: find the index … Read more
Using Prepared Statements to set Table Name
A table name can’t be used as a parameter. It must be hard coded. So you can do something like: private String query1 = “SELECT plantID, edrman, plant, vaxnode FROM [” + reportDate + “?]”;
T-SQL: SUSER_SNAME vs SUSER_NAME?
If you call the function without an argument they will both return the same value. But they do take different arguments: SUSER_SNAME() takes the varbinary(85) SID of a login as argument SUSER_NAME() takes the integer principal_id of a login You can verify this like: select suser_name(principal_id) , suser_name(sid) , suser_sname(principal_id) , suser_sname(sid) from sys.server_principals where … Read more
Can SQL Server Express LocalDB be connected to remotely?
No, SQL Server Express LocalDB doesn’t accept remote connections. The idea with shared network folder might work, but only if you are able to make sure the LocalDB instance is shutdown before you try to copy the file. Also keep in mind that only one LocalDB instance can have any given database file open at … Read more
How to open multiple .sql files in only one ssms instance
After spending most of my working day looking for the solution I finally found it. Thanks God, I was almost running out with this issue. Hope it helps somebody else!!!. Update: linked domain expired, so here’s what it said: Considering how integrated Microsoft tools usually are the result is frustrating when you tell Visual Studio … Read more
What does App=EntityFramework do in Sql connection string?
App and Application Name are simply a way for somebody debugging SQL Server to know which client is connecting to it. If you had a SQL Server that has several apps that used it, it might be hard to know which one was sending which statements. If each app used a different Application Name it … Read more
Stored Procedure parameter default value – is this a constant or a variable
It has to be a constant – the value has to be computable at the time that the procedure is created, and that one computation has to provide the value that will always be used. Look at the definition of sys.all_parameters: default_value sql_variant If has_default_value is 1, the value of this column is the value … Read more
INNER JOIN vs multiple table names in “FROM” [duplicate]
There is no reason to ever use an implicit join (the one with the commas). Yes for inner joins it will return the same results. However, it is subject to inadvertent cross joins especially in complex queries and it is harder for maintenance because the left/right outer join syntax (deprecated in SQL Server, where it … Read more
right join even if row on second table does not exist
use Left Join instead SELECT user.uid as uid, user.name as username, account.name as accountname FROM user LEFT JOIN account ON user.uid=account.uid