I have recently been running into many different areas of SQL Server that I normally don’t mess with. One of them that has me confused is the area of Logins ..
Using MSSQL2005, can I truncate a table with a foreign key constraint if I first truncate the child table (the table with the primary key of the FK relationship)? ..
Is it true that SQL Server 2000, you can not insert into a table variable using exec? I tried this script and got an error message EXECUTE cannot be used as a source ..
I got the following entry in my database: images/test.jpg I want to trim the entry so I get: test So basically, I want everything after / and before . How can I solve ..
I have seen prefix N in some insert T-SQL queries. Many people have used N before inserting the value in a table. I searched, but I was not able to understand what ..
I’ve got a table that collects forms submitted from our website, but for some reason, when they created the table, they didn’t put a timestamp in the table. ..